DConf Database Suggestion

Jamie McCracken jamiemcc at blueyonder.co.uk
Sat Apr 9 13:56:22 EEST 2005


I was wondering if it might be better to use libgda as an API to the 
backend rather than using the Sqlite API directly.

libgda provides backends for all the major databases including Sqlite, 
Postgres, Mysql, Firebird/Interbase, Oracle, Sybase, MS SQL server et al

Using it you can still have Sqlite as the default backend but also allow 
it to be used with all the other databases without any extra coding 
(Sqlite is the lowest common denominator SQL wise so it should not be a 
problem for the others).

libgda's dependencies are just glib, libxml2, libxslt so nothing exotic 
is needed.

One of the advantages of using a client/server RDBMS will be easy remote 
control and lockdown of settings. A DBA which most enterprises will have 
can easily use the SQL grant/revoke to prevent write access to tables 
that dconf utilises (something which might prove difficult to do with 
Sqlite as it has no user authentication). Indeed remote administration 
will also be most effective this way.


More information about the xdg mailing list