On 2/13/18, Chris Brody <chris.br...@gmail.com> wrote:
> - Does this imply that a SQLite database may be left in some kind of
> unrecoverable, corrupted, or otherwise invalid state in case an
> application would terminate without calling sqlite3_close() on all
> open database connections?
No. The database might be left in a weird state, but it will
automatically recover the next time you or any other process opens the
Unless, that is, you try to get clever and delete the *-journal or
*-wal file or do something else that interferes with the automatic
recovery process. If you delete the information that SQLite needs to
recover then it won't, and the database will be left in its weird
state, which is now considered corrupt.
Do not do any of the bad things listed under
https://www.sqlite.org/howtocorrupt.html and you will be fine.
D. Richard Hipp
sqlite-users mailing list