digikam and support of postgresql database

[philolilou]

Hello,

i use often Digikam, and i thought having a support of postgresql would
be great.

Postgresql is a great database, highly flexible, powerful and with
plugins like postgis (real spatial plugin), with possibility to use
triggers on events, personnalized data structures, and much more.

The possibilities are bigger than using a simple database like sqlite,
and i think it could help much for improve Digikam.

As example, the postgis plugin could help to create a function of
research pictures taken within a determined range, based on gps coordinates.

Another example could be in a networked environnement, pictures could be
stored on a computer, but database could be accessed from another pc by
another user who work with the first one by using digikam (collaborative
work)

Including support of Postgresql could improve functionnalities of Digikam.

This could help too to make it more popular, and more accessible.

Thanks for reading.


Philolilou

[Mica Semrick]

There is already mysql support. I'd prefer posgres to mysql/mariadb any day, but the option to have a database that can handle a huge collection is already included.

-m

On April 14, 2017 8:11:34 AM PDT, philolilou <[hidden email]> wrote:

Hello,

i use often Digikam, and i thought having a support of postgresql would 
be great.

Postgresql is a great database, highly flexible, powerful and with 
plugins like postgis (real spatial plugin), with possibility to use 
triggers on events, personnalized data structures, and much more.

The possibilities are bigger than using a simple database like sqlite, 
and i think it could help much for improve Digikam.

As example, the postgis plugin could help to create a function of 
research pictures taken within a determined range, based on gps coordinates.

Another example could be in a networked environnement, pictures could be 
stored on a computer, but database could be accessed from another pc by 
another user who work with the first one by using digikam (collaborative 
work)

Including support of Postgresql could improve functionnalities of Digikam.

This could help too to make it more popular, and more accessible.

Thanks for reading.


Philolilou

[Gilles Caulier-4]

See this entry in bugzilla :

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

Gilles Caulier

2017-04-14 18:04 GMT+02:00 Mica Semrick <[hidden email]>:

There is already mysql support. I'd prefer posgres to mysql/mariadb any day, but the option to have a database that can handle a huge collection is already included.

-m

On April 14, 2017 8:11:34 AM PDT, philolilou <[hidden email]> wrote:

Hello,

i use often Digikam, and i thought having a support of postgresql would 
be great.

Postgresql is a great database, highly flexible, powerful and with 
plugins like postgis (real spatial plugin), with possibility to use 
triggers on events, personnalized data structures, and much more.

The possibilities are bigger than using a simple database like sqlite, 
and i think it could help much for improve Digikam.

As example, the postgis plugin could help to create a function of 
research pictures taken within a determined range, based on gps coordinates.

Another example could be in a networked environnement, pictures could be 
stored on a computer, but database could be accessed from another pc by 
another user who work with the first one by using digikam (collaborative 
work)

Including support of Postgresql could improve functionnalities of Digikam.

This could help too to make it more popular, and more accessible.

Thanks for reading.


Philolilou