[Digikam-devel] status of splitted configs for images and thumbnails databases

[Francesco Riosa]

     ... it's not good for release

I was programming to be able to fix the issues in the month release 
cycle but had overestimated my free time and problems involved.

The mentioned issues are:

1) the user interface is suboptimal see attached screenshots, it should 
at least provide a button to copy the options from one db config to the 
other.
Better the widget should open with only one database config visible (if 
database are currently the same) and go to a double set of options only 
on user request.

2) Removal of mysql "internal database" option, this one has been 
completely untested by me, I've strong feeling nobody is using it (even 
under windows).
But we need a large survey on our users, because I do want to remove the 
functionality /without/ migration plan. That's clearly not possible if 
we have at least one user of internal database.
Rationale for removal is:
- the mysql forks are increasing, there is a real possibility that 
distro will start using these forks, while most provide at least some 
compatibility as client (for us it's abstracted by qtSql) no-one of the 
executable tools will be guaranteed to be there and named the same.
- It's wrong, wrong, wrong, sqlite is an embedded database, has some 
limitations and inconsistencies (see problems on btrfs) but it's born to 
be embedded and does it well (it's the de facto standard). Mysql is a 
system/global database - period -

3) there are isolation problems at connection level, some query intended 
to run on thumbnails database are executed on the images one. While this 
should be easy to fix make me think there are more issues waiting to be 
discovered. Those require an in deep look which should be done relaxed 
and not under release pressure.
https://bugs.kde.org/show_bug.cgi?id=281838

so it's ok if I do revert the few commits that are related to splitted 
config and continue my work in sql/2.0 branch until it's more palatable?

migrating should be easy enough
https://bugs.kde.org/show_bug.cgi?id=281767
Comment #28
Comment #45

sorry,
Francesco

-------------- next part --------------
A non-text attachment was scrubbed...
Name: DbMigration_after201109_step07.png
Type: image/png
Size: 15607 bytes
Desc: not available
URL: <http://mail.kde.org/pipermail/digikam-devel/attachments/20110920/6202d458/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: DbMigration_pre201108.png
Type: image/png
Size: 11695 bytes
Desc: not available
URL: <http://mail.kde.org/pipermail/digikam-devel/attachments/20110920/6202d458/attachment-0001.png>