News for hackers. Stuff that matters.
Re:Go and SQLite in the Cloud by thomascgalvin on Thursday December 08, 2022 @04:02PM (#33913357)
No, because of SQLite's locking mechanism. It uses filesytem-level constructs to support concurrency, and this gets dicey, quickly.
Re:Go and SQLite in the Cloud by markusw on Thursday December 08, 2022 @04:49PM (#33914057)
As my test above shows, use a mutex for writes in Go directly and whatever locking performance problems SQLite exhibits disappear. I suspect because of the polling used in SQLite as described elsewhere on this page.