cursor-based pagination

RU: cursor-based pagination

A pagination strategy that uses an opaque cursor — typically the last row's ID or a composite sort key — instead of an offset to mark the position in a result set. Unlike OFFSET-based pagination, it stays fast regardless of page depth and handles concurrent inserts or deletes without skipping or duplicating rows.