Keyset pagination

The core idea

Keyset pagination resumes a listing after the last item's ordering values.

It suits a feed or a “next page” interface where the caller already has a position to continue from.

In this lesson

  • Skip rows or resume after values
  • Watch the boundary survive a deletion
  • What the cursor must carry
  • Choose for the interface

Continue reading

Pro unlocks video lessons, visual walkthroughs, full notes, diagrams, case studies, and implementations across the System Design archive.