Skip to main content


For #projects today: sqlite-diffable

I really like keeping data in a git repository. This turns out to work great for anything less than a GB or so, and it's by far the quickest way I've found to get a version history of how data changes over time

Since I also like storing data in SQLite, I built an experimental little tool to dump a SQLite database out in an easy-to-diff format (even easier than a SQL dump itself), ready to commit to git:

https://github.com/simonw/sqlite-diffable