DBI/SQL backend

[Phil Longstaff]

Nathan Buchanan wrote:
> 
> On Wed, Jun 11, 2008 at 8:58 PM, Phil Longstaff <plongstaff at rogers.com
> <mailto:plongstaff at rogers.com>> wrote:
> 
>     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.

What's the "windows formatted name problem"?

I'm going to try to set up a windows dev envt for myself.

Phil