delete | The default journaling mode. In this mode, the rollback journal is deleted when a transaction commits. |
truncate | The journal mode is truncated rather than deleted when a transaction commits (this is possibly faster as no modification of the directory entry is required). |
persist | |
memory | The journal is managed in memory. This is possibly faster at the risk of the database become corrupt. |
wal | Use a write-ahead log instead of a rollback journal. Ben Johnson thinks that WAL mode is generally the best mode to run SQLite in. Once set, this mode is persisted in the database. |
off | |