DDBI and SQLite Troubles

[Lars Ivar Igesund]

Chris R. Miller wrote:

> Max Samukha Wrote:
> 
>> On Thu, 05 Jun 2008 18:25:06 -0700, "Chris R. Miller"
>> <lordSaurontheGreat at gmail.com> wrote:
>> 
>> >In an insane fit of daring, I started chopping up a local copy of DDBI
>> >to figure out why I cannot get it to work with SQLite.  At first I was
>> >receiving cryptic messages like:
>> >
>> >Error: identifier 'SqliteDatabase' is not defined
>> >
>> >And I eventually tracked it down to a bunch of version statements in the
>> >SQLite section that prevent it from building SQLite support into the
>> >library.  Unfortunately, when I removed those statements it presented me
>> >with a host of errors associated with the library's internal workings.
>> >I've been working to correct them, but the steps aren't really pertinent
>> >to my question.
>> >
>> >Has anyone been maintaining the SQLite layer of DDBI, or is it either
>> >fix it or leave it if I want to use it?
>> >
>> >A quick trip to DSSS's lib folder (which was built from an unmangled
>> >copy) shows that all the drivers except for Infobase are basically not
>> >there (4KB lib files as opposed to 73KB for ib).  I think this means
>> >that no one has been maintaining SQLite.  Am I correct?
>> 
>> Have you tried to compile your program with -version=dbi_sqlite?
> 
> That would be where the massive host of errors issued forth.  I managed to
> recode the sqlite layer of DDBI enough to make it compile without
> incident.  Now it no longer has any prepared statement functionality, but
> I supposed I can't have everything...

PreparedStatement for Sqlite wasn't working in the first place, which is why
it was removed, but I'd love your patch for what you did. As for DDBI in
general, I've put up a message on the DDBI pages noting what the current
status/plan is.

-- 
Lars Ivar Igesund
blog at http://larsivi.net
DSource, #d.tango & #D: larsivi
Dancing the Tango