mysql db

[Gilles Caulier]

Hi,

For digiKam 6.0.0, the similarity database was extracted from core database
to prevent bloating data in most import database file.

similarity data are fingerprints computed over image, mostly 500 bytes per
images. Hosting these data in a dedicated database will speed up the core
database.

This point is true for sqlite and mysql. Look well the new settings in
Setup/Database dialog.

Gilles Caulier

2018-04-24 16:10 GMT+02:00 Markus Leuthold <digikam at titlis.org>:

> Hello Bert
>
> have a look at https://github.com/githubkusi/digikam_controlled_
> environment. It provides sample scripts exactly for your purpose
> (including the creation of a new user and some sample pics). Read the
> scripts before you execute them. Last tested with Digikam 5.7, I don't know
> if there was a schema update since.
>
> best, Kusi
>
> On 24 April 2018 at 09:28, bvdv <vdvbert at gmail.com> wrote:
>
>> Hello all,
>> I am creating a webinterface that interacts with the digicam database.
>> this way i will be able to rate,sort and tag my foto's with a tablet  in
>> front of the tv.
>> Is there anyplace or anyone that can provide me a dump from a mysql
>> database(latest version) with some sample data.
>> More in particular i need the create scripts for the database, tables,
>> triggers,... and some sample data(if possible).
>> I dont need the pictures.
>> the reason why i am asking is because this is a computer from work and i
>> cant install Digikam due to rescrictions.
>> Thx in advance,
>> Greetings Bert
>>
>>
>>
>>
>> --
>> Sent from: http://digikam.1695700.n4.nabble.com/digikam-devel-f1695701.
>> html
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-devel/attachments/20180424/cb29839d/attachment.html>