A series of SQLite cheatsheets covering the embedded database used everywhere.
Start with Cheatsheet 01 — SQLite Basics .
SQLite Cheatsheet 01 — SQLite Basics
Cheatsheet: SQLite CLI, types, tables.
SQLite Cheatsheets
20 practical SQLite cheatsheets — embedded DB, WAL, perf.
SQLite Cheatsheet 02 — WAL Mode
Cheatsheet: WAL pragmas, checkpoints, concurrency.
SQLite Cheatsheet 03 — Schema and Indexes
Cheatsheet: schema, constraints, indexes.
SQLite Cheatsheet 04 — Query Optimization
Cheatsheet: EXPLAIN, query planner, ANALYZE.
SQLite Cheatsheet 05 — Full-Text Search (FTS5)
Cheatsheet: FTS5 virtual table, search, highlight.