I'd like to replace libdbi because they refused to change their use of time_t 
to avoid the 2038 bug, insisting that since *BSD use a 64-bit time_t, it's not 
a problem [1]. Furthermore, transactions are supported only in their new 0.9.0 
version which isn't available yet in the major distros.

Unfortunately, neither are any of the other potential solutions. ODB [2], which 
I find particularly impressive, is supported on Fedora, but not Debian/Ubuntu. 
AFAICT, Debian/Ubuntu package only libdbi and tntdb [3] for multi-db access 
libraries. Fedora has also approved SOCI [4], but apparently has not yet 
implemented the package.

There are some other solutions out there, but they either require compiling the 
backends into the main binary (OTL [5]) or they aren't flexible about 
object-schema mapping (Debea [6]), which makes backward-compatibility with our 
existing database difficult.

FWIW, ODB does provide debs and rpms on their download page.

Boost unfortunately does not provide a sql-abstraction library.

Rather than depending on one of these libraries, we could fork one into our own 
repository; if we did that with libdbi, we could even fix the time_t problem.

Thoughts?

Regards,
John Ralls

[1] http://sourceforge.net/p/libdbi/bugs/15/
[2] http://codesynthesis.com/products/odb/
[3] http://www.tntnet.org/tntdb.html
[4] http://soci.sourceforge.net/
[5] http://otl.sourceforge.net/otl3_compile.htm
[6] http://debea.net/trac
_______________________________________________
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel

Reply via email to