DEV Community

Database

Posts on building, using, and learning about databases.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
What Is MySQL? How the Popular Database Works, Explained Simply

What Is MySQL? How the Popular Database Works, Explained Simply

Comments
6 min read
Backend Interview Question: Two Buyers Want the Last Seat. Who Gets It?

Backend Interview Question: Two Buyers Want the Last Seat. Who Gets It?

Comments
6 min read
Durable BlobStore Deletion Across Reopen and Index Loss

Durable BlobStore Deletion Across Reopen and Index Loss

Comments
5 min read
Three systems, three numbers: write a metric contract before you put an AI agent on your CRM and ERP

Three systems, three numbers: write a metric contract before you put an AI agent on your CRM and ERP

Comments
3 min read
PostgreSQL 14 Reaches End of Life on November 12: Three Ways to Upgrade

PostgreSQL 14 Reaches End of Life on November 12: Three Ways to Upgrade

Comments
7 min read
Phoenix vs ClickHouse: Why the Argument Keeps Coming Back

Phoenix vs ClickHouse: Why the Argument Keeps Coming Back

Comments
32 min read
Valkey vs Redis in 2026: What Is Different and What Breaks When You Switch

Valkey vs Redis in 2026: What Is Different and What Breaks When You Switch

Comments
11 min read
I Broke My Own Firestore Rules in Production Once. Now the Emulator Catches It First.

I Broke My Own Firestore Rules in Production Once. Now the Emulator Catches It First.

Comments
7 min read
The Database Scaling Ladder: Fix a Slow Database in the Right Order

The Database Scaling Ladder: Fix a Slow Database in the Right Order

Comments
4 min read
Cloudflare Offers 1,500 Connections. Your Database Needs a Budget.

Cloudflare Offers 1,500 Connections. Your Database Needs a Budget.

1
Comments
4 min read
SQL Query Cheat Sheet: Essential Queries and Patterns

SQL Query Cheat Sheet: Essential Queries and Patterns

Comments 1
11 min read
Your UNIQUE constraint in PostgreSQL lets duplicates through. Here is how to find every one

Your UNIQUE constraint in PostgreSQL lets duplicates through. Here is how to find every one

Comments
8 min read
I built GenerateRealData, a test data generator where keys, totals and rules hold across tables

I built GenerateRealData, a test data generator where keys, totals and rules hold across tables

Comments
4 min read
Decided Is Not Enforced: two advisories, one pattern

Decided Is Not Enforced: two advisories, one pattern

Comments 1
2 min read
pgcoalesce: a Postgres proxy that merges concurrent point reads

pgcoalesce: a Postgres proxy that merges concurrent point reads

1
Comments
14 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.