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.
Comments
AllegroCache seems to scale very well (a billion objects).
Posted by: eh | November 22, 2005 01:06 PM
Yes, certainly true. Personally, of course, I am in favor of using object DBs when it is possible. On the other hand, they're not appropriate in those situations where you really do need to do a lot of joins (and not just as an artifact of the data model).
Posted by: Dan Knapp | November 22, 2005 03:38 PM
Elephant does indeed now officially support SQLite, and it works well, thanks to you, and the fact that we did integrate it and have tested it with each release.
Posted by: Robert L. Read | April 11, 2007 09:37 PM