Keyset Cursors, Not Offsets, for Postgres Pagination
We're building Sequin, a Postgres CDC tool to streams and queues like Kafka, SQS, HTTP endpoints, and more. Efficient, correct pagination is paramount for our backfill process, so we use keyset cursors extensively.
You've probably heard about the limitations of offset/limit in Postgres. There are two primary concerns with this strategy:
Performance
Correctness (skipping rows)
A better alternative in most situations is keyset pagination. Keyset pagination solves performance issues. It promises ti...
Read more at blog.sequinstream.com