From Dev.to
Designing Cursor Pagination: Why Offset Hits a Wall
Quick answer: Offset pagination is simple and correct for static, small result sets, but it breaks down on live data: as rows are inserted or deleted between requests, pages skip or duplicate records,...