Tag
embedded-database
- May 2, 2026 SQLite File Layout: Pages, B-Trees, and the Freelist How a SQLite database maps tables onto fixed-size pages, what the 100-byte header records, and why overflow chains and free pages make the file behave the way it does. mobile computing
- Apr 21, 2025 WAL Frames, Read Marks, and What a Checkpoint Can Move How the write-ahead log appends frames instead of rewriting pages in place, how readers pin the log through read marks, and why a checkpoint is bounded by the slowest open reader. mobile computing