Blog.
Blog.
Data, SQL, and infrastructure — from the field
Showing: All
01
Why I Left ORM for Raw SQL
After years of fighting with ORMs, I switched to raw SQL and never looked back. Here is what I learned about control, performance, and knowing your database.
sqlpostgresqlopinion
02
Designing a Star Schema from Scratch
Lorem ipsum dolor sit amet, consectetur adipiscing elit. A practical walkthrough of dimensional modeling for analytics warehouses.
sqlwarehousing
03
Building a Transit Data Pipeline
How I designed an ELT pipeline to process real-time GTFS feeds for a Quebec transit operator — from ingestion to dashboard.
etlpostgresqlpythoncase-study
04
The Anime Data Viz Challenge
I visualized 10 years of MyAnimeList data using SQL and Power BI. The results surprised me — and taught me something about storytelling with data.
datavizpower-bifun
05
ETL Patterns That Actually Scale
Lorem ipsum dolor sit amet. Five battle-tested patterns for building data pipelines that don't break at 3am.
pipelineetl