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.
Connection Pool Sizing in 2026: The Formula and the Footguns

Connection Pool Sizing in 2026: The Formula and the Footguns

Comments
7 min read
Read Models Without a Second Database: CQRS-Lite Projections in PHP

Read Models Without a Second Database: CQRS-Lite Projections in PHP

Comments
7 min read
Building a multi-tenant RAG pipeline with Postgres. Part 0: Overview

Building a multi-tenant RAG pipeline with Postgres. Part 0: Overview

Comments
4 min read
Designing the Right PostgreSQL Index Using Query Plans and Statistics

Designing the Right PostgreSQL Index Using Query Plans and Statistics

1
Comments
8 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
Stop Trusting Every WHERE Clause: Tenant Isolation in PostgreSQL

Stop Trusting Every WHERE Clause: Tenant Isolation in PostgreSQL

1
Comments
4 min read
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
Your Repository Is Not Your ORM: Hexagonal Persistence in Go

Your Repository Is Not Your ORM: Hexagonal Persistence in Go

Comments
7 min read
Domain Events in Go Without a Framework

Domain Events in Go Without a Framework

Comments
8 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
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.