#Postgres

Deterministic Integration Tests in Go with Testcontainers

Boot real Postgres, Redis, and Kafka per test run and catch the bugs your mocks wave through.

Tutorial · 1w ago2

Your Supabase Backup Isn't Backing Up Your Files

Daily backups and PITR cover Postgres only — Storage objects, roles, config, and secrets are your problem.

Article · 1w ago7

Round-Trip Tests Catch Bad Down Migrations, Not Data Loss

AI agents are reviving the down migration just as the industry finished giving up on it.

Article · 1w ago5

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

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

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

Give Your AI Agent Persistent Long-Term Memory with Postgres and pgvector

Store and retrieve conversation history semantically across sessions using pgvector's HNSW index and OpenAI embeddings — no external vector database required.

Tutorial · 1mo ago0

Enforce Multi-Tenant Data Isolation with Postgres Row-Level Security

Lock down tenant data at the database layer using RLS policies, so no application bug can accidentally leak rows across tenants.

Tutorial · 1mo ago0

Deploy a FastAPI App to Fly.io with Managed Postgres

Scaffold a notes API with FastAPI and SQLAlchemy, containerize it, attach a Fly Postgres cluster, and ship the whole thing to Fly.io Machines in under 15 minutes.

Tutorial · 2mos ago0