Notes: SQLite
SQLite settings
- PRAGMA journal_mode = WAL;
- Turns on write ahead log, allows for multiple concurrent readers.
- PRAGMA busy_timeout = 5000;
- As only one write can happen at a time, how long should a write command wait in the queue before erroring.
- PRAGMA foreign_keys = ON;
- Foreign key enforcing isn't enabled by default.
Types
- INTEGER
- The value is a signed integer, stored in 0, 1, 2, 3, 4, 6, or 8 bytes depending on the magnitude of the value. As soon as its pulled off disk and into memory it becomes an 8-byte signed integer.
- REAL
- The value is a floating point value, stored as an 8-byte IEEE floating point number.
- TEXT
- The value is a text string, stored using the database encoding (UTF-8, UTF-16BE or UTF-16LE).
- BLOB
- The value is a blob of data, stored exactly as it was input.
- NULL
- No data.
Further details
https://www.sqlite.org/datatype3.html