Topic

Database pagination

Techniques for handing a large query result to clients one page at a time, including LIMIT/OFFSET and keyset cursors, and the duplicate-or-gap problems that arise when the underlying data changes between pages.

Current clusters

build1 publisher

OFFSET 3 hands back a page-one row after a single insert above the window

A ten-row demo on dev.to shows OFFSET counting ranks that other people's writes keep moving, and the keyset cursor that replaces it needs an unchanging sort key, a unique tiebreaker, a tuple comparison and one index.

Publishers:dev.to

Reality

Evidence66
Adoption: Insufficient
Hype gap0
Incentives22
Confidence70