News for hackers. Stuff that matters.

A comment on Gitqlite: Query Git Repositories with SQL. Parent comment

Re:Gitqlite: Query Git Repositories with SQL by cryptonector on Sunday July 05, 2020 @01:42AM (#23736854)
Scale. Microsoft couldn't make a SQL VCS work. Maybe it's because they tried to use SQL Server instead of PostgreSQL, I dunno :) but IIRC the amounts of metadata involved essentially meant that they had no hope of doing git-like cloning: it was too much to clone.
[ Parent | on HN ]
Re:Gitqlite: Query Git Repositories with SQL by sitkack on Tuesday July 14, 2020 @02:27AM (#23829131)
You would need to implement a persistent datastructure, but without refcounts, you would have to do a gc. I guess you could do a refcount tree and only RC at the last common node.

Really atime is the devil. Funny thing is, is that all modern higher level systems have some form of data access logging, which is what you want anyway. So why not form some easily compressible event log?

[ Parent | on HN ]