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.
Soft Delete vs Archive Table: The Choice That Haunts Your Queries

Soft Delete vs Archive Table: The Choice That Haunts Your Queries

Comments
6 min read
Stop Trusting Every WHERE Clause: Tenant Isolation in PostgreSQL

Stop Trusting Every WHERE Clause: Tenant Isolation in PostgreSQL

1
Comments
4 min read
UUIDv7 vs BIGINT Primary Keys: The 2026 Verdict

UUIDv7 vs BIGINT Primary Keys: The 2026 Verdict

Comments
7 min read
Picking a Data Store in 2026: 5 Questions Before You Reach for Postgres

Picking a Data Store in 2026: 5 Questions Before You Reach for Postgres

Comments
7 min read
Domain Events in Go Without a Framework

Domain Events in Go Without a Framework

Comments
8 min read
Your Repository Is Not Your ORM: Hexagonal Persistence in Go

Your Repository Is Not Your ORM: Hexagonal Persistence in Go

Comments
7 min read
HorizonDB preview: automate a reproducible lab with ARM

HorizonDB preview: automate a reproducible lab with ARM

Comments 1
5 min read
How I Built a Real-Time PostgreSQL WAL Reader in GO

How I Built a Real-Time PostgreSQL WAL Reader in GO

1
Comments
2 min read
Building an Authentication Starter: Lessons from Integrating Next.js, PostgreSQL, Prisma, and NextAuth

Building an Authentication Starter: Lessons from Integrating Next.js, PostgreSQL, Prisma, and NextAuth

Comments
4 min read
Two SQL primitives for when alert clustering gets it wrong

Two SQL primitives for when alert clustering gets it wrong

Comments
12 min read
I scanned my own Supabase project and found 17 tables anyone could read with the anon key

I scanned my own Supabase project and found 17 tables anyone could read with the anon key

Comments
4 min read
When PostgreSQL Isn't the Right Fit: Recognizing Workloads That Need Different Architecture

When PostgreSQL Isn't the Right Fit: Recognizing Workloads That Need Different Architecture

Comments
6 min read
UUIDv4 vs UUIDv7 in PostgreSQL: A B-Tree Index Performance Deep Dive

UUIDv4 vs UUIDv7 in PostgreSQL: A B-Tree Index Performance Deep Dive

Comments
4 min read
Engineering and security approaches used in open-source PostgreSQL backup tool Databasus

Engineering and security approaches used in open-source PostgreSQL backup tool Databasus

1
Comments
7 min read
I scanned 1,066 Prisma migrations. Here are the risky patterns that kept showing up

I scanned 1,066 Prisma migrations. Here are the risky patterns that kept showing up

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