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.
A Residue Report Is a Priced Work List: What Honest Oracle-to-PostgreSQL Conversion Looks Like

A Residue Report Is a Priced Work List: What Honest Oracle-to-PostgreSQL Conversion Looks Like

Comments
4 min read
WINDOW FUNCTIONS,JOINS,SUBQUERIES AND CTEs

WINDOW FUNCTIONS,JOINS,SUBQUERIES AND CTEs

Comments
5 min read
Shipping a reminder email must not remind everyone who signed up before it existed, so ours has a seven day cutoff

Shipping a reminder email must not remind everyone who signed up before it existed, so ours has a seven day cutoff

Comments
8 min read
Our settlement job and our checkout webhook can reach for the same reward row, and the one that proceeds is whoever gets it back from an UPDATE

Our settlement job and our checkout webhook can reach for the same reward row, and the one that proceeds is whoever gets it back from an UPDATE

Comments
5 min read
How to Implement the Transactional Outbox Pattern in Python

How to Implement the Transactional Outbox Pattern in Python

Comments
28 min read
Webhooks Arrive Twice, Late and Out of Order: Designing Idempotent Handlers

Webhooks Arrive Twice, Late and Out of Order: Designing Idempotent Handlers

1
Comments 5
6 min read
Idempotent Email Verification for REST APIs

Idempotent Email Verification for REST APIs

Comments
4 min read
Your DataLoader fixed the N+1. It may also be giving posts the wrong author.

Your DataLoader fixed the N+1. It may also be giving posts the wrong author.

2
Comments 5
4 min read
My PostgreSQL Database Went from 139 GB to 29 GB. Here's Why.

My PostgreSQL Database Went from 139 GB to 29 GB. Here's Why.

Comments
5 min read
A Guide to 2-Stage Scheduled Data Cleanup with Cron Queue Batches

A Guide to 2-Stage Scheduled Data Cleanup with Cron Queue Batches

Comments
7 min read
We Gave an AI Agent a read_only Neon Role. Here Is What It Blocked

We Gave an AI Agent a read_only Neon Role. Here Is What It Blocked

10
Comments 4
19 min read
Round-Tripping Mastodon and Saleor Through a Database Diagram: What Broke and What We Fixed

Round-Tripping Mastodon and Saleor Through a Database Diagram: What Broke and What We Fixed

Comments
18 min read
From Rows to Vectors: pgvector inside Postgres

From Rows to Vectors: pgvector inside Postgres

1
Comments
13 min read
taming burst traffic: pgbouncer + redis cache for low‑latency queries

taming burst traffic: pgbouncer + redis cache for low‑latency queries

Comments
2 min read
The Lock You Did Not Know You Were Taking

The Lock You Did Not Know You Were Taking

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