Hacker News new | ask | show | jobs
by sneak 2182 days ago
The whole job of sqlite is to handle the locking to keep such accesses safe.
1 comments

Ok, I see. I did some reading and it looks like this to me:

* the DB is supported by a backing file

* this backing file supports multiple read threads simultaneously but writes are locked via filesystem locks

* write performance with multiple writers is therefore dangerous

* read performance is good if no one is writing and consistent even if someone is