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.
Five lifecycle campaigns, one two-hour window, and the subqueries that became EXISTS

Five lifecycle campaigns, one two-hour window, and the subqueries that became EXISTS

Comments
5 min read
The Dual-Write Problem: Building a Scalable Transactional Outbox for Google Pub/Sub

The Dual-Write Problem: Building a Scalable Transactional Outbox for Google Pub/Sub

Comments
3 min read
PostgreSQL Constraint Triggers for AI Feature Usage Quotas: Enforcing Hard Limits at the Database Layer

PostgreSQL Constraint Triggers for AI Feature Usage Quotas: Enforcing Hard Limits at the Database Layer

1
Comments 1
4 min read
The same website 5 metres apart is one pub, and the same name 430 metres apart needs a street number

The same website 5 metres apart is one pub, and the same name 430 metres apart needs a street number

Comments
6 min read
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 widening setting is on by default, and the only way to store that is to store nothing

Our widening setting is on by default, and the only way to store that is to store nothing

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