[Rails] Using Sqlite3 Activerecord with multiple clients

Ed
2006-02-18T00:59:21Z

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

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