O'Reilly logo
  • Mario Moreno thinks this is interesting:

Journal Mode

When performing a transaction in journal mode, SQLite first writes all the current database content into a journal file, then updates the original database file with the changes from the transaction. If a transaction needs to be rolled back, the journal file’s contents can be replayed back into the original database file. When the content from the journal file is replayed into the database file, the database is returned to the previous state. When the changes need to be committed to the database, the journal file is simply removed from the file system.


Cover of Android™ Database Best Practices


Notar que primero se pasa todo lo de la BD al archivo journal.