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.
Stripe Webhooks vs Database Sync: Which is Better?

Stripe Webhooks vs Database Sync: Which is Better?

2
Comments
5 min read
I indexed 30 million Hacker News posts into a single Postgres database. Here is what I learned about pgvector at scale.

I indexed 30 million Hacker News posts into a single Postgres database. Here is what I learned about pgvector at scale.

Comments
4 min read
Introducing Postgres Lite: A Pure JS Embedded Engine for Node.js, Bun, and the Browser

Introducing Postgres Lite: A Pure JS Embedded Engine for Node.js, Bun, and the Browser

6
Comments
3 min read
Diagnosing and Resolving Lock Contention in PostgreSQL

Diagnosing and Resolving Lock Contention in PostgreSQL

1
Comments
3 min read
PostgreSQL VACUUM explained — 5 things you must understand about database maintenance

PostgreSQL VACUUM explained — 5 things you must understand about database maintenance

Comments
5 min read
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

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.

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

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

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