4 ms·
> Is using SQLite from multiple processes safe? Yes [0]. > The Python bindings weren't safe for concurrent access, is this still the case? I think they're sa
by polyrand 5y ago
> Is using SQLite from multiple processes safe?
Yes [0].
> The Python bindings weren't safe for concurrent access, is this still the case?
I think they're safe now [1]. The error message when using the connection from multiple threads is "outdated" [2].
[0]: https://www.sqlite.org/threadsafe.html https://www.sqlite.org/threadsafe.html
[1]: https://bugs.python.org/issue45613 https://bugs.python.org/issue45613
[2]: https://docs.python.org/3/library/sqlite3.html#sqlite3.threadsafety https://docs.python.org/3/library/sqlite3.html#sqlite3.threa...
- stavros 5y agoExcellent, thank you! Combined with WAL mode, it sounds like SQLite is eminently usable for most of my use cases.
- meribold 5y ago> The error message when using the connection from multiple threads is "outdated" I think typically you'd still want to use one connection per thread because (for example) there can only be one transaction per connection at any given time.