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 19's REPACK CONCURRENTLY swaps a five-second table lock for one under a second

PostgreSQL 19's REPACK CONCURRENTLY swaps a five-second table lock for one under a second

8
Comments
6 min read
GDPR data minimization with pg_duckdb: join Azure Blob facts to erasable customer data in Postgres

GDPR data minimization with pg_duckdb: join Azure Blob facts to erasable customer data in Postgres

Comments
14 min read
taming N+1 queries in Next.js edge routes with Prisma

taming N+1 queries in Next.js edge routes with Prisma

Comments 1
2 min read
Integer Money and Row Level Security in Postgres

Integer Money and Row Level Security in Postgres

Comments
3 min read
Five things restore-testing Supabase dumps turned up

Five things restore-testing Supabase dumps turned up

1
Comments
5 min read
An n8n ops platform for domain health, leads, and content

An n8n ops platform for domain health, leads, and content

Comments
4 min read
Test Your supabase-js Code Without a Server: An In-Process Backend for Vitest

Test Your supabase-js Code Without a Server: An In-Process Backend for Vitest

Comments
4 min read
7 Supabase RLS Mistakes That Leak Data in Expo Apps (and the SQL to Fix Them)

7 Supabase RLS Mistakes That Leak Data in Expo Apps (and the SQL to Fix Them)

Comments
4 min read
Forty-one columns in our schema are enums in TypeScript and plain text in Postgres

Forty-one columns in our schema are enums in TypeScript and plain text in Postgres

Comments
6 min read
Every line of a new support thread gets its own millisecond, because one transaction would stamp them all the same

Every line of a new support thread gets its own millisecond, because one transaction would stamp them all the same

Comments
6 min read
The Hidden Cost of Unoptimized REST API Payloads in Node.js

The Hidden Cost of Unoptimized REST API Payloads in Node.js

Comments
1 min read
Our standby received every change for five hours and applied none of them

Our standby received every change for five hours and applied none of them

Comments
2 min read
The Hour That Doesn’t Exist: Booking Slots Across Daylight Saving Time

The Hour That Doesn’t Exist: Booking Slots Across Daylight Saving Time

1
Comments
9 min read
Our whole database client is twenty lines, and three of its four options exist because of the connection pooler

Our whole database client is twenty lines, and three of its four options exist because of the connection pooler

Comments
6 min read
Fifteen numbers on one admin page, one round trip, and a row count Postgres never counts

Fifteen numbers on one admin page, one round trip, and a row count Postgres never counts

Comments
5 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.