3 ms·
There are absolutely production web apps running sqlite as the datastore. The "one writer at a time and the rest queue" caveat is fine for most web application
by jddj 2y ago
There are absolutely production web apps running sqlite as the datastore.
The "one writer at a time and the rest queue" caveat is fine for most web applications when writes happen in single digit / low 10s of ms
- BaculumMeumEst 2y agoIs there documentation on how to configure SQLite in the manner you’re describing?
- jddj 2y agoFrom the performance angle, there's one quoted down thread at https://news.ycombinator.com/item?id=40656043 https://news.ycombinator.com/item?id=40656043 From the webapp angle check out, for example, pocketbase.io which is an open source Go supabase style backend which wraps sqlite. They have benchmarks etc available.