On 2/13/18, Chris Brody <[email protected]> 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 [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
