←back to thread

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

(github.com)
115 points graderjs | 1 comments | 06 Nov 20 03:19 UTC | HN request time: 0.216s | source
Show context
codenesium ◴[06 Nov 20 04:30 UTC] No.25004913[source]▶
Is sqlite not diffable?
replies(3): >>25005043 #>>25005217 #>>25005391 #
Jakob ◴[06 Nov 20 05:36 UTC] No.25005217[source]▶
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
replies(1): >>25005630 #
1. djeiasbsbo ◴[06 Nov 20 07:07 UTC] No.25005630[source]▶
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.