SQLite
summary
SQLite appears as a compact C library (roughly 500 KB compiled) that stores a whole database as a single-file library and ships on billions of devices (Android, iPhone, even ISS and old AOL CDs). It implements ACID semantics with both rollback-journal and WAL modes, supports multiple readers/one writer, pages up to 64 KB, a theoretical 140 TB file limit, row blobs up to 1 GB, 64-way joins and 2,000 columns, a three‑address bytecode VM, a Lemon parser, pluggable OS layer, and fully public domain source.
AI-written summary · about
chapters (24)
- 0:00Intro
- 1:49SQLite in a nutshell
- 4:33SQLite limits
- 7:40SQLite use cases
- 11:12Storage Decision Checklist FAIL!
- 12:26Apple, Inc
- 19:12Viewing Bytecode
- 21:03The SQLite Stack
- 25:56Lines of Source Code
- 27:17Rollback Journaling
- 30:49Rollback Mode Crash Recovery
- 31:39Write-Ahead Log
- 35:49Checkpoint
- 37:05Pager Summary
- 39:27Variable Length Integers
- 40:59Better B-tree Page Layout
- 41:58Logical View of SQL Index Storage
- 45:52B-tree Primitives
- 46:55B-tree Summary
- 47:22Virtual Machine
- 48:17Integer Type Codes
- 49:08Debug-Enhanced Shell
- 56:32The Importance of a Query Language
- 58:18Code Generator Summary
related talks
19mSQLite - The most overlooked database
48mSQLite – The everywhere database
45mSQLite. Incredibly Fast
31mSQLite, the World's Most Ubiquitous Yet Little-Known Database
24mgives databases to everyone
30mUse SQLite in production
34mEdge & Offline-First App Data Management in 5G devices
47mLumoSQL - updating SQLite for the modern age