Forum: Ruby on Rails Odd issue with SQLite & Rails

Announcement (2017-05-07): is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see and for other Rails- und Ruby-related community platforms.
18d3c84ca5a017fe3e96490afaea28aa?d=identicon&s=25 Richard Conroy (Guest)
on 2006-12-21 15:44
(Received via mailing list)
I was prototyping a gui using a SQLite-backed Rails (on Windows). I
a seperate Ruby script to populate an events table with filler data.
As part of some
discussion I got it into my head to just fill up the table and see what
of performance issues, metrics or database size issues I would be
to. The script was executed from the command line (i.e. 2 different

The script made Rails unresponsive for a start (just getting stack
when it tried to hit the DB), and eventually the script itself bombed

"SQLite::Exceptions::SQLException: unable to open database file"

Admittedly this script was a quick and dirty job with a 100.times
loop around it, but I expected SQLite to handle contention better than

Multiple processes accessing the database is going to be a core aspect
of a new project we are doing, and I was wondering if this is beyond
SQLite's capability, or if it can be configured in a way to have more
flexible contention.

I am curious if this is a problem with non-client server databases in
general. It strikes me that to control this kind of contention you need
some code between your calling application and your database engine,
or the DB adapter code in each process has to be a fair bit smarter
than it needs to be.

(I resent this post. Apologies if anyone got it twice)
This topic is locked and can not be replied to.