SQLite Forum

Database change counter in WAL mode
Login
I think it might be useful to update the change counter after each checkpoint; so that at least you can determine the change status of the database file after the log and index files are deleted.