3 ms·
Writing does not lock readers if you use the WAL feature (Write-Ahead Log, introduced in 2010) https://sqlite.org/wal.html https://sqlite.org/wal.html > WAL p
by hasenj 9y ago
Writing does not lock readers if you use the WAL feature (Write-Ahead Log, introduced in 2010)
https://sqlite.org/wal.html https://sqlite.org/wal.html
> WAL provides more concurrency as readers do not block writers and a writer does not block readers. Reading and writing can proceed concurrently.
- deafcalculus 9y agoRight. I meant it doesn't support concurrent writes.
- zaarn 9y agoOn any personal website, that shouldn't be much of a problem, most blogs have only a few writes at a time