<!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>
Thanks! This is excellent! If we can get this to work, it will be significant step forward in the <BR>
overall value of the Elephant package.<BR>
I will make this my highest priority upon returning from the Thanksgiving holiday next week.<BR>
In fact, I had meant to release SQL-BACK-END as Elephant 0.3 by now; this give me further<BR>
incentive to do that, although I will evaluate your patch first, as it would be very nice to <BR>
release Postgres and Sql-Lite support at the same time.<BR>
<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>