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.
Zero-Downtime Schema Changes in PostgreSQL: Adding Columns and Indexes to a 200M-Row Table

Zero-Downtime Schema Changes in PostgreSQL: Adding Columns and Indexes to a 200M-Row Table

Comments 2
7 min read
OPFS vs IndexedDB

OPFS vs IndexedDB

Comments
4 min read
Six runtime dependencies and no build step, which is why our ledger is a text file

Six runtime dependencies and no build step, which is why our ledger is a text file

Comments
6 min read
Best Data Warehouse Schema Documentation Tools (2026): SQLDBM, dbt, DataHub, Atlan & SchemaSpy Compared

Best Data Warehouse Schema Documentation Tools (2026): SQLDBM, dbt, DataHub, Atlan & SchemaSpy Compared

Comments
9 min read
Session Budgets or Driver Caps: A Debate for Agent SQL Exploration

Session Budgets or Driver Caps: A Debate for Agent SQL Exploration

Comments
7 min read
MySQL Watchdog: The Database Kitchen Is Closed, and Nobody Told the Waiters

MySQL Watchdog: The Database Kitchen Is Closed, and Nobody Told the Waiters

Comments
4 min read
Redis Watchdog: Fast Cache, Slow Excuses

Redis Watchdog: Fast Cache, Slow Excuses

Comments
5 min read
The refund arrived after the payout, so the fix was two nullable columns and no code

The refund arrived after the payout, so the fix was two nullable columns and no code

Comments
4 min read
48-Hour Field Notes: The Dry Run That Read the Wrong Database

48-Hour Field Notes: The Dry Run That Read the Wrong Database

Comments
6 min read
DMS Database Design

DMS Database Design

Comments
2 min read
Start and End Dates of the Longest Rising Period

Start and End Dates of the Longest Rising Period

5
Comments
6 min read
SQL: Find the Top 2 Orders for Every Customer Using Window Functions

SQL: Find the Top 2 Orders for Every Customer Using Window Functions

Comments
3 min read
I measured whether .NET Guid sorting is broken. It isn't.

I measured whether .NET Guid sorting is broken. It isn't.

Comments
2 min read
Migration & Modernization

Migration & Modernization

Comments
20 min read
16,000 Supabase Databases Were Open to Anyone. Nobody Hacked Anything.

16,000 Supabase Databases Were Open to Anyone. Nobody Hacked Anything.

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