Posts tagged “Postgres”

Cursor vs offset pagination at page 4000. Cover graphic for a guide to keyset pagination in Node.js and Postgres APIs.

Coding

Cursor vs offset pagination: an API design that survives big tables and scrapers

Offset pagination was fast at launch; now deep pages hammer the database and one API key is walking every page. Here is when to switch to cursors and how.

Jason Fill August 21, 2026 6 min read

Idempotency keys stop double charges. Cover graphic for a guide to making POST retries safe with idempotency keys in Node.js and Postgres.

Coding

Idempotency keys in Node.js: safe retries for POST endpoints without double charges

A timeout, an automatic retry, and a customer charged twice. Idempotency keys make POST retries safe: here is a working Express and Postgres implementation, the status codes to return, and how long to keep keys.

Jason Fill June 3, 2026 7 min read

Find N+1 queries before users do. Cover graphic for a guide to detecting and fixing N+1 database queries in a Node.js API.

Monitoring

How to find N+1 queries in a Node.js API before your users do

An endpoint that's fast in development takes 900 ms for your biggest customer because it runs 201 queries. Find N+1 queries in a Node API with a per-request query counter and a test, then fix them with one batched query.

Jason Fill April 3, 2026 6 min read