SQLITE3-JOURNAL

sqlite3-journal icon

SQLite temporary data

File type: Temporary file

This is a SQLite rollback journal, a temporary sidecar file that SQLite uses with a database to support transaction rollback and recovery. It belongs to the database whose filename precedes "-journal" and is not a separate database.

What is sqlite3-journal file?

File type category:
Temporary file

Date updated: November 15, 2026

SQLite creates this file when a database uses the rollback-journal mechanism. For example, a database named something.sqlite3 may have a corresponding file ending in .sqlite3-journal.

The journal stores copies of database pages needed to undo changes that have not been committed. This supports atomic commit and rollback, helping SQLite keep the database consistent if a transaction fails.

The journal is normally temporary, but its presence and lifetime depend on the transaction and SQLite's journal settings. If a process stops unexpectedly, the file may be needed for database recovery. Rollback journaling remains supported by SQLite on Windows, macOS, and Linux/Unix.

How to open sqlite3-journal file?

Do not open the journal by itself. Keep it with the matching database, then open that database using an application built with SQLite or the SQLite command-line shell. SQLite can read the journal as needed to roll back or recover the database.

How to convert sqlite3-journal file?

The journal cannot be converted on its own into a usable database or another data format. It depends on the corresponding database and its transaction state.

If you need an export, open the matching database with SQLite after recovery and export its contents from the database application or SQLite tooling.

Suggested software to open sqlite3-journal file:

Associated software actions with the sqlite3-journal file

Software apps that create sqlite3-journal files:

Microsoft Windows

Software applications that handle other tasks involving sqlite3-journal files:

Microsoft Windows

Apple macOS / Mac OS X

Related file extensions