[Digikam-users] Changing from sqlite to mysql (was: Re: dk 4.0 problems with cropping)

[Gilles Caulier]

Sqlite code has introduced recently an hazardous instability. It's a
UPSTREAM problem reported a lots of time in bugzilla here :

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

THe solution is to update sqlite3 AND QtSqlite plugin. This last one
is used in fact. digiKam do not use Sqlite3 library directly.

Sound like Sqlite3 have been updated without to update Qt plugin,
which has introduced a binary incompatibility.

Mysql is not the right solution. Mysql still experimental and alots of
problem need to be solved.

Here i updated SQlite3 and QTSlite plugin, ands digiKam do not crash.
Look well bug #329697 contents for details.

Gilles Caulier

2014-05-24 7:26 GMT+02:00 Dr. Martin Senftleben <drmartinus at drmartinus.de>:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hi Gilles and all others,
>
> Am 23.05.2014 22:30, schrieb Gilles Caulier:
>> fixed in current implementation. It will be published in 4.1.0
>
> thanks! Good that you could find the cause.
>
> I still have problems with the stability of digikam (in fact, this is
> a continuous problem). Every now and then it crashes (yesterday four
> times), often when there is no really heavy task is at hand, like when
> I click on an image to see a larger version of it, or when I want to
> open the editor.
>
> Now I was wondering if this could be because of the size of my
> collection. I'm using sqlite, that seemed sufficient when I started.
> Now I read that it's good for collections with up to 100.000 images,
> beyond that it would be better to use mySQL.
> I have about 280.000 files in my collection, while I'm not sure how
> many sidecar files are in this collection. I don't know if this would
> be relevant, but let's estimate some 20.000 images have sidecar files,
> so it still comes to more than double as many images as recommended
> for sqlite. So I would like to change to mySQL as database in the hope
> this will improve things. But how to go about it without losing any
> date like tags, descriptions etc.?
>
> Regards
>
> Martin
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1
>
> iEYEARECAAYFAlOALXMACgkQUmmuY48ByEgRQACeIUPBH4su1CgJMU7W3UihgOd3
> tzEAoLSjY1FxGE6RnoInfsLc/3+J8Umw
> =i9y4
> -----END PGP SIGNATURE-----
>
> _______________________________________________
> Digikam-users mailing list
> Digikam-users at kde.org
> https://mail.kde.org/mailman/listinfo/digikam-users
>