Developer imported Linux kernel's 1.4 million commits into PostgreSQL using pgit, a git-like CLI backed by a SQL database. The full 20-year history compressed to 1.95 GB, enabling SQL queries on kernel development patterns. Analysis revealed insights like bug fixes clustering around single commits and filesystem features taking 13 years to merge.
Infrastructure
Pgit: I Imported the Linux Kernel into PostgreSQL
Developer compressed 1.4 million Linux kernel commits into a 1.95GB PostgreSQL database, enabling SQL queries that revealed development patterns like bug fixes clustering and 13-year feature merge timelines.
Wednesday, April 8, 2026 12:00 PM UTC2 MIN READSOURCE: Hacker NewsBY sys://pipeline
Tags
infrastructure