I'm starting to take a look at the data abstraction layer to be used. The two candidates are libdbi and libgda. Here's what I have found so far:
SQLite: latest stable version is 3.3.8 (Oct 9/06) MySQL: latest stable version is 5.0.24a PostgreSQL: latest stable version is 8.1.5 DB abstraction layer maintained? libgda: latest stable release 1.2.3 (Oct 31/05). They are preparing a 2.0 release (1.99.0 on the ftp site is dated Oct 18/06, 1.99.1 AKA 2.0Beta3 is dated Oct 26/06). Note that libgda *is* included in suse 10.0. Hmmm, why is the version 1.3.91? libdbi: latest release 0.8.1 (Nov 21/05). Not much except spam on the libdbi-devel mailing list for 2006. Some bugs were reported in Oct 2006 and one of the people listed as an admin on the SourceForge project page added a comment to the bug in Oct 2006. Note that libdbi is *not* included in suse 10.0 i.e. the software management tool doesn't find it. Support for SQLite 3? libgda: YES libdbi: NO (2.8.x) Support for MySQL 5.0.x? libgda: YES libdbi: ? Support for PostgreSQL 8.x? libgda: YES libdbi: ? For MySQL and PostgreSQL, I couldn't see what versions were supported by libdbi. The libgda web site (http://www.gnome-db.org/) does have a page with version info. Based on the maintenance and availability status, I think libgda is the clear choice. Since they are at beta3 already, the unstable branch would be better. Note that gda also supports XML databases, so that for an interchange format, we *could* use it instead. As another make-work project, gda could be used as an interface around ofx (or other format) input/output to provide a standardized API for data access. Phil _______________________________________________ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
