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.
Un agente borró mi base de datos en producción: lo que mis logs dicen que el post viral de HN omite

Un agente borró mi base de datos en producción: lo que mis logs dicen que el post viral de HN omite

Comments
9 min read
An Agent Deleted My Production Database: What My Logs Say That the Viral HN Post Leaves Out

An Agent Deleted My Production Database: What My Logs Say That the Viral HN Post Leaves Out

Comments
8 min read
Why Your Supabase App Might Be Leaking User Data (and How to Fix It with RLS)

Why Your Supabase App Might Be Leaking User Data (and How to Fix It with RLS)

Comments
6 min read
I Built a Self-Hosted Uptime Monitor in 1 Week Because UptimeRobot Only Lets You Monitor One Site for Free

I Built a Self-Hosted Uptime Monitor in 1 Week Because UptimeRobot Only Lets You Monitor One Site for Free

3
Comments
2 min read
Every PostgreSQL MCP server eats your context window. Here's how I collapsed 4 into 1.

Every PostgreSQL MCP server eats your context window. Here's how I collapsed 4 into 1.

1
Comments
7 min read
Durable Database Design: Master PostgreSQL Partial and Functional Indexes in Laravel 🐘

Durable Database Design: Master PostgreSQL Partial and Functional Indexes in Laravel 🐘

Comments
3 min read
Debezium: CDC in Practice

Debezium: CDC in Practice

1
Comments
8 min read
How ORM Migrations Are Hiding Missing Indexes (And How to Actually See Your Database)

How ORM Migrations Are Hiding Missing Indexes (And How to Actually See Your Database)

Comments
2 min read
200-Line Outbox Pattern: ~90% Fewer Mystery Bugs

200-Line Outbox Pattern: ~90% Fewer Mystery Bugs

3
Comments 2
9 min read
Stop building dashboards. Start asking questions.

Stop building dashboards. Start asking questions.

Comments
2 min read
850x Faster PostgreSQL Writes With One Line of Python

850x Faster PostgreSQL Writes With One Line of Python

Comments 1
3 min read
XID Wraparound Recovery: The Runbook Your Database Needs Before It's Too Late

XID Wraparound Recovery: The Runbook Your Database Needs Before It's Too Late

Comments
4 min read
MyDBA.dev vs pganalyze: Which PostgreSQL Monitor Should You Choose?

MyDBA.dev vs pganalyze: Which PostgreSQL Monitor Should You Choose?

Comments
4 min read
How to Set Up a Staging Database from Production PostgreSQL (2026 Guide)

How to Set Up a Staging Database from Production PostgreSQL (2026 Guide)

Comments
7 min read
Complete Guide to CloudNativePG 1.29 + PostgreSQL 18 — Production Kubernetes Database Operator Setup

Complete Guide to CloudNativePG 1.29 + PostgreSQL 18 — Production Kubernetes Database Operator Setup

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