Forem

# 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 Execution Guard Pattern for AI Agents

The Execution Guard Pattern for AI Agents

2
Comments
3 min read
Entry #01: My perfect API was actually drowning
Cover image for Entry #01: My perfect API was actually drowning

Entry #01: My perfect API was actually drowning

8
Comments
3 min read
How to make Django asynchronous?

How to make Django asynchronous?

1
Comments
2 min read
The Likes Table Problem: Why We Went Polymorphic.

The Likes Table Problem: Why We Went Polymorphic.

Comments
3 min read
I built a phenotype generator for crested gecko genetics. Here's how I modeled a hobby that can't agree on its own rules.
Cover image for I built a phenotype generator for crested gecko genetics. Here's how I modeled a hobby that can't agree on its own rules.

I built a phenotype generator for crested gecko genetics. Here's how I modeled a hobby that can't agree on its own rules.

Comments
8 min read
Scaling PostgreSQL without Microservices: Lessons from Notion’s 480 Shards
Cover image for Scaling PostgreSQL without Microservices: Lessons from Notion’s 480 Shards

Scaling PostgreSQL without Microservices: Lessons from Notion’s 480 Shards

Comments
3 min read
Building a Payment Gateway That Doesn't Lie: How I Solved Distributed State Failures in Go

Building a Payment Gateway That Doesn't Lie: How I Solved Distributed State Failures in Go

Comments
6 min read
Deploying Rails 8's Solid Trio to Production with a Single Database
Cover image for Deploying Rails 8's Solid Trio to Production with a Single Database

Deploying Rails 8's Solid Trio to Production with a Single Database

2
Comments
6 min read
PostgreSQL vs. MongoDB for JSON: The Internal Trade-offs They Don't Tell You in the Docs

PostgreSQL vs. MongoDB for JSON: The Internal Trade-offs They Don't Tell You in the Docs

5
Comments 2
7 min read
Zero-Downtime Embedding Migration: Switching from text-embedding-004 to text-embedding-3-large in Production

Zero-Downtime Embedding Migration: Switching from text-embedding-004 to text-embedding-3-large in Production

Comments
3 min read
How We Tracked 10,000,000 Spins Per Day with Go and PostgreSQL Partitioning

How We Tracked 10,000,000 Spins Per Day with Go and PostgreSQL Partitioning

Comments
10 min read
Debugging postgres: List all connections
Cover image for Debugging postgres: List all connections

Debugging postgres: List all connections

Comments
1 min read
Active-Passive vs Active-Active: How to Know Which Pattern Fits Your Database

Active-Passive vs Active-Active: How to Know Which Pattern Fits Your Database

Comments
8 min read
Supabase in 2026: The Complete Developer Guide to the Open-Source Firebase Alternative

Supabase in 2026: The Complete Developer Guide to the Open-Source Firebase Alternative

1
Comments
4 min read
Your PostgreSQL Backups Are Probably Broken (Here's How to Know for Sure)

Your PostgreSQL Backups Are Probably Broken (Here's How to Know for Sure)

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