sqlite-embedded

SQLite embedded database performance, WAL journal mode, busy timeouts, and concurrent access patterns.

SKILL.md

GitHub

SQLite Embedded Database Protocol

  1. Enable WAL mode on boot: PRAGMA journal_mode=WAL;
  2. Configure busy_timeout to 5000ms to eliminate SQLITE_BUSY locking errors.
  3. Wrap bulk insertions in an explicit transaction block for 100x speedup.