journalSizeLimit

Queries or sets the maximum size limit for the rollback journal file in bytes.

This pragma imposes a limit on the size of the journal file. If a transaction caused the journal file to grow beyond this limit, the transaction is rolled back, and the operation that caused the growth will fail with an SQLITE_FULL error.

• A positive value sets the size limit in bytes.

• A value of -1 (the default) means there is no limit on the journal file size.

• A value of 0 has the same effect as 1, truncating the journal after each transaction.

This limit is only applicable to journal modes like DELETE, TRUNCATE, and PERSIST. It has no effect in WAL mode.

See also