Welcome to the new site
The site is now a static Pelican build — faster, simpler, and easier to keep running for years.
Read moreHi, I'm Jacob. I build software for a living and take photographs for the love of it. This site is where I keep my writing and a gallery of frames I'm proud of — no trackers, no clutter, just a fast static site.
Most of the tools I used to run here now live in dedicated open-source apps, so these pages stay deliberately simple.
Latest writing
All postsAggregating Using Unpivot
A common task when analyzing data concerning a population is to determine how various subpopulations compare to one another. If the sub populations are nonoverlaping populations, a simple group by...
Read moreWhen Join Order Matters
write this later
Read more