SQLite is slowing becoming a new standard.
It is fast, and has a growing number of features.
- PRAGMA journal_mode = wal;
- PRAGMA foreign_keys = true;
Query, set, or clear the enforcement of foreign key constraints.
- 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.
- Hosting SQLite databases on static github pages
- Distinctive Features Of SQLite
- SQLite Autoincrement
- SQLite FAQ
- Why SQLite succeeded as a database (Hacker News)
- SQLite small blob storage: 35% Faster Than the Filesystem (Hacker News)
- SQLite: Small, Fast, Reliable – Choose any three (Hacker News)
- Replicated SQLITE (give a try)