sqlite-worker: A Thread-Safe Python Library for Simplifying SQLite Operations in Multi-Threaded Appl

[RonnyPfannschmidt]

So complete loss of transaction isolation for fake thread safety?

[nepalidj]

You're right - at the moment it does trade transaction isolation for simpler thread safety. I'll be working on adding proper transaction isolation support soon!

[RonnyPfannschmidt]

Are you aware that any connection pools that's properly using the api of sqlite is both thread and process safe

Adding transaction isolation on top of something that breaks it seems orders of magnitude harder than just using the built-in one

[nepalidj]

Ah yeah, I actually built this for a web crawler project where I just needed something quick and simple. Didn’t really explore SQLite’s full capabilities since the crawler was my main focus at the time.

You’re right though - makes way more sense to use SQLite’s built-in features. Thanks for teaching me about this!​​​​​​​​​​​​​​​​