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.
How a read replica almost took down its primary database and other database tales

How a read replica almost took down its primary database and other database tales

Comments
8 min read
The Silent CDC Bug: Data Loss With No Errors

The Silent CDC Bug: Data Loss With No Errors

Comments
7 min read
Postgres vs MySQL: Picking the Right Database for a New Service

Postgres vs MySQL: Picking the Right Database for a New Service

1
Comments 1
5 min read
Test the migration before it tests production: rehearsing AI-generated database changes

Test the migration before it tests production: rehearsing AI-generated database changes

Comments
4 min read
What SKIP LOCKED Solves, and What It Leaves to You

What SKIP LOCKED Solves, and What It Leaves to You

8
Comments
8 min read
GRANT ALL to anon is the wrong fix for Supabase 42501 after Oct 30

GRANT ALL to anon is the wrong fix for Supabase 42501 after Oct 30

Comments
4 min read
Debezium Postgres to Kafka: Every Setting Explained

Debezium Postgres to Kafka: Every Setting Explained

Comments
8 min read
I Put a Rust Proxy Between My App and PostgreSQL. Here's What Happens to Every Connection.

I Put a Rust Proxy Between My App and PostgreSQL. Here's What Happens to Every Connection.

Comments
2 min read
Go, Postgres, and the queue I didn't need

Go, Postgres, and the queue I didn't need

Comments
1 min read
ChatGPT serves 800 million users from one Postgres primary. Here's how 🐘

ChatGPT serves 800 million users from one Postgres primary. Here's how 🐘

10
Comments
3 min read
infinite recursion detected in policy for relation (42P17)

infinite recursion detected in policy for relation (42P17)

Comments
4 min read
Shadow Replay or Read-Only Canary: Two Ways to Ship Agent-Written SQL

Shadow Replay or Read-Only Canary: Two Ways to Ship Agent-Written SQL

Comments
5 min read
You Might Not Need Redis for Background Jobs

You Might Not Need Redis for Background Jobs

2
Comments
2 min read
my dashboard said a post from seconds ago would happen in 7 hours

my dashboard said a post from seconds ago would happen in 7 hours

Comments
1 min read
Why I stopped reaching for Redis first

Why I stopped reaching for Redis first

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