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 [EMAIL PROTECTED]
signature.asc
Description: This is a digitally signed message part
_______________________________________________ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
