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.
Our daily cleanup job refreshes before it deletes, and that order is the only reason the 30 day rule holds

Our daily cleanup job refreshes before it deletes, and that order is the only reason the 30 day rule holds

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
Following foreign keys in DBeaver, pgAdmin or IntelliJ: one row at a time

Following foreign keys in DBeaver, pgAdmin or IntelliJ: one row at a time

Comments
2 min read
Your Index Isn't Being Used: A Senior Engineer's Guide to Database Indexing

Your Index Isn't Being Used: A Senior Engineer's Guide to Database Indexing

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

The Silent CDC Bug: Data Loss With No Errors

1
Comments 1
7 min read
Why I stopped reaching for Redis first

Why I stopped reaching for Redis first

7
Comments 2
1 min read
gcloud ADC Expires After ~44h: Reauthentication failed Fix

gcloud ADC Expires After ~44h: Reauthentication failed Fix

Comments
4 min read
Serializable vs SELECT FOR UPDATE vs advisory locks — pick the boundary, not the loudest tool

Serializable vs SELECT FOR UPDATE vs advisory locks — pick the boundary, not the loudest tool

Comments
3 min read
Enforce SSL on Supabase, Then Measure the Restart: A Status Page for Encryption and Downtime

Enforce SSL on Supabase, Then Measure the Restart: A Status Page for Encryption and Downtime

Comments
9 min read
Twelve SELECTs for the list and six filtered counts for the page, and the only shared code is three SQL fragments

Twelve SELECTs for the list and six filtered counts for the page, and the only shared code is three SQL fragments

Comments
7 min read
Two Postgres error codes are the only ones we retry, and the retry sits underneath a React cache()

Two Postgres error codes are the only ones we retry, and the retry sits underneath a React cache()

Comments
6 min read
Analytics for 10 social networks: polling post stats by age, and why NULL isn't zero

Analytics for 10 social networks: polling post stats by age, and why NULL isn't zero

Comments 1
3 min read
pg_duckdb quietly ignored force_execution on my numeric column

pg_duckdb quietly ignored force_execution on my numeric column

Comments
3 min read
The admin side of scheduling: booking states, a day-grouped calendar and honest no-show rates

The admin side of scheduling: booking states, a day-grouped calendar and honest no-show rates

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

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

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