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.
'I'll Add the Migration Later'... The Lies I Told Myself

'I'll Add the Migration Later'... The Lies I Told Myself

Comments
5 min read
How I Built a Dynamic Family Tree Generator with Graph Visualization

How I Built a Dynamic Family Tree Generator with Graph Visualization

Comments
1 min read
Which Database Should You Self-Host? SQLite vs MySQL vs PostgreSQL vs Redis

Which Database Should You Self-Host? SQLite vs MySQL vs PostgreSQL vs Redis

Comments
3 min read
Finding Rigth Database

Finding Rigth Database

Comments
3 min read
PostgreSQL Write Performance: What the Benchmarks Won't Tell You

PostgreSQL Write Performance: What the Benchmarks Won't Tell You

1
Comments 2
16 min read
I got tired of juggling 5 database GUIs, so I built one for all of them

I got tired of juggling 5 database GUIs, so I built one for all of them

1
Comments
3 min read
PostgreSQL Logical Replication: Setup, Monitoring & Troubleshooting

PostgreSQL Logical Replication: Setup, Monitoring & Troubleshooting

Comments
4 min read
PostgreSQL Design at Scale: Normalization vs JSONB (A Real-World Guide)

PostgreSQL Design at Scale: Normalization vs JSONB (A Real-World Guide)

1
Comments
4 min read
Why Application-Layer Audit Trails Fail (and How PostgreSQL Triggers Fix It)

Why Application-Layer Audit Trails Fail (and How PostgreSQL Triggers Fix It)

1
Comments
4 min read
Supabase as a Game Backend: A Practical Guide

Supabase as a Game Backend: A Practical Guide

Comments
13 min read
How to Export a PostgreSQL Database from a Docker Container (pg_dump Guide)

How to Export a PostgreSQL Database from a Docker Container (pg_dump Guide)

Comments
2 min read
MyDBA.dev vs Percona PMM: Deep PostgreSQL Intelligence vs Multi-Database Monitoring

MyDBA.dev vs Percona PMM: Deep PostgreSQL Intelligence vs Multi-Database Monitoring

Comments
4 min read
How OpenAI Serves 800 Million Users Without Sharding Postgres

How OpenAI Serves 800 Million Users Without Sharding Postgres

Comments
14 min read
Database Performance Optimization: A Practical Content Strategy for Engineering Teams

Database Performance Optimization: A Practical Content Strategy for Engineering Teams

Comments
3 min read
A Practical Guide to Database Migration: From Legacy Systems to Modern Infrastructure

A Practical Guide to Database Migration: From Legacy Systems to Modern Infrastructure

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