The chapters
Work through them in order. Each one explains an idea, hands you a program that gets it wrong, and ends with a check that walks every page: every row exactly once, in order, and no more work than the page needs.
- 01Pages and offsetsCase: The first page nobody sawoffsets, page numbers, edges15 min
- 02LimitsCase: The page with every recordlimits, defaults, page size15 min
- 03A stable orderCase: Musical chairstotal order, tie-breakers20 min
- 04CursorsCase: The feed that repeated itselfoffset drift, keyset cursors25 min
- 05Cursors on a sort with tiesCase: The price that hid recordscomposite keys, deep pages20 min
- 06Opaque cursorsCase: The cursor that forgot the questionopaque tokens, versioning20 min
- 07Knowing when to stopCase: The client that gave up earlyshort pages, has more, counts15 min
- 08Syncing changesCase: The update the sync never sawchange feeds, versions, clocks25 min