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

10 RAG Architecture Mistakes Fintechs Make in Their First Production Deployment

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

Stop Crashing Your Database: Master Read Replicas in Laravel 🐘

Comments
3 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
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
850x Faster PostgreSQL Writes With One Line of Python

850x Faster PostgreSQL Writes With One Line of Python

Comments 1
3 min read
1.2.2 Semantic Analysis: Name Resolution, Type Checking, Catalog Lookup

1.2.2 Semantic Analysis: Name Resolution, Type Checking, Catalog Lookup

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