A personal index of thoughts, ideas & code
Hello, I’m Jonathan
I work with data, occasionally build useful software, and love understanding the systems underneath it all.
01From the blog
All postsPredicting Churn without Machine Learning
A practical way to understand customer behaviour through patterns of inactivity.
Clean SQL
On writing queries that are as easy to read as they are to run.
Improve your PostgreSQL workflow with vim and dbext
A tighter feedback loop for writing, running, and refining SQL.
On Transposing Data
Different ways to turn data around — and a small tool built for the job.