Offset Pagination Step by Step (with Sharding)

Why pagination exists Imagine a workers table with 1,000,000 rows. A request like GET /workers that returns all of them would: send a huge JSON payload over the wire crash the browser trying to render it hammer the database The fix is simple: send a small slice at a time. That slice is called a pa