sqlite3 app.db 'PRAGMA journal_mode=WAL;'

Category: Databases & SQL

sqlite3 app.db 'PRAGMA journal_mode=WAL;'

Switch the database to WAL mode

WAL (write-ahead logging) lets readers keep working during writes and is the recommended journal mode for most applications. The setting persists per database file. Related: PRAGMA synchronous.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.