Why SQLite Is Taking over with Brian Holt and Marco Bambini

Re:Why SQLite Is Taking over with Brian Holt and Marco Bambini by Karellen on Wednesday June 12, 2024 @07:04AM (#40656676)

AFAIK git has pluggable diff and merge engines. I wonder if it would be possible to create a diff/merge git plugin for sqlite files that does an intermediate conversion to .sql dump files, with some kind of serialisation normalisation so that rows are output in a stable order between runs.

[ Parent | on HN ]

Re:Why SQLite Is Taking over with Brian Holt and Marco Bambini by simonw on Wednesday June 12, 2024 @07:29AM (#40656842)

I haven't tried it with git pluggable diff tools yet, but I wrote a tool that lets me convert a SQLite database into a bunch of plain text files so I can manage them in git: https://github.com/simonw/sqlite-diffable

[ Parent | on HN ]

Re:Why SQLite Is Taking over with Brian Holt and Marco Bambini by TeMPOraL on Wednesday June 12, 2024 @07:25AM (#40656809)

It is. It's a bit of a hassle, because the git mechanism that allows it is considered sensitive, so all users of your repo will need to separately configure this if they want to use it.

Bigger problem for me is that none of the code review systems I know of support this. At work, we've been wishing to have something like this in Gerrit, due to multiple SQLite DBs and other binary documents living in the repo, but as far as we can tell, we'd have to modify Gerrit sources directly to make it happen, which IT would frown at and nobody has time for anyway.

[ Parent | on HN ]

Re:Why SQLite Is Taking over with Brian Holt and Marco Bambini by type0 on Wednesday June 12, 2024 @06:15PM (#40663793)

Not git, but I find it's interesting how Fossil implements version control https://www.fossil-scm.org/home/doc/trunk/www/tech_overview....

[ Parent | on HN ]