Engineering
Technical notes on building data products. Architecture decisions, production patterns, and lessons from shipping data systems.
Organising FastAPI projects for data products
Domain-driven project structure that keeps data APIs maintainable as they grow beyond a few endpoints.
Testing data pipelines at three layers
Source validation, transform testing, and output assertions — a practical strategy for reliable ETL.
When to use DuckDB for analytical workloads
Production patterns for in-process OLAP: when DuckDB replaces PostgreSQL and when it should not.