Re:Databases in 2025: A Year in Review
by WJW on Monday January 05, 2026 @05:34AM
(#46497235)
Couple thousand simultaneous should be fine, depending on total system load, whether you're running on spinning disks or on SSDs, p50/99 latency demands and of course you'd need to enable the WAL pragma to allow simultaneous writes in the first place. Run an experiment to be sure about your specific situation.
[ Parent
| on HN ]
Re:Databases in 2025: A Year in Review
by laurencerowe on Monday January 05, 2026 @05:31PM
(#46506018)
You also need BEGIN CONCURRENT to allow simultaneous write transactions.
https://www.sqlite.org/src/doc/begin-concurrent/doc/begin_co...