SQLite with mod_perlby punkish (Priest)
|on Oct 02, 2010 at 20:11 UTC||Need Help??|
punkish has asked for the
wisdom of the Perl Monks concerning the following question:
I have been successfully using SQLite as a data store for my web applications, but now I am implementing a web site with mod_perl, and am running into database locking issues.
As expected, my entire web application is loaded by the Plack Apache handler (Plack::Handler::Apache2) when the web server is started. Well, the first db query creates a lock on the entire database, and any subsequent query that has to modify the db fails. Disconnecting the dbh is not an answer, as subsequent web queries will fail.
What is my way out? Can I use SQLite in a persistent web environment or not? Should I be looking for some other db store?
I am not a fan of MySQL, and don't want to use it. I could potentially use PostGres, but I'd rather use something lightweight, and preferably sql-based as using key/value databases such as Tokyo Cabinet would require learning a whole new way. I'd rather really use SQLite.
when small people start casting long shadows, it is time to go to bed