[Digikam-devel] [Bug 127321] allow use of other database backends such as postgres and mysql

Alessandro Rossini me at alessandrorossini.org
Mon Mar 1 15:36:49 GMT 2010


Alessandro Rossini <me at alessandrorossini.org> changed:

           What    |Removed                     |Added
                 CC|                            |me at alessandrorossini.org

--- Comment #30 from Alessandro Rossini <me alessandrorossini org>  2010-03-01 16:36:46 ---
Is there any plan to adopt foreign keys in the upcoming SQLite/MySQL database
I think that adopting foreign keys would avoid many of the current triggers in
the database definition, and I guess that the database would be more efficient.
I have managed to add foreign keys to the current database definition (see
attachment). Note that SQLite version 3.6.19+ is needed to execute these
statements (see http://www.sqlite.org/foreignkeys.html).
The only shortcoming I have noticed so far is that the icon column of the
Albums table can not refer to the id column of the Images table, since this
would generate a circular dependency between the Albums and Images tables.
However, this would be easily solved by adding a new AlbumIcon table or

Best regards.

Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

More information about the Digikam-devel mailing list