On 2/13/18, Chris Brody <chris.br...@gmail.com> wrote:
> I was wondering what would happen if there would be an application crash,
> system crash, or power failure while SQLite is updating the file header?
> Did I miss an explanation somewhere?
The content is replicated either in the rollback-journal or in the
write-head log (depending on whether or not you are in WAL mode) and
will be recovered automatically when the database is first opened
after power has been restored. See
https://www.sqlite.org/atomiccommit.html for further information.
D. Richard Hipp
sqlite-users mailing list