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
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
RLS sounds great until it isn't

RLS sounds great until it isn't

1
Comments 1
9 min read
Row-Level Multitenancy in Rails: Building a Bulletproof Tenant Isolation Layer from Scratch

Row-Level Multitenancy in Rails: Building a Bulletproof Tenant Isolation Layer from Scratch

1
Comments
10 min read
Agents that monitor themselves: a self-auditing RAG on Tiger's Agentic Postgres

Agentic Postgres Challenge Submission

Agents that monitor themselves: a self-auditing RAG on Tiger's Agentic Postgres

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