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.
I Almost Published a Chart Saying the Nifty Fell 51% in 2003. It Fell 16%. Here Is the Bug.

I Almost Published a Chart Saying the Nifty Fell 51% in 2003. It Fell 16%. Here Is the Bug.

Comments
5 min read
704 lines of SQL, 66,007 lines of JSON, and the one migration Drizzle never generated

704 lines of SQL, 66,007 lines of JSON, and the one migration Drizzle never generated

Comments
4 min read
A retry that refunds is a bug, so the refund lives in onFailure and nowhere else

A retry that refunds is a bug, so the refund lives in onFailure and nowhere else

Comments
4 min read
Normalization vs denormalization in a real Postgres schema: what I fixed, and the copy I kept

Normalization vs denormalization in a real Postgres schema: what I fixed, and the copy I kept

1
Comments 1
7 min read
PostgreSQL Connection Pooling in Go: What I Actually Tune in Production

PostgreSQL Connection Pooling in Go: What I Actually Tune in Production

1
Comments 1
5 min read
How to Schedule Marketplace Data Cleanup with App Cron (and Recover Cleanly)

How to Schedule Marketplace Data Cleanup with App Cron (and Recover Cleanly)

Comments
8 min read
Multi-Tenant SaaS Architecture on PostgreSQL: Silo, Bridge or Pool?

Multi-Tenant SaaS Architecture on PostgreSQL: Silo, Bridge or Pool?

Comments
5 min read
Two People Bought the Last Ticket. Both Got a Confirmation Email.

Two People Bought the Last Ticket. Both Got a Confirmation Email.

Comments 1
9 min read
How I Ran a Zero-Downtime Postgres Migration on a 180M-Row Table With Claude Code

How I Ran a Zero-Downtime Postgres Migration on a 180M-Row Table With Claude Code

Comments
7 min read
I Fixed a Pricing Disaster With a Database Branch

I Fixed a Pricing Disaster With a Database Branch

Comments
4 min read
Supabase RLS for a Next.js SaaS: The 7 Policies You Actually Need

Supabase RLS for a Next.js SaaS: The 7 Policies You Actually Need

Comments
4 min read
From 35 seconds to half a second: 70 faster dashboards in plain Postgres

From 35 seconds to half a second: 70 faster dashboards in plain Postgres

Comments
5 min read
Respaldo y recuperación de PostgreSQL con despliegue automatizado en la nube

Respaldo y recuperación de PostgreSQL con despliegue automatizado en la nube

Comments
6 min read
Fixture Databases or Disposable Servers: A Debate for Agent SQL Rehearsal

Fixture Databases or Disposable Servers: A Debate for Agent SQL Rehearsal

Comments
8 min read
Moving 530k Jobs from Supabase to Postgres on a Free Oracle VM (14s -> 47ms)

Moving 530k Jobs from Supabase to Postgres on a Free Oracle VM (14s -> 47ms)

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