In Sqlite3, Write-Ahead-Logging mode allows one process to read a table, while another is writing to it. It doesn't say anything about one process writing and another deleting/updating.
Is this possible in Sqlite3?
concurrencysqlitewrite-ahead-logging
In Sqlite3, Write-Ahead-Logging mode allows one process to read a table, while another is writing to it. It doesn't say anything about one process writing and another deleting/updating.
Is this possible in Sqlite3?
Best Answer
A
DELETE
and/or anUPDATE
are both writes!Only one process can write at any one time - that is an
INSERT
, anUPDATE
or aDELETE
at the same time. You canSELECT
with as many processes as you like, but only one of the others at a time!