Elephant with SQLite
November 22, 2005, at 04:30 AM
When I learned that CL-SQL supported SQLite, I was excited. See, sometimes you don't want to write a big client-server app; sometimes you want to save your data to a document that looks like a regular file, so that users can move and copy it by all the means they're used to.
But that was only the first half of the pipe-dream. Relational databases from an OO language are a pain; object databases have debatable scalability, but are far easier to work with. So naturally my question was, does Elephant's new SQL backend (written by Robert L. Read) work with SQLite?
And the answer was no. But a long night of debugging later, the answer is now yes! At least, for me. I've sent my patch off to the dev list, and hopefully it will be included into the final.