Technical Writing

Exploring the intersection of code, data, and reliability.
Thoughts on Backend Engineering, Data Pipelines, and System Architecture.

Oct 12, 20235 min read

Optimizing PostgreSQL Queries for Large Datasets

A deep dive into indexing strategies, query planning visualization, and common pitfalls when scaling relational databases for high-performance applications. We explore B-tree vs BRIN indexes and partitioning strategies.

#SQL#Database#Performance
Read on Medium
Sep 28, 20238 min read

Building Scalable Data Pipelines with Apache Airflow

Best practices for orchestration, error handling, and idempotency in distributed data systems. How we managed to reduce pipeline failures by 40% using custom operators and sensors.

#DataEngineering#Python#Airflow
Read on Medium
Aug 15, 202312 min read

The Evolution of Microservices Architecture

From monolith to microservices and back again? A critical look at when distributed systems make sense and when they introduce unnecessary complexity.

#SystemDesign#Architecture
Read on Medium
Jul 02, 20234 min read

Finding Beauty in Algorithmic Efficiency

Reflecting on the aesthetics of clean code and how photography influences my approach to writing software. The parallel between composing a shot and composing a function.

#Philosophy#Personal
Read on Medium