Blogs / Personal blogs

I want to understand the world, in the broadest possible sense. I enjoy thinking about math, physical sciences, software engineering, economics, irreducibly complex systems, but also about classical music, aesthetics, and philosophy. I write.

Popular posts
8
Total points
1,735
HN comments
1,185
Rank
#1,013 personal

Visit moderndescartes.com → On Hacker News Jan 2017 – May 2026

AI & Machine Learning 4Software Engineering 3Science & Space 2Databases & Data 2Society, Policy & Culture 1Math & Algorithms 1

1

For Want of a JOIN

Once upon a time, I was on a small team tasked with building a data pipeline. On this team was someone we’ll call Bob, who was fresh out of grad school and hadn’t had much experience with software engineering, and no experience with SQL. As part of this data pipeline, Bob had to combine the data from two tables. JOIN…