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

[Alessandro Rossini]

https://bugs.kde.org/show_bug.cgi?id=127321


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
implementation?
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
similar.

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.