SQL backend for GnuCash 2

[Josh Sled]

On Sat, 2006-10-21 at 22:56 -0400, Phil Longstaff wrote:
> 1) target SQLite, PostgreSQL or MySQL directly in a QOF back end, or
> 2) target libdbi or another such layer (how many data layers do we
> want?) which would give us all three (SQList, PostgreSQL and MySQL
> immediately), or
> 3) target ODBC using iODBC which would give us even more databases we
> could connect to.
> 
> Is there any current vision for database use?  Of the 3 databases I've
> listed, I've only used MySQL.  SQLite would remove the need for an
> external db server, though embedded MySQL would also remove this. 

(2)/(3) is preferrable to (1), unless there's a *really* compelling
reason why we'd want to target a specific database.  It's hard to
believe any db-specific feature would be more compelling than working
against different dbs, though.

libgda is another option; it seems to support ODBC as well
(<http://www.gnome-db.org/Providers_status>).

We'd at least want to support sqlite and either PG or MySQL; the former
for the "I just want a data-file" crowd, and the latter for the "I want
to connect to a DataBase" group.  I think leaning towards the former
group is not unreasonable.


A good starting point for development would be to post an 80% idea of
the DB schema, as well as posting the legwork on constrating/comparing
libdbi and libgda so a decision can be made.  Ultimately, of course,
we'll need a new QOF backend... you can look at the existing PG backend
(and file (XML) backend) as examples.

There's another individual who's come around to
<irc://irc.gnome.org/gnucash> in the last month who's working along
similar lines; maybe he'll speak up here...

-- 
...jsled
http://asynchronous.org/ - `a=jsled; b=asynchronous.org; echo ${a}@${b}`
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
Url : http://lists.gnucash.org/pipermail/gnucash-devel/attachments/20061022/aaa9d3e9/attachment.bin