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