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?

  • Are you asking about 2 or more processes changing data in the same table, at the same time?
    – Oreo
    Feb 7, 2018 at 13:49
  • Yes it may occur at the same time. But, It probably cannot be achieved as the sqlite3 docs says. The one way is handle the lock state and trying again. Feb 7, 2018 at 14:29

1 Answer 1


A DELETE and/or an UPDATE are both writes!

Only one process can write at any one time - that is an INSERT, an UPDATE or a DELETE at the same time. You can SELECT with as many processes as you like, but only one of the others at a time!

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.