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.
The field was a string, then an object, and the missing half was backfilled by a model that may answer "none"

The field was a string, then an object, and the missing half was backfilled by a model that may answer "none"

Comments
5 min read
Our production Postgres pool is three connections and our dev pool is five, and prepared statements are off

Our production Postgres pool is three connections and our dev pool is five, and prepared statements are off

Comments 1
4 min read
Supabase RLS policies that pass review but still leak data

Supabase RLS policies that pass review but still leak data

Comments
8 min read
Stop mocking your database for integration tests

Stop mocking your database for integration tests

1
Comments 1
4 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?

6
Comments
4 min read
22 lines of ULID, and the three different jobs we were asking one id to do

22 lines of ULID, and the three different jobs we were asking one id to do

Comments
5 min read
A retry that refunds is a bug, so the refund lives in onFailure and nowhere else

A retry that refunds is a bug, so the refund lives in onFailure and nowhere else

Comments
4 min read
704 lines of SQL, 66,007 lines of JSON, and the one migration Drizzle never generated

704 lines of SQL, 66,007 lines of JSON, and the one migration Drizzle never generated

Comments
4 min read
Two currencies of concession, and only one of them can be haggled over

Two currencies of concession, and only one of them can be haggled over

Comments
6 min read
Our page polls a 16-character fingerprint, and only a change is allowed to re-render it

Our page polls a 16-character fingerprint, and only a change is allowed to re-render it

Comments
5 min read
A Tenant Leak Does Not Throw an Error. It Just Returns the Wrong Rows.

A Tenant Leak Does Not Throw an Error. It Just Returns the Wrong Rows.

1
Comments 2
8 min read
The Hidden Cost of Unoptimized REST API Payloads in Node.js

The Hidden Cost of Unoptimized REST API Payloads in Node.js

1
Comments 1
1 min read
How to Schedule Marketplace Data Cleanup with App Cron (and Recover Cleanly)

How to Schedule Marketplace Data Cleanup with App Cron (and Recover Cleanly)

Comments
8 min read
The Hour That Doesn’t Exist: Booking Slots Across Daylight Saving Time

The Hour That Doesn’t Exist: Booking Slots Across Daylight Saving Time

2
Comments
9 min read
Human-in-the-Loop AI Drafts in n8n Without the Mess: One Pending Draft per Customer, Stale Expiry and Out-of-Order Webhooks (2026)

Human-in-the-Loop AI Drafts in n8n Without the Mess: One Pending Draft per Customer, Stale Expiry and Out-of-Order Webhooks (2026)

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