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.
UUIDv7 in PostgreSQL 18: uuidv7() vs UUIDv4 vs bigint Primary Keys, Benchmarked

UUIDv7 in PostgreSQL 18: uuidv7() vs UUIDv4 vs bigint Primary Keys, Benchmarked

Comments
11 min read
Supabase "permission denied for table" (42501) on new tables after 30 Oct 2026: the safe fix

Supabase "permission denied for table" (42501) on new tables after 30 Oct 2026: the safe fix

Comments
4 min read
Build a Postgres Audit Log Your Application Code Cannot Bypass

Build a Postgres Audit Log Your Application Code Cannot Bypass

Comments
9 min read
Query a partitioned data lake in Azure Blob with pg_duckdb

Query a partitioned data lake in Azure Blob with pg_duckdb

Comments
6 min read
One payment can run our webhook four times, and the token has to come out the same every time

One payment can run our webhook four times, and the token has to come out the same every time

1
Comments 3
7 min read
I added a Postgres constraint to stop double bookings. It deadlocked instead.

I added a Postgres constraint to stop double bookings. It deadlocked instead.

Comments
3 min read
AI code review just delayed PostgreSQL 19. Finding bugs is now cheap and fixing them isn’t.

AI code review just delayed PostgreSQL 19. Finding bugs is now cheap and fixing them isn’t.

1
Comments 1
2 min read
SQL vs NoSQL: Kenapa PostgreSQL Masih Jadi 'Swiss Army Knife' di 2026

SQL vs NoSQL: Kenapa PostgreSQL Masih Jadi 'Swiss Army Knife' di 2026

Comments
2 min read
When Better Route Optimization Made Our Travel Planner Slower Copy

When Better Route Optimization Made Our Travel Planner Slower Copy

Comments
12 min read
How to do a zero-downtime schema change with Neon

How to do a zero-downtime schema change with Neon

5
Comments
10 min read
Inngest's Database Connection Pool Collapsed Twice in One Day, and Restarting Made It Worse

Inngest's Database Connection Pool Collapsed Twice in One Day, and Restarting Made It Worse

1
Comments 1
5 min read
Your Payment Code Can Still Charge Twice (Even With Idempotency Keys)

Your Payment Code Can Still Charge Twice (Even With Idempotency Keys)

Comments
5 min read
Berhenti Pakai Banyak Database: Mengapa PostgreSQL Jadi Jawaban 'All-in-One' di 2026

Berhenti Pakai Banyak Database: Mengapa PostgreSQL Jadi Jawaban 'All-in-One' di 2026

Comments 1
3 min read
How to Document Your Database Schema for a Team

How to Document Your Database Schema for a Team

Comments 1
3 min read
Amnesia and déjà vu: how our AI agents failed after every restart (and how we fixed it)

Real code linked for stopping duplicate emails

Amnesia and déjà vu: how our AI agents failed after every restart (and how we fixed it)

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