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.
Don’t Trust Backups You Haven’t Restored

Don’t Trust Backups You Haven’t Restored

Comments
8 min read
WEB UI in Go? Nothing Can Stop Me!

WEB UI in Go? Nothing Can Stop Me!

Comments
6 min read
Why PostgreSQL EXPLAIN ANALYZE Can Mislead You — and What to Use Instead

Why PostgreSQL EXPLAIN ANALYZE Can Mislead You — and What to Use Instead

Comments
6 min read
Advanced PostgreSQL: JSONB, partial indexes and partitioning

Advanced PostgreSQL: JSONB, partial indexes and partitioning

Comments
7 min read
I Built My Backend on SQLite. Then I Deleted It.

I Built My Backend on SQLite. Then I Deleted It.

Comments
5 min read
pgbackrest Maintenance Has Stopped — How to Plan Your PostgreSQL Backup Migration

pgbackrest Maintenance Has Stopped — How to Plan Your PostgreSQL Backup Migration

2
Comments
5 min read
Reading PostgreSQL EXPLAIN and EXPLAIN ANALYZE Output

Reading PostgreSQL EXPLAIN and EXPLAIN ANALYZE Output

Comments
14 min read
PostgreSQL: debugging a slow query and optimizing it

PostgreSQL: debugging a slow query and optimizing it

Comments
9 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
17 min read
How I Built a Childcare Availability Platform for 38,000 French Nurseries

How I Built a Childcare Availability Platform for 38,000 French Nurseries

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

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

Comments
3 min read
6 Minutes to Finally Understand Why Postgres Keeps Winning

6 Minutes to Finally Understand Why Postgres Keeps Winning

Comments 1
4 min read
CQRS in Go — Part 4: PostgreSQL as an event store

CQRS in Go — Part 4: PostgreSQL as an event store

Comments
8 min read
Stop Leaking Tenant Data: PostgreSQL Row-Level Security in Laravel 🛡️

Stop Leaking Tenant Data: PostgreSQL Row-Level Security in Laravel 🛡️

Comments
3 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.