16 min read/10 views
Vector Databases Are Overhyped — When You Actually Need One
Most teams don't need Pinecone. pgvector benchmarks, decision framework, and when dedicated vector DBs actually make sense.
Tag
PostgreSQL
4 articles
15 min read/2 views
Change Data Capture Replaced Our Entire ETL Pipeline — Debezium, Postgres, and the Death of Batch
Our 15-minute batch ETL caused a billing incident. Debezium reading the Postgres WAL replaced the entire pipeline. CDC setup, consumer patterns, and production gotchas.
13 min read/1 views
Your Database Indexes Are Wrong — The $40K/Month Query You Don't Know About
A single missing PostgreSQL index cost $40K/month. Partial indexes, covering indexes, BRIN — the indexing tricks most devs never learn.
14 min read/1 views
I Replaced My Entire ETL Pipeline with SQL — Here's How
How I killed a 2,400-line Python ETL pipeline and replaced it with 300 lines of SQL using CTEs, materialized views, and pg_cron.