SQLite 3 · Pragmas and maintenance

Turn on write-ahead logging

Let readers and a writer work at the same time. The setting persists in the file.

PRAGMA journal_mode = WAL;

Official SQLite 3 documentation

More pragmas and maintenance commands

All pragmas and maintenance commands · SQLite 3 cheatsheet

Was this page helpful?