DBI/SQL backend

Nathan Buchanan nbinont at gmail.com
Sun Jun 15 04:42:47 EDT 2008

On Wed, Jun 11, 2008 at 8:58 PM, Phil Longstaff <plongstaff at rogers.com>

> I think the DBI/SQL backend is ready to try.  It is in the gda-dev2
> branch.  The GDA backend has been disabled and a DBI backend is enabled.
>  It assumes that the include files are in /usr/include/dbi/dbi.h and the
> driver files are in /usr/lib/dbd.  The only driver that the DBI backend
> supports is sqlite3.  I am using libdbi-0.8.2.  I assume later versions
> will work.  I don't know about earlier versions.  There is a compilation
> check that the header file is present, but no version check.
> No new URI types have been added.  If you try to open a file, it will
> check if it is an sqlite3 file, and will load it with sqlite3.  If it
> can't, it will revert to xml.  Save As will save a file as an sqlite3
> file.  The "Connect to Database" menu entry is still enabled but will
> (probably) fail.
> I don't have a windows compilation environment, so I haven't tried it on
> windows.

So, I got it compiled (with the gmtime fix) and it seems to run ok up until
I try to save as. When I choose save as and enter the desired file name I
get an error stating "Can't parse the URL C:\soft\test_file\test.db." This
happens with *all* names I enter, including *.gnc names, so something is
slightly broken ;) I suspect it's that windows formatted name problem again,
but can't spend time on it for the next few days.


> Please feel free to try it out and report any problems.  This is not yet
> ready for your real data, though it would be a good test to load your
> xml file and save-as an sqlite3 file.
> Phil
> _______________________________________________
> gnucash-devel mailing list
> gnucash-devel at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-devel

"Even if you are on the right track, you'll get run over if you just sit
there" - Will Rogers

More information about the gnucash-devel mailing list