I wonder if it would be cool to be able to stream an in-memory database to a single chunk of memory, and to have SQLite initialize an in-memory database from a chunk of memory (perhaps, though, that isn't possible). That would allow you to do things like suck the entire contents of a file into memory and then use it as an in-memory database. And when you are done, you could write the whole thing back out to the file.
To be honest, I'm looking for workarounds for the problem of not being able to use SQLite databases from shared volumes on Mac OS X.
