There use to be a product called SQLite Server: http://www.sqlabs.net/sqliteserver.php - it has since been sold to Real Software (makers of RealBasic). This product as I understood it allowed for remote access to a SQLite database amongst other things. This got me to thinking. Is it practical to build some sort of queue system to have RoR talk to instead of SQLite directly? What I mean is, I can see situations where I want multiple users to use one SQLite database, since SQLite is not built for this it seems like a person could tack on a front end to SQLite that would queue the incoming requests and write them synchronously to SQLite. Its not always practical for me to install Postgres or MySQL on a client's system, sometimes SQLite is enough, but it would be nice to have it so as the user base grew you didn't have to worry about multiple users. Does something like this already exist? Does this even make sense to anyone else?
on 2007-01-15 22:02