SQLite SQL, sqlite3 shell commands, schema design, query planning, indexing, PRAGMA tuning, JSON, FTS, backup, import/export, and troubleshooting patterns for application developers, local tools, embedded apps, and data workflows.
Category
SQLite Cheat Sheets
SQLite SQL, sqlite3 shell commands, schema design, query planning, indexing, PRAGMA tuning, JSON, FTS, backup, import/export, and troubleshooting patterns.
Popular in SQLite
Quick picks to get you started.
SQLite Triggers, Views, and Generated Columns Cheatsheet
CREATE VIEW, CREATE TRIGGER, audit logging, derived values, generated columns, and automation patterns in SQLite.
Updated 3/28/2026
SQLite Full-Text Search (FTS5) Cheatsheet
FTS5 virtual tables, MATCH queries, prefix search, phrase search, bm25 ranking, snippets, and highlighting patterns for SQLite search features.
Updated 3/28/2026
SQLite PRAGMA and Administration Cheatsheet
High-signal PRAGMA commands for foreign keys, cache, synchronous settings, page size, temp storage, health checks, and general SQLite administration.
Updated 3/28/2026
SQLite JSON Functions Cheatsheet
json_extract, json_set, json_each, JSON operators, generated columns, and practical JSON query/update patterns in SQLite.
Updated 3/28/2026
SQLite Import, Export, and Backup Cheatsheet
CSV import/export, SQL dumps, VACUUM INTO, backup copies, and repeatable data movement patterns for SQLite databases.
Updated 3/28/2026
SQLite Transactions, WAL, and Locking Cheatsheet
BEGIN modes, COMMIT and ROLLBACK, savepoints, WAL mode, busy timeouts, and concurrency patterns for SQLite applications.
Updated 3/28/2026
All SQLite sheets
11 published sheets · sorted by recently updated.
SQLite Triggers, Views, and Generated Columns Cheatsheet
CREATE VIEW, CREATE TRIGGER, audit logging, derived values, generated columns, and automation patterns in SQLite.
Updated 3/28/2026
SQLite Full-Text Search (FTS5) Cheatsheet
FTS5 virtual tables, MATCH queries, prefix search, phrase search, bm25 ranking, snippets, and highlighting patterns for SQLite search features.
Updated 3/28/2026
SQLite PRAGMA and Administration Cheatsheet
High-signal PRAGMA commands for foreign keys, cache, synchronous settings, page size, temp storage, health checks, and general SQLite administration.
Updated 3/28/2026
SQLite JSON Functions Cheatsheet
json_extract, json_set, json_each, JSON operators, generated columns, and practical JSON query/update patterns in SQLite.
Updated 3/28/2026
SQLite Import, Export, and Backup Cheatsheet
CSV import/export, SQL dumps, VACUUM INTO, backup copies, and repeatable data movement patterns for SQLite databases.
Updated 3/28/2026
SQLite Transactions, WAL, and Locking Cheatsheet
BEGIN modes, COMMIT and ROLLBACK, savepoints, WAL mode, busy timeouts, and concurrency patterns for SQLite applications.
Updated 3/28/2026
SQLite Indexes and Query Planner Cheatsheet
CREATE INDEX patterns, covering and partial indexes, EXPLAIN QUERY PLAN, ANALYZE, and practical tuning tips for SQLite queries.
Updated 3/28/2026
SQLite Joins, CTEs, and Window Functions Cheatsheet
JOIN patterns, recursive CTEs, ranking functions, running totals, and analytical SQL patterns for SQLite.
Updated 3/28/2026
SQLite CRUD and SELECT Cheatsheet
High-value SELECT, INSERT, UPDATE, DELETE, UPSERT, ORDER BY, LIMIT, and filtering patterns for day-to-day SQLite development.
Updated 3/28/2026
SQLite DDL and Schema Design Cheatsheet
CREATE TABLE, constraints, generated columns, foreign keys, defaults, and schema design patterns for production SQLite databases.
Updated 3/28/2026
SQLite CLI and Shell Cheatsheet
sqlite3 shell commands for opening databases, inspecting schema, formatting output, importing CSV, and scripting common interactive workflows.
Updated 3/28/2026