3 ms·
> Only a single process can write to the database at any time; it does not support concurrent writers. I think you can do concurrent writing now with Write-Ahe
by umvi 5y ago
> Only a single process can write to the database at any time; it does not support concurrent writers.
I think you can do concurrent writing now with Write-Ahead Logging (WAL): https://www.sqlite.org/wal.html https://www.sqlite.org/wal.html
I've never tried it though, so I don't know how suitable it is for web apps that might potentially have multiple processes trying to write to the DB at the same time.
- srcreigh 5y agoThere is no concurrent writing with WAL mode
- teraflop 5y agoNope. In the default rollback-journal mode, SQLite supports either multiple readers or a single writer at a time. WAL mode improves this to multiple readers and at most one writer. But transactions in SQLite are often fast enough that this could still be acceptable for a lot of purposes, especially on an SSD.