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.
How a One-Line Column Rename Takes Down Production (and the Expand/Contract Fix)

How a One-Line Column Rename Takes Down Production (and the Expand/Contract Fix)

1
Comments 1
2 min read
A webhook retry can pay a customer twice, and two checks that stop it

A webhook retry can pay a customer twice, and two checks that stop it

1
Comments 3
3 min read
Fetching dashboard summaries instead of full snapshots

Fetching dashboard summaries instead of full snapshots

Comments
4 min read
How to Back Up Self-Hosted Spliit: PostgreSQL Dumps, S3 Receipts and a Docker Restore That Loses Nothing

How to Back Up Self-Hosted Spliit: PostgreSQL Dumps, S3 Receipts and a Docker Restore That Loses Nothing

1
Comments
17 min read
Airtable as a Backup Datastore for Orders Nobody Can Afford to Lose

Airtable as a Backup Datastore for Orders Nobody Can Afford to Lose

1
Comments
7 min read
Postgres NOTIFY Is a Doorbell, Not a Queue: Build a Worker That Survives kill -9

Postgres NOTIFY Is a Doorbell, Not a Queue: Build a Worker That Survives kill -9

3
Comments 5
9 min read
What I learned parsing every SEC Form 4 filing for a day

What I learned parsing every SEC Form 4 filing for a day

Comments
4 min read
Integração com o iFood: o problema na homologação do developer

Integração com o iFood: o problema na homologação do developer

Comments
8 min read
Prevent Double Booking: System Design That Holds (2026)

Prevent Double Booking: System Design That Holds (2026)

2
Comments 5
12 min read
What I learned counting 600,000 live job adverts every night

What I learned counting 600,000 live job adverts every night

1
Comments 1
3 min read
Building an Evidence-Based Medical Q&A Site with Go — Architecture, Structured Data, and an SEO Playbook

Building an Evidence-Based Medical Q&A Site with Go — Architecture, Structured Data, and an SEO Playbook

1
Comments
4 min read
Embedded Postgres in 2026: PGlite, embedded-postgres, and tinbase Compared

Embedded Postgres in 2026: PGlite, embedded-postgres, and tinbase Compared

1
Comments
5 min read
I Added an Index and Postgres Still Does a Seq Scan (Here's Why)

I Added an Index and Postgres Still Does a Seq Scan (Here's Why)

4
Comments 4
7 min read
A Free-Trial Rule Written Wrong in the Software: What to Check Before It Costs You Customers

A Free-Trial Rule Written Wrong in the Software: What to Check Before It Costs You Customers

1
Comments 2
6 min read
A job queue in Postgres, two months later

A job queue in Postgres, two months later

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