[elephant-devel] SQLite 3 support - fixed

[Robert L. Read]

Dear Dan,
    Your patch works for me.
    By that I mean:
    1)  It doesn't break any of the existing tests,
    2)  It passes all of the tests except the migration tests (and that
is a bug in the way 
I wrote the tests, almost certainly.)
    3)  Although I have not specific test for it, the problem of
treating "nil"s as unbound 
was one that I had noticed and wondered about, it is very nice that you
have fixed it.

Unfortunately, your patch has revealed some weaknesses in my tests, and
also in 
the way that I construct the controllers (as you no doubt noted, I had
hard-wired them to Postgres
with a comment, but your successful use of SQLite 3 now makes it
essential that I make 
that more completely configurable.  Also, I have not yet gone through
your patch line-by-line,
but thanks to your debugging notes, I have every confidence that I will
accept them.

I have some questions for you:
1) I assume from you email that you did in fact migrate data from BDB to
SQLite 3?
2) Which LISP are you using?
3) Although I can reconstruct it, I would like a few lines that exhibit
the null/unbound 
problem as you tested it, so that I can build a test case around it.
(This will save me 
some time and give me more confidence.)

So again I thank you for this patch, and since I am on a roll I hope to
continue working 
on this until I can get the branch properly released.



On Tue, 2005-11-22 at 04:27 -0500, Dan Knapp wrote:

>   Enclosed, find my patch against SQL-BACK-END to make Elephant work
> with SQLite 3.  I have also attached the detailed notes I took while
> debugging, since they'll probably be of interest to Robert.  There may
> be a couple small changes in the patch not explained in the notes...
> ask me if it's unclear.  The notes are stream-of-consciousness stuff,
> so don't expect them to be concise or direct.
> 
> 
>   The main problem was a bug in how slot values were decoded.  The
> actual connecting to the database and exchanging sql with it went
> without a hitch.
> 
> 
>   I needed the Berkely DB support to continue working, so that I could
> migrate my data, so I fixed one small bug there and changed the
> library path to where fink installs it - I used the "db43*" packages.
> 
> 
>   I tested this all on OS X:
> 
> 
> Darwin mt-kukulu.local 8.2.0 Darwin Kernel Version 8.2.0: Fri Jun 24
> 17:46:54 PDT 2005; root:xnu-792.2.4.obj~3/RELEASE_PPC Power Macintosh
> powerpc
> 
> 
>   I used clsql-3.4.6, uffi-1.5.7, and the version of sqlite which came
> with the OS, 3.0.8.6.
> 
> 
>   Tell me how it works for you!
> 
> 
> 
> 
> 
> 
> 
> -- Dan Knapp
> 
> 
> 
> 
> _______________________________________________
> elephant-devel site list
> elephant-devel at common-lisp.net
> http://common-lisp.net/mailman/listinfo/elephant-devel
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.common-lisp.net/pipermail/elephant-devel/attachments/20051122/e36b71ac/attachment.html>