[issue27113] sqlite3 connect parameter "check_same_thread" not documented

Thomas Kluyver report at bugs.python.org
Thu Jun 2 17:39:21 EDT 2016


Thomas Kluyver added the comment:

Having watched the video of Dave's PyCon talk (thanks Dave), I think he's talking about using locking to control transactions, which presumably the sqlite bindings don't handle by themselves. But I don't *think* you need manual locking just to maintain database integrity. If that's the case, it's probably helpful to clarify it.

I'd probably suggest that if you want to write from multiple threads and control transactions (i.e. more than just individual INSERTs fired from different threads), it's probably easier to use separate connections and let sqlite handle the synchronisation than to synchronise them yourself.

----------

_______________________________________
Python tracker <report at bugs.python.org>
<http://bugs.python.org/issue27113>
_______________________________________


More information about the Python-bugs-list mailing list