DEV Community

#postgres

Posts on tips and tricks, using and learning about PostgreSQL for database development and analysis.

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
PostgreSQL high availability with only 2 servers: where the third vote comes from

PostgreSQL high availability with only 2 servers: where the third vote comes from

Comments
5 min read
Optimistic vs. Pessimistic Locking in PostgreSQL & Node.js: Preventing Inventory Overselling

Optimistic vs. Pessimistic Locking in PostgreSQL & Node.js: Preventing Inventory Overselling

Comments 3
10 min read
How Postgres 19 checks foreign keys without running SQL

How Postgres 19 checks foreign keys without running SQL

1
Comments
6 min read
3 Production Security Pitfalls in Next.js App Router (And How to Fix Them)

3 Production Security Pitfalls in Next.js App Router (And How to Fix Them)

Comments 3
4 min read
Zillow data in TypeScript: detail enrichment changes the price baseline

Zillow data in TypeScript: detail enrichment changes the price baseline

Comments
7 min read
How I Used PostgreSQL Row-Level Security to Isolate 15+ SaaS Tenants

How I Used PostgreSQL Row-Level Security to Isolate 15+ SaaS Tenants

1
Comments 2
5 min read
Stripe sent the same webhook twice. Make fulfillment idempotent before it costs you

Stripe sent the same webhook twice. Make fulfillment idempotent before it costs you

5
Comments 3
5 min read
A failed payment still gets Premium, and the column that stops a retried Stripe event from undoing a cancellation

A failed payment still gets Premium, and the column that stops a retried Stripe event from undoing a cancellation

1
Comments 2
5 min read
Our search endpoint returns three fields, and its WHERE clause is copied out of an index definition on purpose

Our search endpoint returns three fields, and its WHERE clause is copied out of an index definition on purpose

Comments 2
8 min read
Every step was correct. The student still got refunded twice.

Every step was correct. The student still got refunded twice.

Comments 10
6 min read
Why I Ended Up Running Python Inside PostgreSQL to Validate XML

Why I Ended Up Running Python Inside PostgreSQL to Validate XML

Comments 2
10 min read
How to Connect Claude Desktop & Cursor to PostgreSQL Safely (Read-Only AST Validation & PII Masking with MCP)

How to Connect Claude Desktop & Cursor to PostgreSQL Safely (Read-Only AST Validation & PII Masking with MCP)

Comments
4 min read
How to monitor PostgreSQL connections, cache hit ratio and replication lag (and get paged before it hurts)

How to monitor PostgreSQL connections, cache hit ratio and replication lag (and get paged before it hurts)

Comments
4 min read
Managed Postgres pricing in 2026: eight providers compared

Managed Postgres pricing in 2026: eight providers compared

Comments 1
7 min read
The Lease Loop Is Not a Chat Completion

The Lease Loop Is Not a Chat Completion

1
Comments
7 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.