How SQLRite stores rows on disk: pages, B-trees, and a diff-based pager

A walkthrough of SQLRite's on-disk format — 4 KiB pages, cell-encoded B-trees per table and index, and a write-ahead log that only persists the pages that actually changed.