<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.3.2">
</HEAD>
<BODY>
Dear Dan,<BR>
Your patch works for me.<BR>
By that I mean:<BR>
1) It doesn't break any of the existing tests,<BR>
2) It passes all of the tests except the migration tests (and that is a bug in the way <BR>
I wrote the tests, almost certainly.)<BR>
3) Although I have not specific test for it, the problem of treating "nil"s as unbound <BR>
was one that I had noticed and wondered about, it is very nice that you have fixed it.<BR>
<BR>
Unfortunately, your patch has revealed some weaknesses in my tests, and also in <BR>
the way that I construct the controllers (as you no doubt noted, I had hard-wired them to Postgres<BR>
with a comment, but your successful use of SQLite 3 now makes it essential that I make <BR>
that more completely configurable. Also, I have not yet gone through your patch line-by-line,<BR>
but thanks to your debugging notes, I have every confidence that I will accept them.<BR>
<BR>
I have some questions for you:<BR>
1) I assume from you email that you did in fact migrate data from BDB to SQLite 3?<BR>
2) Which LISP are you using?<BR>
3) Although I can reconstruct it, I would like a few lines that exhibit the null/unbound <BR>
problem as you tested it, so that I can build a test case around it. (This will save me <BR>
some time and give me more confidence.)<BR>
<BR>
So again I thank you for this patch, and since I am on a roll I hope to continue working <BR>
on this until I can get the branch properly released.<BR>
<BR>
<BR>
<BR>
On Tue, 2005-11-22 at 04:27 -0500, Dan Knapp wrote:<BR>
<BLOCKQUOTE TYPE=CITE>
<FONT COLOR="#000000"> 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.</FONT><BR>
<BR>
<BR>
<FONT COLOR="#000000"> 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.</FONT><BR>
<BR>
<BR>
<FONT COLOR="#000000"> 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.</FONT><BR>
<BR>
<BR>
<FONT COLOR="#000000"> I tested this all on OS X:</FONT><BR>
<BR>
<BR>
<FONT COLOR="#000000">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</FONT><BR>
<BR>
<BR>
<FONT COLOR="#000000"> I used clsql-3.4.6, uffi-1.5.7, and the version of sqlite which came with the OS, 3.0.8.6.</FONT><BR>
<BR>
<BR>
<FONT COLOR="#000000"> Tell me how it works for you!</FONT><BR>
<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
<FONT SIZE="5"><FONT COLOR="#000000">-- Dan Knapp</FONT></FONT><BR>
<BR>
<BR>
<BR>
<PRE>
<FONT COLOR="#000000">_______________________________________________</FONT>
<FONT COLOR="#000000">elephant-devel site list</FONT>
<FONT COLOR="#000000"><A HREF="mailto:elephant-devel@common-lisp.net">elephant-devel@common-lisp.net</A></FONT>
<FONT COLOR="#000000"><A HREF="http://common-lisp.net/mailman/listinfo/elephant-devel">http://common-lisp.net/mailman/listinfo/elephant-devel</A></FONT>
</PRE>
</BLOCKQUOTE>
</BODY>
</HTML>