Andears, SQLITE 3.5.x is thread safe when configured and compiled with --enable-threadsafe.
You can create multiple db connections to a single database. But only one connection will be allowed to write to the Database at a time. Take a look at http://www.sqlite.org/lockingv3.html http://www.sqlite.org/34to35.html (section 2.1.5 part about locking) Andreas Volz <[EMAIL PROTECTED]> wrote: Hello, I like to use sqlite3 from a multi-threaded application. The situation is that I've several threads that like to write into a single DB file and into the same table. I read something about sqlite is thread save. But I'm not sure how much. Is it allowed to open the DB file and table parallel multiple times from multiple threads? Do I've to take care of locking in my application or is this handled by sqlite? Or should I open only one DB handle and handle parallel access in my application and do the real access from one single point? So what is the correct way to access the same sqlite DB/table from multiple threads? regards Andreas ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
