Show HN: Sir – Git-diff-able JSON database on yer filesystem

I would export the DB and use that for your diff/version control:

  sqlite3 yourdb.sqlite .dump

If you really want to track the binary e.g. inside git, but still see textual diffs you would put that into your .gitconfig:

  [diff "sqlite3"]
    textconv = sqlite3 $1 .dump

To expand on this, you can now even export to markdown and basically have a nice overview of the database. I use this in my notes which are all written in markdown because markdown tables are painful to organise per hand.