For me, I have a bunch of threads writing to the database. That is the only part I do multithreaded. (All my read queries are handled after all the data is written.) I just use the scoped_lock operator from the Boost library at the top of my function that does the bind and step calls. I pass a pointer to the class containing that function and the mutex object to all my writer threads. It seems to work great; I don't even have SQLite compiled with threading enabled. My write function starts a new transaction every few thousand writes.
> Hi Bill, > > When you say "handle read/write locking [your]self" do you > mean outside of SQLite in your code or by altering SQLite's > source code? > > What algorithm do you employ?