A personal index of thoughts, ideas & code
Making sense
of complex things.
I’m Jonathan Sacramento. I work with data, build 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.
02Code & experiments
All projectslorix
DataFrames in Javascript
JavaScriptsassy
Simple but powerful language for text interpolation
Language designtransflow
[in dev] DAG-based workflows in Javascript
JavaScriptdata streaming
Docker-based data streaming PoC with Kafka, Spark, and Zeppelin
Data infrastructuretpose
Transpose or “pivot” delimited text files in parallel
Cbtree
In-memory btree library in C
C