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 '18 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. – Renatho Azevedo Feb 7 '18 at 14:29

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, privacy policy and cookie policy

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