sqlite-embedded
SQLite embedded database performance, WAL journal mode, busy timeouts, and concurrent access patterns.
Files1
View on GitHubSKILL.mdskills/sqlite-embedded/SKILL.md
GitHubSQLite Embedded Database Protocol
- Enable WAL mode on boot: PRAGMA journal_mode=WAL;
- Configure busy_timeout to 5000ms to eliminate SQLITE_BUSY locking errors.
- Wrap bulk insertions in an explicit transaction block for 100x speedup.