dbtAirflowSnowflake
Building a Modern Data Pipeline with dbt, Airflow, and Snowflake
A deep dive into creating an automated ELT pipeline using dbt Core, Cosmos, and Airflow to process TPC-H data.
January 202610 min readRead more
Blog
Writing about databases, Python, and lessons learned from working with production data.
PostgreSQLSQLDatabase
PostgreSQL Learning Guide
A comprehensive guide to configuring a beautiful psql environment, understanding PostgreSQL basics, and mastering advanced SQL queries.
January 202615 min readRead more
LinuxPop!_OSTerminal
Linux for Everyday Use - Complete Beginner's Guide
Switching to Linux? Here is a complete beginner's guide to file systems, terminal commands, installing software, and more on Pop!_OS.
January 202612 min readRead more
TerminalProductivityPython
Pop!_OS Terminal Improvements Guide
Make your terminal beautiful and powerful with lsd, starship, zoxide. Plus a guide to UV, the fast Python package manager.
January 202614 min readRead more
PostgreSQLSQLProduction
Working with PostgreSQL in Production: Lessons from Real-World Experience
Insights from debugging data issues, writing optimized SQL queries, and handling schema mismatches in a production environment.
December 20258 min readRead more
PythonAutomationData Processing
Python for Automation and Data Processing
How I use Python for data validation, transformation, and small automation tasks in cloud-based workflows.
December 20256 min readRead more
CloudAPIsData Engineering
Understanding Data Flows Between APIs, Databases, and Cloud Services
A practical look at how data moves through modern applications and what I learned supporting backend services.
December 20257 min readRead more