14 Nov 2024
I’ve noticed that engineers — myself included — often conflate Proof of Concept (PoC) with Minimum Viable Product (MVP), but these serve fundamentally different purposes in the development process. A PoC is fundamentally about code. It’s the process of writing enough code to demonstrate that a technical approach is feasible....
09 Jul 2024
I recently set up a Prefect environment using Docker Compose and wanted to document some of the slightly more advanced features I used. This setup deploys a PostgreSQL database, Prefect server (API and front end), and two workers - one for running flows as subprocesses and another for running them...
06 Jul 2024
Foreign keys are standard in transactional databases but rarely used in data warehouses. This isn’t just about database design - it’s a missed chance to improve data discovery and use. In data warehouses, foreign keys matter for metadata, not constraints. Unlike transactional databases where it’s typical for a single team...
05 Feb 2022
Hello World! Mighty empty in here…