News Score: Score the News, Sort the News, Rewrite the Headlines

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

© News Score  score the news, sort the news, rewrite the headlines