[SQLObject] SQLite threadsafety?

[Luke O. <lu...@me...>]

Hello -

Finally had need to use SQLObject with something besides Postgres, this time
SQLite (also, MSAccess vi mx.ODBC, but meh).

Quick question though: running into problems with multiple threads (Webware
servlets) hitting the db at the same time. This is on a single-user install
hence SQLite, but some of the pages make multiple requests to Webware at once.

Looking through it all, the pysqlite.sf.net webpage and my copy of the code
(rev1.17) both show a threadsafety of 1, and only supports one concurrent
cursor/query per connection. The SQLObject DBConnection code though assumes
better threadsafety, sharing a single connection. Is there a newer version of
SQLite that I'm just not finding, or is the SQLObject code wrong?

(The problem manifests itself because there is just a connection-level flag for
transactions in pysqlite, shared by all cursors of the connection. So BEGIN
and COMMIT calls start getting out of sync, failing at the sqlite level.)

- Luke

--
In Pursuit of Counterfactual Histories