frontpage.
newsnewestaskshowjobs

Made with ♥ by @iamnishanth

Open Source @Github

fp.

Open in hackernews

Show HN: My Private GitHub on Postgres

https://github.com/calebwin/gitgres
21•calebhwin•1h ago

Comments

vishal_ch•1h ago
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?
munk-a•55m ago
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.

Mic92•1h ago
Nice idea.
hk1337•1h ago
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?
hungryhobbit•7m ago
This seems like the elephant in the room.

I'm not saying this project isn't cool, but whenever you have ANY software that's designed to be hosted A-style, and you host it B-style, the obvious question is "Why not host it the A way?"

throwatdem12311•47m ago
Just use Fossil at this point.
lagniappe•46m ago
Fossil really has it all.
sikozu•20m ago
I'm waiting for somebody to create fossilhub
xp84•39m ago
"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.

JasonHEIN•31m ago
Great idea
iririririr•21m ago
just use ssh and git bare.
lisperforlife•17m ago
This 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 be in pure rust? Did you try running this on slightly heavier repository with a lot of commits, refs and objects?

AI uses less water than the public thinks

https://californiawaterblog.com/2026/04/26/ai-water-use-distractions-and-lessons-for-california/
123•hirpslop•2h ago•92 comments

Spotify adds 'Verified' badges to distinguish human artists from AI

https://www.bbc.com/news/articles/c5yerr4m1yno
49•reconnecting•2h ago•16 comments

Ask HN: Who is hiring? (May 2026)

150•whoishiring•4h ago•171 comments

New research suggests people can communicate and practice skills while dreaming

https://www.newyorker.com/culture/annals-of-inquiry/its-possible-to-learn-in-our-sleep-should-we
24•XzetaU8•1h ago•2 comments

whohas – Command-line utility for cross-distro, cross-repository package search

https://github.com/whohas/whohas
77•peter_d_sherman•4h ago•18 comments

Ask HN: Who wants to be hired? (May 2026)

89•whoishiring•4h ago•163 comments

Sally McKee, who coined the term "the memory wall", has died

https://www.online-tribute.com/SallyMcKee
84•deater•4h ago•9 comments

Show HN: My Private GitHub on Postgres

https://github.com/calebwin/gitgres
22•calebhwin•1h ago•13 comments

Understand Anything

https://github.com/Lum1104/Understand-Anything
30•taubek•1h ago•6 comments

City Learns Flock Accessed Cameras in Children's Gymnastics Room as a Sales Demo

https://www.404media.co/city-learns-flock-accessed-cameras-in-childrens-gymnastics-room-as-a-sale...
38•joshcsimmons•47m ago•3 comments

I'm Peter Roberts, immigration attorney who does work for YC and startups. AMA

93•proberts•4h ago•143 comments

Show HN: WhatCable, a tiny menu bar app for inspecting USB-C cables

https://github.com/darrylmorley/whatcable
313•sleepingNomad•10h ago•113 comments

Show HN: AI CAD Harness

https://fusion.adam.new/install
13•zachdive•1h ago•4 comments

Running Adobe's 1991 PostScript Interpreter in the Browser

https://www.pagetable.com/?p=1854
102•ingve•7h ago•21 comments

The X-Files Has Made Me Nostalgic for a Time I Never Experienced

https://midnightmurmurations.substack.com/p/the-x-files-has-made-me-nostalgic
58•Teever•1h ago•30 comments

Artemis II Fault Tolerance

https://alearningaday.blog/2026/05/01/artemis-ii-fault-tolerance/
8•speckx•1h ago•1 comments

An open letter asking NHS England to keep its code open

https://keepthingsopen.com
150•tvararu•4h ago•8 comments

The Gay Jailbreak Technique

https://github.com/Exocija/ZetaLib/blob/main/The%20Gay%20Jailbreak/The%20Gay%20Jailbreak.md
125•bobsmooth•2h ago•37 comments

The end of "Just ask Sarah"

https://simme.dev/posts/the-end-of-just-ask-sarah/
18•milkglass•2d ago•11 comments

A statement about why RightsCon 2026 will not take place in Zambia

https://www.rightscon.org/rc26-statement/
57•benbreen•46m ago•12 comments

AWS stops billing Middle East cloud customers as repairs to war damage drag on

https://arstechnica.com/gadgets/2026/05/amazon-stuck-with-months-of-repairs-after-drone-strikes-o...
49•johnbarron•1h ago•13 comments

Your Website Is Not for You

https://websmith.studio/blog/your-website-is-not-for-you/
222•pumbaa•8h ago•156 comments

New copy of earliest poem in English, written 1,3k years ago, discovered in Rome

https://www.tcd.ie/news_events/articles/2026/caedmons-hymn-discovery/
185•giuliomagnifico•2d ago•114 comments

Canonical/Ubuntu have been under DDoS

https://status.canonical.com/#/incident/KNms6QK9ewuzz-7xUsPsNylV20jEt5kyKsd8A-3ptQEHpOd8VQ40ZQs-K...
120•jtlebigot•11h ago•42 comments

Advanced Quantization Algorithm for LLMs

https://github.com/intel/auto-round
101•lastdong•10h ago•14 comments

Show HN: Loopsy, a way for terminals and AI agents on different machines to talk

https://github.com/leox255/loopsy
34•todience•8h ago•8 comments

Uber torches 2026 AI budget on Claude Code in four months

https://www.briefs.co/news/uber-torches-entire-2026-ai-budget-on-claude-code-in-four-months/
328•lwhsiao•3h ago•356 comments

Flock cameras keep telling police a man who doesn't have a warrant has a warrant

https://www.youtube.com/watch?v=nHwxV0Sd9V8
151•johnbarron•1h ago•108 comments

Apocalypse Early Warning System

https://ews.kylemcdonald.net/
8•carlsborg•3h ago•0 comments

OpenWarp

https://openwarp.zerx.dev
182•zero-lab•17h ago•133 comments