News for hackers. Stuff that matters.
Re:We’re happy with SQLite and not urgently interested in a ... by kimi on Friday May 04, 2018 @12:53PM (#16996061)
Related note: in the last year I started using SQLite with my Clojure scripts instead of using a remote database, and I'm storing everything in git. Works like a charm for single-user tasks.
Re:We’re happy with SQLite and not urgently interested in a ... by kozhevnikov on Friday May 04, 2018 @12:55PM (#16996070)
Do you store the binary .sqlite in Git or source .sql and build the .sqlite?
Re:We’re happy with SQLite and not urgently interested in a ... by kimi on Saturday May 05, 2018 @02:39AM (#17000667)
I store the binary; it's small. But of course you could use a filter, e.g. https://github.com/DataWraith/gitfilters
Re:We’re happy with SQLite and not urgently interested in a ... by bachmeier on Friday May 04, 2018 @01:54PM (#16996655)
Wouldn't tracking the binary with Git make a new copy on every commit?
Re:We’re happy with SQLite and not urgently interested in a ... by aphx on Friday May 04, 2018 @02:35PM (#16997074)
The .db file can change, even if the data/records don't. One approach is to dump the sql to text and store that in git. (e.g. https://stackoverflow.com/a/846665)