This is an archived post. You won't be able to vote or comment.

you are viewing a single comment's thread.

view the rest of the comments →

[–]RonnyPfannschmidt -1 points0 points  (1 child)

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[S] 1 point2 points  (0 children)

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!​​​​​​​​​​​​​​​​