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

--- Comment #42 from caulier.gil...@gmail.com ---
Hi Bruno,

This a long story, with plenty of technical difficulties.

Currently we have these kind of database supported :

- sqlite (local)
- Mysql (local)
- Mysql (remote)
- Mariadb (local)
- Mariadb (remote)

all use the QtSql plugin to access to database. So Postgresql is possible as a
plugin for this database already exists.

But accessing to th database is not enough. We need to manage tables and
contents, depending of database engine features. For ex, Mariadb and sqlite do
not provided the same functionalities and to manage relation between tables
need adjusted schema. This is done in an XML schema for the tables properties
depending of the database engine.

The rest of the code is factored in common Sql queries more and less portable.

The first database supported was sqlite2, now 3. Later Mysql is coming
following by Mariadb.

But in schema and implementation, for the remote databases, it still some
implementations to do and serious optimizations. Also, the database interface
do not permit yet current access from different digiKam instances.

So to add a new database support, we need to finalize all the features planed
for the remote support, and later Postgresql can be add safety.

VoilĂ 

Gilles Caulier

-- 
You are receiving this mail because:
You are watching all bug changes.

Reply via email to