Hi, I know that sqlite3 uses reader-writer locks and I've read the part of FAQ that describes the multiple client access. But I'm still having a lot of problem.
I use sqlite3-ruby to access the database file with Rails/ActiveRecord. I also use sqlite3 C API to access the database file using C in my other client. I have another program that uses regular ruby code and sqlite3-ruby to access the same database file. I kept on getting database is locked error. I have busy-handler registered for all of them and the write should take only milliseconds (very simple write). All the programs do some writing. Is there a way to only lock the whole file when writing and not when reading? Actually, for anyone experienced in sqlite3, what's the correct way of using it in my situation? Thank you very much. --ed
