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.
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
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

Debugging postgres: List all connections

Comments
1 min read
Neon Has a Free Tier — Serverless Postgres With Branching, 512 MB Storage, and No Credit Card

Neon Has a Free Tier — Serverless Postgres With Branching, 512 MB Storage, and No Credit Card

Comments
3 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

2
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
Databasus released full backups portability: backups recoverable without Databasus itself

Databasus released full backups portability: backups recoverable without Databasus itself

Comments
4 min read
Principais Arquivos do Servidor PostgreSQL e Suas Funções

Principais Arquivos do Servidor PostgreSQL e Suas Funções

1
Comments
2 min read
Real world considerations: MS-SQL vs PostgreSQL vs MySQL

Real world considerations: MS-SQL vs PostgreSQL vs MySQL

2
Comments
12 min read
How Do PostgreSQL Indices Work, Anyways?

How Do PostgreSQL Indices Work, Anyways?

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