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.
Scaling to 200+ Cities by Deleting 90% of My Database

Scaling to 200+ Cities by Deleting 90% of My Database

Comments 2
6 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
🐳 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
Why I don't trust AI with my query plans

Why I don't trust AI with my query plans

Comments
2 min read
Database Indexes Explained Like You're 5

Database Indexes Explained Like You're 5

Comments
7 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
Building a Polyglot Persistence Layer: When One Database Isn't Enough

Building a Polyglot Persistence Layer: When One Database Isn't Enough

Comments
18 min read
Django REST Framework: Mastering Serialization Patterns for Complex Data Models

Django REST Framework: Mastering Serialization Patterns for Complex Data Models

Comments
22 min read
RDS Multi-AZ Deployments: Building Resilient Database Infrastructure

RDS Multi-AZ Deployments: Building Resilient Database Infrastructure

Comments
16 min read
Boosting PostgreSQL Query Performance with Materialized Views

Boosting PostgreSQL Query Performance with Materialized Views

Comments
6 min read
How We Built View Notifications for Screen Recordings

How We Built View Notifications for Screen Recordings

Comments
6 min read
MongoDB vs PostgreSQL — 6 factors to consider when choosing your database

MongoDB vs PostgreSQL — 6 factors to consider when choosing your database

Comments
7 min read
Hexagonal Architecture: Escaping the Framework Trap with Ports and Adapters

Hexagonal Architecture: Escaping the Framework Trap with Ports and Adapters

Comments
18 min read
Migrating from Redis to PostgreSQL: Session Management Patterns

Migrating from Redis to PostgreSQL: Session Management Patterns

Comments
9 min read
Saga Pattern Deep Dive: When Choreography Beats Orchestration (And Vice Versa)

Saga Pattern Deep Dive: When Choreography Beats Orchestration (And Vice Versa)

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