[Rails] Re: Using Sqlite3 Activerecord with multiple clients

Ed
2006-02-20T05:50:12Z

Ed wrote:
> Hi,
>   Here is my problem. I have sqlite3 as the db backend for rails. In
> addition to Rails, I also have another process that is writing to the db
> file so that rails can read from the same db file and get updates. The
> rails is responsible mostly for reading (and displaying) but also it
> occasionally make modifications to it.
>   However it seems that the activerecord adapter for sqlite3 is locking
> the db file. In other words when I try to access the db file, I kept on
> getting "database is locked" error.
>   Am I wrong in choosing sqlite3 as the db backend? Also how do I make
> the activerecord to only lock the file when it write to the file?
>
> Thanks,
> ed

Can anyone please help?
Thanks.

--
Posted via http://www.ruby-forum.com/.