#offset vs cursor pagination

Cursor-Based Pagination in Node.js: Why Offset Pagination Breaks at Scale

Most developers reach for offset pagination first. It is intuitive — page=3&limit=20 maps directly to OFFSET 60 LIMIT 20 in SQL. It works fine in ...