TLDR Tech / Dev
pgit: What If Your Git History Was a SQL Database?
pgit is a Git-like command-line interface that stores repository history in a PostgreSQL database, making its entire commit and file version history queryable via SQL. It uses pg-xpatch, a custom PostgreSQL storage engine with automatic delta compression, which often outperforms Git's aggressive compression mode. This allows for powerful programmatic analysis of codebase metrics like churn, coupling, and bus factor.
Read the full story