mysql db

[bvdv]

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

[Gilles Caulier-4]

Where is hosted your web interface source code exactly ? on github ?

Why do you need mysql table only ? It do not work with sqlite ?

Do you record change on database directly ? What's happen if digiKam run on same database at the same time ?

Why not to use and extend the UPNP/DLNA support implemented in digiKam 5 which is standardized instead to re-invent the wheel ?

There are plenty on UPNP/DLNA application available on extra device which can query digiKam server and play with contents.

Best

Gilles Caulier

2018-04-24 9:28 GMT+02:00 bvdv <[hidden email]>:

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

[Markus Leuthold]

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 <[hidden email]> 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

[Gilles Caulier-4]

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 <[hidden email]>:

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 <[hidden email]> 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

[bvdv]

Thx for all the advice,

First i didnt know about the dlna export i did look into it, but i think
it's harder to extend then to write a simple webpage that can do what i
want. I will be the only one working on the database so the locking problem
will be no problem. I look into the provided links and post feedback and
progress here.



--
Sent from: http://digikam.1695700.n4.nabble.com/digikam-devel-f1695701.html

[Gilles Caulier-4]

The source code to DLNA server is given at this place :

https://cgit.kde.org/digikam.git/tree/core/utilities/mediaserver

The server is the same type than Kodi.

Gilles Caulier

2018-04-24 20:20 GMT+02:00 bvdv <[hidden email]>:

Thx for all the advice,

First i didnt know about the dlna export i did look into it, but i think
it's harder to extend then to write a simple webpage that can do what i
want. I will be the only one working on the database so the locking problem
will be no problem. I look into the provided links and post feedback and
progress here.

--
Sent from: http://digikam.1695700.n4.nabble.com/digikam-devel-f1695701.html