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.
Database Indexing – Part 3: Understanding Composite Indexes in PostgreSQL

Database Indexing – Part 3: Understanding Composite Indexes in PostgreSQL

Comments
11 min read
A nightly pg_dump that fails with the reason, not with "Network is unreachable"

A nightly pg_dump that fails with the reason, not with "Network is unreachable"

Comments
4 min read
Experiments in Software Factories #1: Production app in 40 minutes

Experiments in Software Factories #1: Production app in 40 minutes

5
Comments
9 min read
Why Did Supabase Pause My Project? How to Restore It and Stop It Happening Again

Why Did Supabase Pause My Project? How to Restore It and Stop It Happening Again

1
Comments 2
4 min read
A test you can't run is a test you don't have

A test you can't run is a test you don't have

Comments
4 min read
FR24/Django4/postgres/openstreetmap live flight tracker

FR24/Django4/postgres/openstreetmap live flight tracker

Comments
1 min read
Read Replicas Do Not Fix a Bad Query Plan

Read Replicas Do Not Fix a Bad Query Plan

Comments
4 min read
Your Supabase free-tier database has no backups. Here is how I fixed that in 15 minutes.

Your Supabase free-tier database has no backups. Here is how I fixed that in 15 minutes.

Comments
5 min read
What 40 agent-written migrations got wrong

What 40 agent-written migrations got wrong

5
Comments
4 min read
Expand, migrate, contract: dropping a column without breaking the deploy that is still running

Expand, migrate, contract: dropping a column without breaking the deploy that is still running

5
Comments
4 min read
Why I Put PostgreSQL in WebAssembly to Fix SQL Interview Prep

Why I Put PostgreSQL in WebAssembly to Fix SQL Interview Prep

Comments
5 min read
The Great Simplification: Menavigasi Rendering Model dan Konsolidasi Infrastruktur di 2026

The Great Simplification: Menavigasi Rendering Model dan Konsolidasi Infrastruktur di 2026

Comments
2 min read
Partner commissions on serverless Node and Postgres, with no server to run

Partner commissions on serverless Node and Postgres, with no server to run

Comments
5 min read
Moving 530k Jobs from Supabase to Postgres on a Free Oracle VM (14s -> 47ms)

Moving 530k Jobs from Supabase to Postgres on a Free Oracle VM (14s -> 47ms)

1
Comments 1
3 min read
Twelve verbs in one 221-line script, and not one of them loads a module until you pick it

Twelve verbs in one 221-line script, and not one of them loads a module until you pick it

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