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.
Does AbortSignal Cancel a Node.js Database Query? 4 Drivers Tested

Pool starvation risks revealed across drivers

Does AbortSignal Cancel a Node.js Database Query? 4 Drivers Tested

21
Picked as gem Comments 5
19 min read
Where do you put a referral program when everything it touches lives in the monolith?

Where do you put a referral program when everything it touches lives in the monolith?

1
Comments
4 min read
162 Integration Tests Found 3 Real Bugs in My .NET Wallet Kit

162 Integration Tests Found 3 Real Bugs in My .NET Wallet Kit

Comments
5 min read
Two Pods, One Job Table: A Safe Postgres Queue with SKIP LOCKED in Spring Boot

Two Pods, One Job Table: A Safe Postgres Queue with SKIP LOCKED in Spring Boot

Comments
7 min read
Per-object permissions in Django that roll back with atomic()

Per-object permissions in Django that roll back with atomic()

Comments
10 min read
Orders stall only during sales: work done while holding a SELECT FOR UPDATE lock

Orders stall only during sales: work done while holding a SELECT FOR UPDATE lock

Comments
7 min read
Adding Rate Limits to a Netlify Chat Endpoint with Postgres for Palm Beach Contractors

Adding Rate Limits to a Netlify Chat Endpoint with Postgres for Palm Beach Contractors

1
Comments
3 min read
Measure SDR ramp from your CRM with SQL (days to first reply, meeting, target)

Measure SDR ramp from your CRM with SQL (days to first reply, meeting, target)

Comments
2 min read
Your primary key is a storage decision

Your primary key is a storage decision

Comments
3 min read
Can a user retrieve information outside their permissions, including through the lexical search path, caches, or indirect references?

Can a user retrieve information outside their permissions, including through the lexical search path, caches, or indirect references?

1
Comments
13 min read
Sparrow: an open-source Svix/Hookdeck alternative in Go (Postgres + River, no Redis)

Sparrow: an open-source Svix/Hookdeck alternative in Go (Postgres + River, no Redis)

1
Comments
1 min read
Your Shorts song join is picking the wrong creator

Your Shorts song join is picking the wrong creator

Comments
8 min read
How I stop double bookings in a booking app: let Postgres refuse them

How I stop double bookings in a booking app: let Postgres refuse them

Comments
2 min read
PostgreSQL 14 End of Life on 12 November 2026: How to Upgrade Postgres in Docker

PostgreSQL 14 End of Life on 12 November 2026: How to Upgrade Postgres in Docker

Comments
9 min read
One using (true) policy makes your whole table public

One using (true) policy makes your whole table public

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