SQLite Cheatsheet 01 — SQLite Basics
Cheatsheet: SQLite CLI, types, tables.
Sqlite
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.