7 articles tagged with "postgresql"
Connection pools were invented to stop you from opening a new database connection per request. Serverless functions spin up a fresh process per request. These two ideas do not get along, and Postgres will tell you so at exactly 2am.
OFFSET pagination works beautifully in every demo and every code review, right up until a customer scrolls far enough to bring your database to its knees. Here's why, and what to do instead.
EXPLAIN ANALYZE is your database confessing exactly what it did and why it took so long. Most engineers run it, see a wall of text, and close the tab. Here's how to actually read the confession.
OFFSET-based pagination sounds innocent until your table hits a million rows and your database starts full-scanning just to skip the first 50,000. Here's why cursor-based pagination is the fix your API deserves.
Your API feels fine until it doesn't. The N+1 query problem is the most common database performance bug in ORM-heavy backends — and it hides in plain sight until your database is on fire.
Deleting a database row sounds trivial — until your boss asks why the customer record vanished and nobody knows. Here is how to pick the right deletion strategy before a production incident forces your hand.
Every time your app opens a fresh database connection for each request, you're making your database do a full handshake dance — expensive, slow, and embarrassing. Learn how connection pooling fixes this and why every production Node.js app needs it.