SQLite, again

SQLite is slowing becoming a new standard.
It is fast, and has a growing number of features.

Useful settings

  1. PRAGMA journal_mode = wal;
  2. PRAGMA foreign_keys = true;
    Query, set, or clear the enforcement of foreign key constraints.
  3. PRAGMA busy_timeout=….;
    In milliseconds, the busy_timeout is associated with each connection to the database and as such you need to set the timeout for each connection.

Relevant reading