pragmas constant

List<String> const pragmas

Open-time PRAGMAs. WAL + synchronous=NORMAL survives process kill (only power loss can drop the WAL tail); both servers tolerate opening a database left in either journal mode.

Implementation

static const List<String> pragmas = [
  'PRAGMA journal_mode = WAL;',
  'PRAGMA synchronous = NORMAL;',
  'PRAGMA busy_timeout = 5000;',
];