Cursor vs Offset Pagination Performance in PostgreSQL APIs
Why OFFSET cost grows with page depth in PostgreSQL, how keyset pagination keeps it flat, and when each fits your API under real load.
13 min read
Tag
pagination
REST API Pagination, Filtering and Sorting: One Contract
Learn why cursor pagination over a unique, indexed sort key beats offset pagination, and how to design filtering, sorting, cursors and limits as one contract.
14 min read
REST API Design: Resources, Status Codes and Consistency
Model resources as nouns, use HTTP methods and status codes per RFC 9110, and enforce conventions in CI so clients can predict every endpoint.
14 min read