Interesting idea but what's the use case for this? Why wouldn't I just create a private git server (gitlab, forgejo, etc) just for myself?
as the other replies mention, efficient querying can be fun
https://oseifert.ch/blog/building-pgit
Show HN: My Private GitHub on Postgres
21–27 of 27 posts
Re: Show HN: My Private GitHub on Postgres
#22"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, is…
> "doesn't support: ... Web UI." "Doesn't" doesn't mean "can't". Someone just needs to do the work (with no thanks or pay expected). edit: the perspective of open source projects has really changed in the last 10 years, from collaboration to nice personal projects now being referred to as "the product".
I apologize if that’s how my tone has come across. I think I just got distracted by the comparison. I think it’s very cool as a project.
Re: Show HN: My Private GitHub on Postgres
#23I can't even view the commits because GitHub is claiming I'm over a request rate limit. This is the first time I've even opened GitHub today. Time to knock another 9 off their status page.
Re: Show HN: My Private GitHub on Postgres
#24"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, is…
> "doesn't support: ... Web UI." "Doesn't" doesn't mean "can't". Someone just needs to do the work (with no thanks or pay expected). edit: the perspective of open source projects has really changed in the last 10 years, from collaboration to nice personal projects now being referred to as "the product".
> "Doesn't" doesn't mean "can't". Someone just needs to do the work
Sure, but isn't that the case for any feature of any software?
Re: Show HN: My Private GitHub on Postgres
#25This is really cool. PG has zlib compression on TOAST objects so this should still be okay even if you are not storing pack files. I am curious with your choice of hand-rolling pktline, upload-pack and receive pack implementations including rev-walking. Any particular reason you did not want to use libgit2 or something like the gitoxide implementation of pkt-line. Was it performance or is it because you wanted it to…
> PG has zlib compression on TOAST objects so this should still be okay even if you are not storing pack files.
Along those lines, even zlib could probably be skipped if the underlying filesystem is a compression capable one. ZFS can, though there are probably others as well.
Re: Show HN: My Private GitHub on Postgres
#26[dead]
Re: Show HN: My Private GitHub on Postgres
#27Earlier quoted context omitted.
> "doesn't support: ... Web UI." "Doesn't" doesn't mean "can't". Someone just needs to do the work (with no thanks or pay expected). edit: the perspective of open source projects has really changed in the last 10 years, from collaboration to nice personal projects now being referred to as "the product".
> "Doesn't" doesn't mean "can't". Someone just needs to do the work Sure, but isn't that the case for any feature of any software?
Sure, but the context changes who "someone" can be. In this case, it's a personal open source project with pull requests open, where that "someone" means "anyone". We can implement the feature if we want, and for our efforts, we must expect as much in return as the original author received: nothing. Open source used to be abut collaboration, now it's mostly abuse.
If you want to add a feature to GitHub, that "someone" would neccesarily be a paid employee.