pragmas constant

List<String> const pragmas

Open-time PRAGMAs. TRUNCATE + synchronous=NORMAL survives process kill and is strictly required to enforce POSIX fcntl distributed locking across Docker Swarm nodes on NFSv4 (WAL bypasses POSIX locking via mmap).

Implementation

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