[Digikam-devel] [Bug 277242] After SQLite --> MySQL conversion, digikam reports error regarding DBThumbnailsVersion on start up.

[Francesco Riosa]

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





--- Comment #13 from Francesco Riosa <francesco+kde pnpitalia it>  2011-07-11 13:29:23 ---
(In reply to comment #12)
> I don't know much about all of this, but might i suggest that however the
> tables/databases are organized, that perhaps the tables that are meant to be
> for thumbnails all be have a prefix, e,g, ThumbnailDBSettings,
> ThumbnailDBUniqueHashes, ThumbnailDBFIlePaths .... etc.
> 
> This way, there are no name space clashes, which we're seeing above, and if the
> two databases are to be merged in the future, minimal effort will be needed to
> alter the sql code. 

let me precise that there will be always the possibility to have different
databases for thumbnails and images data, the digikam code also will always be
totally structured to support this, the "merging" I was thinking is more
something like - hardcopy the database name used for images to that of
thumbnails" _only_ for databases like mysql or postgres.

> 
> I played around with this idea in my local code base, however in the hour or
> two i was testing, i wasn't able to get a full understanding of all the
> instances of database queries.

it's a very good idea, but it require another migration and another version of
the database, it will not be done in 2.0

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