Efficient Pagination notes

Offset pagination and its problems You may have seen requests looking like https://api.example.com/posts?limit=10&offset=50. This is offset pagination. We are saying skip 50 rows and give me the next 10. SELECT * FROM posts LIMIT 10 OFFSET 50 -- "sk...