SQLite Forum

Sqlite connections isolated even after COMMIT
Login
Probably the reader is in a transaction that started before the writer
transaction, so that the reader continues to see the state of the database
before the new content was written.  Fix this by committing the reader
transaction and starting a new one.

The transaction may come about because you have a prepared
statement that is not finalized.