Notes from the field

Learn it. Build it. Share it.

Queries, pipelines, Python, and the decisions behind them. Practical engineering notes, written while working through the details.

notes

Essays, guides & engineering notes

Search writing

3 notes from the field

Practical Query Optimization in Postgres: Indexes, Partitioning, and Plan Introspection

Learn how to speed up Postgres queries with B-tree indexes, table partitioning, and EXPLAIN ANALYZE. Step-by-step with real Python code.

Learn how to build reliable ML feature pipelines in Python: ingestion, transformation, storage, and serving — with Docker and pytest.

Profile Python pipelines, replace slow loops with NumPy vectorization, and safely parallelize I/O with ThreadPoolExecutor. Step-by-step with Docker.

I share shorter notes and useful links on my Telegram channel.