Pgit
A Git-like CLI backed by PostgreSQL
Get picks like this daily. Today's launch numbers, the top launches, AI and tech news, and a daily opportunity pick, straight to your inbox.
Want to reach these readers? Sponsor an issue.
HN · launched Mar 17, 2026 · 126 upvotes (top 7%) · 0 views
Niche: version control and updater software · 34 launches, 2 in the last 7 days · Explore this niche →
Category and tags
- Horizontal
- Dev tools
- Developer
- Not AI
- Hobby / open-source project
Visit website ↗ Source listing ↗
More like this: all 34 launches in version control and updater software →
Could you build this?
Partial Mapping the Git content-addressable storage model (blobs, trees, commits, refs) into relational PostgreSQL tables with a custom CLI is feasible, but handling Git diffing, merges, and packfile formats adds significant complexity.
What it would actually take: Building a functional Git CLI backed by Postgres requires modeling git objects (trees, commits, blobs) as Postgres relational tables and implementing the plumbing commands (write-tree, commit-tree, cat-file) as well as porcelain (status, commit, log, branch). The hardest components are three-way merge algorithms, binary diff computation, and ensuring transactional atomicity across simulated index/staging areas.
Discussion
20 comments analyzed.
Competitors mentioned: Fossil - alternative VCS with SQL backend, gitgres - Git history in Postgres, Gerrit - code review server, snkvin - SQLite key-value store
Concerns raised: Storage size not actually better than Git's compression, Delta compression slows down SQLite implementation, Large repo imports very slow (3+ hours for Linux kernel), Marketing emphasizes compression benefits that aren't primary value, Monorepo CI/CD cloning still slow without FUSE mount
Feature requests: FUSE filesystem mount for on-demand file fetching in CI, SQLite backend for small-medium repos instead of Postgres, Server-side branches and changesets for concurrent access, Multi-layer caching beyond in-memory to reduce RAM usage, Faster import performance for large repositories
Competitors
Other products that read as similar to this one : 2038 launches clear the similarity bar, closest 8 shown.
Attention rank: #136 of 2039 (itself plus its competitors, highest first, normalized so YC and Product Hunt are compared fairly).
Launched 137 days after the earliest competitor.
- Pgcraft · hn · 2026-05-26 · 6 upvotes · similarity 0.70
- aspen · github · 2026-11-05 · 94 upvotes · similarity 0.68
- Commitdog · hn · 2026-03-02 · 5 upvotes · similarity 0.63
- livediff · github · 2026-09-15 · 9 upvotes · similarity 0.63
- Learn by rebuilding Redis, Git, a database from scratch · hn · 2026-07-11 · 200 upvotes · similarity 0.63
- Forgejo Appliance, a private Git server based on OrbStack and Tailscale · hn · 2026-07-01 · 7 upvotes · similarity 0.63
- vrai · github · 2026-10-13 · 24 upvotes · similarity 0.63
- gitbolt · github · 2026-10-05 · 10 upvotes · similarity 0.62
The niche, labels, vibe code rating and competitor comparison on this page are analysis by Nicheloom. If you use them, please credit nicheloom.com. How you may use our data.