#Databases

Why Killing Postgres VACUUM Means Rewriting the Indexes

zheap tried undo logs and stalled. OrioleDB's bet is that you have to version the key space too.

Article · 1w ago5

AWS Just Made DynamoDB a Vector Database

Native ANN queries land in every region, and the sync-pipeline-to-a-second-database pattern loses its reason to exist.

Article · 1w ago2

AWS Has 15 Databases. You Probably Need Two.

Scale-to-zero Aurora, cheaper DynamoDB, and Valkey quietly rewrote the standard decision tree.

Article · 1w ago0

The 16-Year Race Hiding in SQLite's WAL

Tailscale's corruption post-mortem and a 15-minute simulated repro expose the bug class coverage metrics can't see.

Article · 2w ago0

Your Mental Model of S3 Is Years Out of Date

Strong consistency, compare-and-swap, and real directories quietly turned AWS's blob store into a database substrate.

Article · 2w ago0

What Shopify's Redis-to-MySQL Swap Actually Proves

Inventory reservations survived a $5.1M-a-minute Black Friday on one row per unit and SKIP LOCKED.

Article · 3w ago0

The 300x Faster Postgres Isn't Postgres

pgrust's AI-built query engine resurrects two decades of vectorized-execution research that Postgres core has never managed to ship.

Article · 3w ago0

The Real Bottlenecks in Postgres Queues Aren't Where You Think

DBOS pushed a plain Postgres queue to 30,000 jobs a second — and vacuum wasn't the wall.

Article · 4w ago0

The Postgres Queue Ceiling Just Moved

DBOS reports 30,000 jobs per second — the real lesson is which optimization bought each order of magnitude.

Article · 4w ago0

Every MVCC Engine Fails. Postgres Just Fails Out Loud

The garbage bill for concurrent reads and writes is conserved — each database only chooses who pays, when, and how it breaks.

Article · 1mo ago0

SQLite in Production Is Solved. The Writer Problem Isn't

The pragma recipe converged years ago — what still hurts is the single-writer wall and the replication layer beneath it.

Article · 1mo ago0

Postgres LISTEN/NOTIFY Scales Once You Stop Trusting It

DBOS pushed 60K writes/sec through the primitive that took down Recall.ai. The difference is usage, not Postgres.

Article · 1mo ago0

Database branches live in the storage layer

Copy-on-write under the block device turns full clones into cheap point-in-time forks.

Article · 1mo ago7

Making hundreds of Postgres nodes look like one

Sharding solves capacity. The proxy is what keeps application code from drowning in it.

Article · 1mo ago7

SQLite Needs Rust-Style Editions

Footgun defaults for foreign keys and types could evolve without a flag day if the library borrowed from language design.

Article · 1mo ago2