Cursor Pagination Beats OFFSET Once Your Table Grows
Most pagination starts life like this:
SELECT * FROM posts
ORDER BY created_at DESC
LIMIT 20 OFFSET 4000;
It's simple, and on a small table it's fine. But OFFSET has two problems that show up as you
kantclaude.hashnode.dev2 min read