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.
MyDBA.dev vs Datadog Database Monitoring: PostgreSQL-Native vs Full-Stack Observability

MyDBA.dev vs Datadog Database Monitoring: PostgreSQL-Native vs Full-Stack Observability

Comments
4 min read
Your Stack Is Colonizing Itself — And You're Paying the Cognitive Tax

Your Stack Is Colonizing Itself — And You're Paying the Cognitive Tax

10
Comments 2
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
10 RAG Architecture Mistakes Fintechs Make in Their First Production Deployment

10 RAG Architecture Mistakes Fintechs Make in Their First Production Deployment

2
Comments 2
17 min read
Stop using UUID v4 as your database primary key

Stop using UUID v4 as your database primary key

Comments
2 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
Stop Crashing Your Database: Master Read Replicas in Laravel 🐘

Stop Crashing Your Database: Master Read Replicas in Laravel 🐘

Comments
3 min read
Postgres + pgvector vs Pinecone: A Production Benchmark to 50M Vector

Postgres + pgvector vs Pinecone: A Production Benchmark to 50M Vector

1
Comments
9 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
Build Once, Sell Twice: caching LLM analysis with pgvector

Build Once, Sell Twice: caching LLM analysis with pgvector

2
Comments
4 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
Database Connection Pooling — Why Your Serverless APIs Kill Postgres (2026)

Database Connection Pooling — Why Your Serverless APIs Kill Postgres (2026)

Comments
3 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
👋 Sign in for the ability to sort posts by relevant, latest, or top.