It would be nice to have a little server and client library which provided access to sqlite databases. I wrote one for the purpose of serving databases, and left the interface open so it could easily be used for serving sqlite databases.
When the client connects (using telnet or the client library), then opens a database, the server does not close the database until a timeout occurs. This allows many clients to use databases concurrently, without any opens or closes except the initial open and the close after timeout. The server is open-source, and available at: http://voydb.sourceforge.net/ http://sourceforge.net/projects/voydb/ has the source available. I have a newer version which doesn't use Berkeley, but uses an in-memory hash table (which it writes to the disk every once in a while). Anyhow, what do you think about the idea? Brandon