.DB-JOURNAL File Extension
SQLite Rollback Journal File
3.4 | 72 Votes
What is a DB-JOURNAL file?
A DB-JOURNAL file is a temporary database file created by SQLite database management systems during a transaction between an application and a database. It contains a rollback journal, which is a temporary database that stores the most recent state of the database. DB-JOURNAL files are used to restore a database in case the application using the database crashes while executing a transaction.
DB-JOURNAL files enable the atomic commit feature in SQLite database management systems. This feature refers to when all changes to a database can be made in one transaction. This is made possible by rollback journal files, which are typically seen with the ".db-journal" extension.
DB-JOURNAL files are temporary and should only exist when a running transaction is occurring in an SQLite database then deleted once the transaction is committed. The file is located in the same directory as the .DB database file that is running the transaction. Also it bears the same name as the associated DB file except it includes the appended "-journal" extension. For example, a file named example.db is accompanied by a temporary example.db-journal during the transaction.