3 ms·
> It's a neat trick, but storing binary files like that in Git isn't as space efficient as using a plain text format. Why is that? I would have expected git's
by tlb 3y ago
> It's a neat trick, but storing binary files like that in Git isn't as space efficient as using a plain text format.
Why is that? I would have expected git's delta compression to work well on sqlite files, since small table changes usually cause only a small number of page changes.
- dunham 3y agoI would think so too. As a quick test I added chinook.db to a fresh repository, committed it, added a row to a table, committed again, and then did a git gc. The resulting pack file, with two revisions of the database, is 329k. The raw database is 864k and gzips to 328k. So it does look like git's delta encoding works with sqlite's blocks.