SQLite
A complete database in a single file.
SQLite is taught here in 3 lessons, running from The database in a file, and the sqlite3 CLI through to WAL mode, backups, and when not to use SQLite. Each lesson takes one topic, shows the working code, and links onward to the next, so the course can be read straight through in order.
| Track | Databases |
| Lessons | 3 |
| Level | Beginner |
| Reading time | about 39 minutes |
| Prerequisites | Helpful, but not required: Redis |
Lessons
- 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.
- Using SQLite from application codePrepared statements, transactions in bulk, and the concurrency rules that keep an embedded database from throwing SQLITE_BUSY.
- 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
FAQ
How long does the SQLite course take?
It has 3 lessons, about 39 minutes of reading. Expect roughly twice that if you type out and run every example.
Do I need prior experience for SQLite?
Not strictly. It helps to have read Redis first, because some lessons build on it, but every lesson explains its own assumptions.
What should I read after SQLite?
This is the last course in Databases right now. Browse the other tracks from the courses index to go sideways.
Last refreshed 2026-09-18.