hard20 pts · first answer countspaginationsqlapi-design

Items missing between pages

An activity feed uses this cursor query. After a bulk import gave 300 rows the same created_at, users report items missing between pages. What is the fix?

SELECT * FROM events
WHERE created_at < $1  -- created_at of last row on previous page
ORDER BY created_at DESC
LIMIT 50;

A.Switch to OFFSET pagination for imported dataB.Use <= instead of < in the WHERE clauseC.Order by (created_at, id) and use both as the cursor: WHERE (created_at, id) < ($1, $2) ORDER BY created_at DESC, id DESCD.Increase LIMIT to 500 so ties fit on one page

← Welcome email sent twice Nonce-based CSP trade-off →