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.
Query Fingerprints or Literal Text Diffs: A Debate for Agent SQL Regression

Query Fingerprints or Literal Text Diffs: A Debate for Agent SQL Regression

Comments
7 min read
Built an e-commerce app (BlueMart) with Flask & PostgreSQL. Roast my UI / feedback welcome!

Built an e-commerce app (BlueMart) with Flask & PostgreSQL. Roast my UI / feedback welcome!

1
Comments 1
1 min read
From MySQL to PostgreSQL: a much lighter server

From MySQL to PostgreSQL: a much lighter server

Comments
2 min read
Menghadapi "Retry Storms": Mengapa Retry Saja Tidak Cukup dalam Sistem Terdistribusi

Menghadapi "Retry Storms": Mengapa Retry Saja Tidak Cukup dalam Sistem Terdistribusi

Comments
3 min read
The slowest requests on our API were the ones that found nothing

The slowest requests on our API were the ones that found nothing

Comments
14 min read
PostgreSQL Connection Pooling in Go: What I Actually Tune in Production

PostgreSQL Connection Pooling in Go: What I Actually Tune in Production

1
Comments 2
5 min read
The Same Row Twice: Four Things Keyset Pagination Needs

The Same Row Twice: Four Things Keyset Pagination Needs

Comments
6 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
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
Read Replicas Do Not Fix a Bad Query Plan

Read Replicas Do Not Fix a Bad Query Plan

Comments
4 min read
PostgreSQL Locks and Deadlocks: How They Work and How to Fix Them

PostgreSQL Locks and Deadlocks: How They Work and How to Fix Them

2
Comments 2
13 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
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.