Re:Consider SQLite
by copperx on Wednesday December 29, 2021 @02:09PM
(#29728656)
For the domain of webapps, where multiple concurrent writers are often expected, yes, I would say it's a stigma.
[ Parent
| on HN ]
Re:Consider SQLite
by usrbinbash on Wednesday December 29, 2021 @03:07PM
(#29729353)
Are they expected, or are the required?
Because, serializing db access through a single process only becomes a problem when the number of reads/writes get so large, that the process becomes a bottlenec.
And judging by the test the author of the linked article did, that would have to be a HUGE number.
That's only a theoretical limitation. 99% of all your typical insert / update / delete operations finish in the single digits of milliseconds, making the serial nature of SQLite writes a problem when you get north of 5000+ requests per second.