Tag

PostgreSQL

4 articles

15 min read/0 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.

Data Engineering PostgreSQL Backend Architecture

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.

PostgreSQL Performance Backend SQL

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.

SQL Data Engineering PostgreSQL Python

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.

AI Database PostgreSQL Data Engineering