On Wed, Jan 26, 2011 at 10:56 AM, Ian Hardingham <[email protected]> wrote:
> Hey guys. > > I am under the impression that there is no concurrent access to a single > SQLite DB. Ie if thread A is performing a query, and thread B trys to > query, it will block until thread A is finished, no matter the query. > > 1. Is this correct? > It is true if A and B are attempting to share the same database connection. Access to the database connection is protected by a mutex. > > 2. Are there any fairly general workarounds of any kind? > Use a separate database connection for each thread. Or better: Use processes instead of threads, as threads are evil. > > Thanks, > Ian > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
