api-designbackend
cursor pagination needs a stable order
Anonymous
Offset pagination is simple, but inserts or deletes before a page can shift its rows. Cursor pagination with a matching index can avoid scanning earlier pages. Include a unique tie-breaker when sort values can repeat.
0