Versioning data in Postgres? Testing a Git like approach

Re:Versioning data in Postgres? Testing a Git like approach by iamwil on Friday October 20, 2023 @01:32PM (#37959050)

> Naively when you read a git diff or a pull request, you might think like me, that git is storing a diff between A and B and just displays it when needed. But in reality it stores the full file in the object storage.

I thought logically git stored every file, but implementation-wise, it does git-object compaction. So in reality, it's not actually storing every file on disk, no?

[ Parent | on HN ]

Re:Versioning data in Postgres? Testing a Git like approach by tynorf on Friday October 20, 2023 @01:43PM (#37959193)

The objects directory stores every file (and tree, commit, etc). Pack files are an optimization storing diffs.

[ Parent | on HN ]

Re:Versioning data in Postgres? Testing a Git like approach by shepherdjerred on Friday October 20, 2023 @02:02PM (#37959429)

Which is such a genius implementation. You get the straightforward implementation of using plain files (e.g. not deltas), while also being able to get the storage boost from storing deltas.

[ Parent | on HN ]