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.
[ Parent
| on HN ]
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.