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.
The Dual-Write Problem in Distributed Systems: Implementing the Transactional Outbox Pattern in Node.js & PostgreSQL

The Dual-Write Problem in Distributed Systems: Implementing the Transactional Outbox Pattern in Node.js & PostgreSQL

Comments
12 min read
Load CSV and JSON from Azure Blob into Postgres with pg_duckdb

Load CSV and JSON from Azure Blob into Postgres with pg_duckdb

Comments
6 min read
Is my Supabase app leaking data between users?

Is my Supabase app leaking data between users?

Comments
2 min read
Database Indexing – Part 4: Covering vs. Composite Indexes in PostgreSQL – Which One Should You Use?

Database Indexing – Part 4: Covering vs. Composite Indexes in PostgreSQL – Which One Should You Use?

Comments
11 min read
How to Track Schema Changes in PostgreSQL: DDL Logging, an Event Trigger or a Schema Snapshot

How to Track Schema Changes in PostgreSQL: DDL Logging, an Event Trigger or a Schema Snapshot

Comments
9 min read
Database Race Conditions Your Tests Miss

Database Race Conditions Your Tests Miss

Comments
12 min read
How to Secure a PostgreSQL Server: Production Security Best Practices

How to Secure a PostgreSQL Server: Production Security Best Practices

Comments
9 min read
MySQL vs PostgreSQL in 2026: An Honest Answer After Running Both

MySQL vs PostgreSQL in 2026: An Honest Answer After Running Both

Comments
3 min read
PostgreSQL Is Slow: Finding and Fixing the Queries That Kill Your Server

PostgreSQL Is Slow: Finding and Fixing the Queries That Kill Your Server

Comments
4 min read
PostgreSQL Backups That Actually Restore: pg_dump, pg_basebackup, and the Restore Test Nobody Does

PostgreSQL Backups That Actually Restore: pg_dump, pg_basebackup, and the Restore Test Nobody Does

Comments
4 min read
Free tool: find Supabase tables that will 42501 after Oct 30

Free tool: find Supabase tables that will 42501 after Oct 30

Comments
2 min read
I fired 20 simultaneous bookings at a typical booking app. All 20 got the slot.

I fired 20 simultaneous bookings at a typical booking app. All 20 got the slot.

Comments
7 min read
Why the Django admin says 403 behind a proxy, and the one line that fixes it

Why the Django admin says 403 behind a proxy, and the one line that fixes it

Comments
2 min read
Deleting a campaign keeps its conversations, with no campaign, no address and no emails left in them

Deleting a campaign keeps its conversations, with no campaign, no address and no emails left in them

Comments
7 min read
Two Postgres clients, one database, and the only option they agree on is the one the pooler forces

Two Postgres clients, one database, and the only option they agree on is the one the pooler forces

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