SQLite Handbook

A hands-on English guide to SQLite — the serverless, single-file SQL database engine and its sqlite3 command-line shell.

Target SQLite 3.x (current stable 3.53.3)  |  Official docs: sqlite.org/docs.html  |  Each section splits into a Manual (quick reference) and Examples (scenario-based practice).
Last updated July 3, 2026

① SQLite Core

Manual

SQLite Manual

Reference for the engine model, the sqlite3 CLI, data types, DDL/DML, SELECT, JOINs, indexes, transactions, PRAGMAs, functions, and UPSERT.

Open the manual →
 Examples

SQLite Examples

Three reproducible scenarios — Beginner, Intermediate, Advanced — worked through against a fresh demo.db.

Open the examples →