#Databases

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 · 4d 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 · 5d 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 · 6d 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 · 2w 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 · 2w 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 · 2w 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 · 2w 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 · 2w 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 · 4w ago7

Making hundreds of Postgres nodes look like one

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

Article · 4w 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 · 4w ago2

Why Your Next SQLite Table Should Be Strict

SQLite's flexible typing is a historical quirk, but strict tables bring modern type safety to your embedded database.

Article · 1mo ago6

Prisma Pivots to Infrastructure to Retain TypeScript Dominance

The database toolkit is expanding into managed infrastructure to solve its historical serverless and performance bottlenecks.

Article · 1mo ago0

Postgres in Rust Passes the Ultimate Compatibility Test

Rebuilding a legendary database in Rust is no longer a pipe dream after hitting 100 percent regression test compatibility.

Article · 1mo ago1

Why Spatial SQL Needs a Map in the LLM Loop

Text-only LLMs struggle with coordinate reference systems and expensive spatial joins. GeoSQL fixes this by putting maps in the loop.

Article · 1mo ago1