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 your Supabase mutations lie about their errors

Why your Supabase mutations lie about their errors

Comments 3
2 min read
'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
Why PostgreSQL and ClickHouse Work So Well Together

Why PostgreSQL and ClickHouse Work So Well Together

3
Comments 9
3 min read
Finding Rigth Database

Finding Rigth Database

Comments
3 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
Stop using UUID v4 for database primary keys — UUIDv7 is the 2026 default

Stop using UUID v4 for database primary keys — UUIDv7 is the 2026 default

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

PostgreSQL Logical Replication: Setup, Monitoring & Troubleshooting

Comments
4 min read
NGB Reports: Canonical + Composable Reporting on .NET and PostgreSQL

NGB Reports: Canonical + Composable Reporting on .NET and PostgreSQL

Comments
3 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
Designing Conversational Infrastructure for AI Agents: Context Forking, Rate Limiting, and Identity Rotation

Designing Conversational Infrastructure for AI Agents: Context Forking, Rate Limiting, and Identity Rotation

Comments
19 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
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.