From: Ammar Ali <ammarabuali@...>
Date: 2010-12-07T04:21:32+09:00
Subject: Re: Q: what database would you suggest?

On Mon, Dec 6, 2010 at 1:48 AM, David Masover <ninja@slaphack.com> wrote:
> One thing to be aware of with SQLite is that it essentially locks the entire
> database for any operations. This may affect you if your code is sufficiently
> multithreaded (and you use a Ruby which supports this, like JRuby) or if you
> intend to launch multiple worker processes. In either case, you may want to
> swap SQLite out for something else eventually.

I learned that the hard way. I innocently tried to fork a process that
used sqlite and the whole thing fell apart in not so obvious ways.
Many hours were wasted recovering from that one. So yes, safe sqlite
equals single process.

Regards,
Ammar