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.
Why I, as Someone Who Likes MySQL, Now Want to Recommend PostgreSQL

Why I, as Someone Who Likes MySQL, Now Want to Recommend PostgreSQL

26
Comments 4
13 min read
PostgreSQL connection pooling — PgBouncer vs Pgpool-II compared in 5 key areas

PostgreSQL connection pooling — PgBouncer vs Pgpool-II compared in 5 key areas

1
Comments
9 min read
Django + Docker Deployment: A Complete Production Guide

Django + Docker Deployment: A Complete Production Guide

2
Comments
6 min read
Building Production RAG Systems with PostgreSQL: Complete Implementation Guide

Building Production RAG Systems with PostgreSQL: Complete Implementation Guide

8
Comments 1
6 min read
Setting Up CocoIndex with Docker and pgvector - A Practical Guide

Setting Up CocoIndex with Docker and pgvector - A Practical Guide

20
Comments 2
5 min read
Database Transactions with Claude Code: Optimistic Locking, Deadlocks, and Saga Pattern (2026-03-11)

Database Transactions with Claude Code: Optimistic Locking, Deadlocks, and Saga Pattern (2026-03-11)

1
Comments
3 min read
Query Optimization with Claude Code: Fix N+1, Slow Queries, and Missing Indexes

Query Optimization with Claude Code: Fix N+1, Slow Queries, and Missing Indexes

1
Comments
3 min read
Partitioning PotgreSQL Database

Partitioning PotgreSQL Database

20
Comments
4 min read
7 PostgreSQL monitoring tools every DBA should know in 2026

7 PostgreSQL monitoring tools every DBA should know in 2026

Comments
7 min read
🐳 Fixing “FATAL: database does not exist” in PostgreSQL Docker (Healthcheck Mistake)

🐳 Fixing “FATAL: database does not exist” in PostgreSQL Docker (Healthcheck Mistake)

Comments
2 min read
I built an open-source PostgreSQL backup manager — self-host it in one command

I built an open-source PostgreSQL backup manager — self-host it in one command

1
Comments 1
1 min read
The Supabase Gotchas Nobody Warns You About (Until You Hit Them)

The Supabase Gotchas Nobody Warns You About (Until You Hit Them)

1
Comments
5 min read
Scaling Laravel + PostgreSQL: The 'Lateral Join' Pattern for High-Performance SaaS

Scaling Laravel + PostgreSQL: The 'Lateral Join' Pattern for High-Performance SaaS

2
Comments
5 min read
Why I don't trust AI with my query plans

Why I don't trust AI with my query plans

Comments
2 min read
From 8s to 47ms: Optimizing PostgreSQL for a Government Tender Search Platform

From 8s to 47ms: Optimizing PostgreSQL for a Government Tender Search Platform

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