Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Show HN: My Private GitHub on Postgres

github.com

Post reply on HN
Print view View original

1–10 of 27 posts

Re: Show HN: My Private GitHub on Postgres

#2

Post by vishal_ch »

Interesting approach using Postgres as the storage layer. Curious how you're handling the object model since Git's content-addressable storage maps pretty differently to relational tables. Are you storing blobs as bytea or going with something like a JSONB tree structure for the commit graph?

Re: Show HN: My Private GitHub on Postgres

#5

Post by munk-a »

vishal_ch wrote: post #2

Interesting approach using Postgres as the storage layer. Curious how you're handling the object model since Git's content-addressable storage maps pretty differently to relational tables. Are you storing blobs as bytea or going with something like a JSONB tree structure for the commit graph?

While git internally uses a pretty loose system for connecting different model concepts that has always seemed more like a concession to the storage medium than a desired step. If git existed on an already ACID compliant system instead of trying to build one out of the filesystem itself I don't see a reason to keep all the references as loose as they are. If you can cascade changes with confidence you can likely just switch to using standard surrogate keys for linkages and allow the data to normalize more fully.

The core model objects in git are all pretty straightforward and their interactions well defined.

Re: Show HN: My Private GitHub on Postgres

#8

Post by xp84 »

"doesn't support: ... Web UI."

So, it's a git server with an interesting storage layer? Don't get me wrong, that part sounds like it might have been a ton of work to implement, but I think the web UI (pull requests, etc) is a lot of what Github has won on historically.

Basically I don't feel qualified to judge the product itself, but I think positioning it against Github, while popular given the recent hard times, isn't quite correct.

Post reply on HN