Foreign key in Sqlite database (digikam4.db)

[Nikhil Agarwal]

Dear Developers

I was inspecting `digikam4.db`, but I could not find foreign key in and of the tables in the Sqlite database (digikam4.db). I was wondering if that's how it was intended?

Thanks 🙂

Nikhil Agarwal

[Maik Qualmann]

Yes, that's right, the SQLite DB does not use foreign keys. digiKam's core database schema was created at a time when SQLite did not yet support foreign keys. In the future, if major changes to the database schema are necessary, we will certainly think about using foreign keys as well.

Maik

Am Mi., 3. März 2021 um 10:36 Uhr schrieb Nikhil Agarwal <[hidden email]>:

Dear Developers

I was inspecting `digikam4.db`, but I could not find foreign key in and of the tables in the Sqlite database (digikam4.db). I was wondering if that's how it was intended?

Thanks 🙂

Nikhil Agarwal