HowToCodePage

SQLite

A complete database in a single file.

💡
This course has 3 lessons. Start with the first one and use the next / previous links at the bottom of each lesson — the sidebar keeps the whole course in order.

Lessons

  1. The database in a file, and the sqlite3 CLIOne file, no server, dynamic typing — plus the CLI commands and pragmas that make it usable for real work.
  2. Using SQLite from application codePrepared statements, transactions in bulk, and the concurrency rules that keep an embedded database from throwing SQLITE_BUSY.
  3. WAL mode, backups, and when not to use SQLiteWhat the write-ahead log changes, how to take a consistent backup of a live database, and the workloads where another engine is the right answer.

More in Databases

SQL MySQL PostgreSQL MongoDB Redis

Last refreshed 2026-09-17.