DConf Database Suggestion
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
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