News for hackers. Stuff that matters.

A comment on Show HN: Switchboard – A mDNS based reverse proxy for personal infrastructure. Parent comment

Re:Show HN: Switchboard – A mDNS based reverse proxy for per... by sneak on Monday June 22, 2020 @04:20PM (#23605960)
The whole job of sqlite is to handle the locking to keep such accesses safe.
[ Parent | on HN ]
Re:Show HN: Switchboard – A mDNS based reverse proxy for per... by nawgszy on Tuesday June 23, 2020 @08:56PM (#23622619)
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

[ Parent | on HN ]