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.
OpenAI’s Postgres Architecture: A Brilliant Fix for a Billion-Dollar Mistake

OpenAI’s Postgres Architecture: A Brilliant Fix for a Billion-Dollar Mistake

18
Comments
13 min read
Database Migrations with Claude Code: Safe Schema Changes Without Breaking Production

Database Migrations with Claude Code: Safe Schema Changes Without Breaking Production

1
Comments
3 min read
SQL Joins & Window Functions

SQL Joins & Window Functions

2
Comments
2 min read
How We Built a Vector Database for SEC Filings Using PostgreSQL + pgvector

How We Built a Vector Database for SEC Filings Using PostgreSQL + pgvector

2
Comments
6 min read
How Feature Flag Rollouts Actually Work (Build One from Scratch in Java)

How Feature Flag Rollouts Actually Work (Build One from Scratch in Java)

9
Comments 4
12 min read
Alena Rybakina: “The path to becoming a PostgreSQL committer starts with your first review”

Alena Rybakina: “The path to becoming a PostgreSQL committer starts with your first review”

2
Comments
5 min read
How We Index 5000+ Minecraft Servers: Database Design and Search Architecture

How We Index 5000+ Minecraft Servers: Database Design and Search Architecture

3
Comments
4 min read
Open Source and the agentic wave

Open Source and the agentic wave

1
Comments
4 min read
MySQL vs PostgreSQL in 2026 — 7 key differences you should know before choosing

MySQL vs PostgreSQL in 2026 — 7 key differences you should know before choosing

Comments
7 min read
PostgreSQL vs MySQL vs MongoDB: The Definitive Database Comparison

PostgreSQL vs MySQL vs MongoDB: The Definitive Database Comparison

2
Comments
15 min read
How We Told a Stranger's Node Where Its Cache Should Be

How We Told a Stranger's Node Where Its Cache Should Be

3
Comments
6 min read
Digging into UUID, ULID, and implementing my own

Digging into UUID, ULID, and implementing my own

Comments
5 min read
Prisma vs Neon in 2026: Which One Do You Actually Need (Or Both)?

Prisma vs Neon in 2026: Which One Do You Actually Need (Or Both)?

Comments
9 min read
Database Connection Pooling with Claude Code: Prisma Singleton and PgBouncer

Database Connection Pooling with Claude Code: Prisma Singleton and PgBouncer

2
Comments
4 min read
Claude CodeでSoft Deleteパターンを設計する:論理削除・一括復元・削除後TTL

Claude CodeでSoft Deleteパターンを設計する:論理削除・一括復元・削除後TTL

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