MurphyA/hacker-news huggingface dataset:
Show HN: postgres-graph-rag – High-precision Graph RAG native to PostgreSQL
by h4gen | 2025-12-21 18:47:06+00:00
Hi HN,

I built this because I’m tired of the standard RAG stack becoming a distributed system. Usually, if you want GraphRAG to solve multi-hop reasoning, you’re told to add Neo4j or a specialized GraphDB to your stack. Now you have three databases to keep in sync: your relational source of truth, your vector store, and your graph nodes. And also you have to deal with Neo4j and who wants that if you can have Postgres?

postgres-graph-rag is for the Postgres Maximalists. It turns your existing DB into a structured knowledge engine using SQL Recursive CTEs instead of expensive LLM-agent loops.

Features: - No Infra Sprawl: If you have Postgres, you have GraphRAG. - Incremental by Design: Most GraphRAG research is batch-heavy. This handles atomic upserts in real-time. - Forever Schema: Uses a JSONB + Namespace pattern to avoid future migrations.

It’s open source and I’d love to hear your thoughts on the Recursive CTE approach for graph traversal in production environments.

Repo: https://github.com/h4gen/postgres-graph-rag
by jmyeet | 2025-12-21 18:47:19+00:00
I thought this was going to be Peter Thiel but if he's on brand, he's living under or in a volcano on a tropical island somewhere. Plus he probably can't stand on previously consecrated ground.

Honestly, Palantir is one of those companies where I think I'd rather be homeless than work there. The amount of direct evil Palantir is responsible for is hard to overstate (eg [1]).

The rich are just trading assets with Monopoly money at this point. None of it's real. I have to wonder how far we are from the richest 10,000 owning literaly everything where the rest of us are just living in worker housing on grand estates, in debt that'll never be paid off, the latest incarnation of South Asian brick kilns.

[1]: https://www.business-humanrights.org/es/%C3%BAltimas-noticia...
by wartywhoa23 | 2025-12-21 18:47:31+00:00
So either these folks, who are admittedly living targets of all the world's copyright lawyers, have means to receive tens of thousands of USD anonymously and stealthily,

or they are totally immune to deanon / getting tracked down,

or they are stupid enough to allow their greed to become their downfall,

or this legend about underground warriors of light fighting against evil copyrighters is utter bullshit.
by teddyh | 2025-12-21 18:47:44+00:00
Many years ago, before mobile internet was reasonable and before wireless internet was available, and before even electrical outlets were something which could be counted on to be present on trains, I took a 6 hour train ride. I had no laptop. I printed out, on paper, the entire source code of the project I was working on, and brought a red pen. I read through the whole thing, from start to finish. Many subtle bug fixes, refactorings, and efficiency improvements were made that day.
by dylanhouli | 2025-12-21 18:47:55+00:00
Wow really nicely built site and great story behind it.

I'd imagine you didn't just publish it in 2017 and magically start gaining traffic. Any good marketing tips learned along the way? It must've been tough at first since this type of game seems to get more fun the more players you have.

Anywhere I could read more about how you got your first users and such? I'm about to launch another one of my own web projects and marketing is always the toughest part.
by AndrewDucker | 2025-12-21 18:48:26+00:00
No mention of round-trip efficiencies, and claims are that it's 30% cheaper than Li-Ion. Which might give it an advantage for a while, but as Li-Ion has become 80% cheaper in the last decade that's not something which will necessarily continue.

Great if it can continue to be cheaper, of course. Fingers crossed that they can make it work at scale.
by Noaidi | 2025-12-21 18:48:54+00:00
Buy gold and silver. Seriously. If you do not see the precipice we are a top of I have nothing else to say. ever since the great recession the Fed has been propping up the economy with low interest rates and Quantitative Easing. There is no way out of this but for an even greater depression.

All these fake trump bucks and investment plans are not for the children, they are for the investors that need the money in the market as another way to prop it up. The whole thing with Dell giving this money to these kids? Bullsht. He gave it to himself and to other investors. Nothing but a new kind of stock buyback plan.

Get ready to see poverty, and get ready to help each other. We are living through the 1920's again and it is crazy very few see it.
by alexwennerberg | 2025-12-21 18:49:25+00:00
> Logs were designed for a different era. An era of monoliths, single servers, and problems you could reproduce locally. Today, a single user request might touch 15 services, 3 databases, 2 caches, and a message queue. Your logs are still acting like it's 2005.

If a user request is hitting that many things, in my view, that is a deeply broken architecture.
by markus_zhang | 2025-12-21 18:49:53+00:00
Tip for future parents from current parent:

Install a lockable room within your home before you have a baby, if it is financially available. And once the baby is delivered, instill him/her as early as possible with the concept of a private space -- a private space is not to be invaded by anyone else, including family members, unless invited.

This is especially important for a male.

You future self will thank your current self.

Bonus tip: Put everything you don't want your kid to touch in a place that your kid cannot reach physically. And make sure no chairs close by.
by netsharc | 2025-12-21 18:50:03+00:00
I find it fascinating that people can be convinced that they are very very rational, but they can also be convinced about crazy things, things like that the Earth is a flat disc, or that Bill Gates and the rest of the secret cabal of elites are going to put 5G receivers through a mandated vaccination, or that races other than their own need to be eradicated...

It makes me worry that what if my belief that I'm rational is also skewed...
by whatamidoingyo | 2025-12-21 18:50:09+00:00
Eh, I've shared your views before. But Amazon affiliate link payouts are trash. The OP made it to the front page of HN, but I'd be surprised if he makes more than $100. It's possible, but probably highly unlikely. Let him them make some money, it's a cool project.

But, OP, if you're going to have this, disclaimers, and a privacy policy are really important (especially for collecting emails).
by theshrike79 | 2025-12-21 18:50:16+00:00
The same works the other way, and actually a lot better IMO.

Let's imagine a scenario with two identical restaurants with the exact same quality of food.

One sells their dish as a fully vegan option, but doesn't tell the customers.

Hardline "oorah, meat only for me" dude walks in and eats the dish, loves it.

If he goes to the other restaurant and is told beforehand that "sir, this dish is fully vegan" - do you think they'd enjoy it as much?

Prejudices steer people's opinions, a lot. Just like people stop enjoying movies and games due to some weird online witch-hunt that might later on turn out to be either a complete willful misunderstanding of the whole premise (Ghost in the Shell) or a targeted hate campaign (Marvels and many many other movies starring a prominent feminist woman).
by LeFantome | 2025-12-21 18:50:16+00:00
While I agree with you, I find that sometimes the “experience” can improve.

The most common “artifact” of AV1 is to make things slightly more blurry for example. A common H.265 artifact is “blockiness”. I have re-encoded H.265 to AV1 and not only gotten smaller files that playback better on low-end hardware but also display less blockiness while still looking high-resolution and great colour overall.

I always encode 10 bit colour and fast-decode for re-encoding to AV1, even if coming from an 8 bit original.
by general1465 | 2025-12-21 18:50:27+00:00
Buy some cheap computer like X99 with Xeon from AliExpress, add some cheap GPU like Tesla K80 and "train" your LLM models on it. Now you can pirate what you want and you are untouchable because every big AI company will give you lawyers for free of charge because if judge would decide against you, then the precedents would be against them as well.
by jimmydddd | 2025-12-21 18:50:32+00:00
It was a metaphor. It's not meant to be literal. It helps to prompt questions like -- "why do we create the fiction that every job from janitor, to scientist to marketing requires precisely 40 hrs per week, every week?" It also helps explore ideas like, "if I got an illness and could only work one hour a day to keep my business running, how would I do it?" In other words, it's helpful to exlore our use of time.
by tetromino_ | 2025-12-21 18:50:50+00:00
If the author is disturbed by criticism and nitpicking, they are completely right to make their words private. (The old saying "if you can't take the heat, stay out of the kitchen" is usually said in mockery. But I suggest that it can be read straight, not as mockery but as practical life advice.)

All that said: the author's words

> But, it's no longer worth it to me to offer my knowledge and wisdom.

seriously annoy me. What kind of pompous sense self-importance does one need to have to unironically claim to possess wisdom?
by Noaidi | 2025-12-21 18:51:28+00:00
I know who I was thinking of. Theil is looking fro the Antichrist, and the antichrist is Karp.

Signs of the antichrist:

1. He will exalt himself. 2. He will heed his inner voice above others. 3. He will be hostile toward the true God. 4. He will exalt human logic above faith. 5. He will prosper for a season and be loved. 6. He will not desire women. 7. He will not follow the faith of his fathers. 8. He will viciously persecute Jews and Christians. 9. He will think of himself as greater than God. 10. He will become increasingly lawless. 11. He will honour military power above faith. 12. He will love wealth. 13. He will hoard precious things. 14. He will become a man of war. 15. He will wage a war on all people of faith. 16. He will force Israel to ratify a treaty. 17. He will divide Israel and Jerusalem. 18. He will invade Jerusalem. 19. He will enter the restored Temple. 20. He will declare himself above God.
by notepad0x90 | 2025-12-21 18:53:41+00:00
I think some of the book associations are wrong. It shows "the martian chronicles" for mentions of andy weir's "the martian".

Otherwise nice to see so many of the books i read this year mentioned. Except "Mein Kampf" of course, interesting top mention there. perhaps lots of people are reading it to understand the past? I'll need to see if it's worth it, I always considered it the equivalent of drinking water from the river thames to understand victorian england better.
by goda90 | 2025-12-21 18:54:00+00:00
Two times this week I biked past a parked car and it emitted a horrible high pitched buzzing at me. I'm guessing it's supposed to be an anti-theft mechanism(entirely unnecessary in a Midwest suburb). I of course had no intention of stealing the car, but the noise triggers a desire to do other things to the car. I guess the owner is lucky I'm not an angsty teenager.

There's so much unnecessary noise pollution in our society, it makes me really sad.
by thwarted | 2025-12-21 18:54:48+00:00
A Google search for vitamin d results in ads, ahem "sponsored results", for 180 servings for $27, which is about $55 for a full year assuming it's one serving per day, which is the same decimal order of magnitude as $10 (but, I suppose, since we are on HN, is three or four orders of magnitude in binary)
by theshrike79 | 2025-12-21 18:55:18+00:00
I commute to the office 1-3 times a week, it's about 30 minutes on the train + some walking.

I've gone through so many books it's crazy :)

With audiobooks I can start listening the second I step out of the door and stop while I take my jacket off in the office. With e-books I usually just read on the train.

Most books aren't that long, around 5 hours a week of reading just during your commutes is quite a bit.
by marcosdumay | 2025-12-21 18:55:30+00:00
> Can someone explain to me how long this will be sustainable?

It fails through stagflation. There are lots of people speculating the US is doing that right now, but since their most recent inflation numbers are bad, nobody has the data to say it for sure.

Just increasing government debit isn't a problem by itself. It becomes a problem when that raising debit isn't making the economy grow.
by Dylan16807 | 2025-12-21 18:55:38+00:00
> Payout per stream is a terrible metric. It's almost like if you ranked grocery stores by payment per gram.

CDs are usually similar prices. Per-stream isn't nearly as bad as wildly different products sharing prices.

We could debate per stream versus per minute but I don't know if that's a particularly big effect. It causes some annoyance but it's mostly compensated for already.

Anything that gives different value to different artists is probably going to favor the big ones and just make things worse.
by sigseg1v | 2025-12-21 18:55:45+00:00
From my experience working on B2B applications, I am happy that everything is generally spammed to the logs because there would simply be no other reasonable way to diagnose many problems.

It is very, very common that the code that you have written isn't even the code that executes. It gets modified by enterprise anti virus or "endpoint security". All too often do I see "File.Open" calls return true that the caller has access, but actually what's happened is AV has intercepted the call, blocked it improperly, and returns 0 bytes file that exists (even though there is actually a larger file there) instead of saying the file cannot open.

I will never, in a million years, be granted access to attach a debugger to such a client computer. In fact, they will not even initially disclose that they are using anti virus. They will just say the machine is set up per company policy and that your software doesn't work, fix it. The assumption is always that your software is to blame and they give you nearly nothing, except for the logs.

The only way I ever get this solved in a reasonable amount of time is by looking at verbose logs, determining that the scenario they have described is impossible, explaining which series of log messages is not able to occur, yet occurred on their system, and ask them to investigate further. Usually this ends up being closed with a resolution like "Checked SuperProtectPro360 logs and found it was writing infernal error logs at the same time as using the software. Adjusted the monitoring settings and problem is now resolved."
by twosdai | 2025-12-21 18:55:50+00:00
I understand where the author is coming from but frankly I think this design pattern is not really correct.

Obviously this depends on teams, application context and code bases. But "knowing if action needs to be taken" can't be boiled into a simple log level for most cases.

There is a reason most alerting software like pagerduty is just a trigger interface and the logic for what constitutes the "error" is typically some data level query in something like datadog, sumologic, elastic search, or graphana, that either looks for specific string messages, error types, or a collection of metric conditions.

Cool if you want to consider that any error level log needs to be an actionable error but what quickly happens is that some error cases are auto retry able due to infrastructure conditions that the application has completely no knowledge of. And to run some sort of infrastructure query at error write time in code, eg

1. Error is thrown 2. Prior to logging guess/determine if the case can be retired through a few http calls. 3. Log either a warning or an error

Seems to be a complete waste when we could just write some sort of query in our log/metrics management platform of choice which takes into account the infrastructure conditions for us.
by zahlman | 2025-12-21 18:56:44+00:00
> I got tired of doing this for every project:

Then don't. All the activate script is really doing is setting a few environment variables. You can just specify the path to the venv's Python directly. Or use any number of other existing management tools. (Many of them do more sophisticated management than this. For example, permanently setting up the PATH so that `python` finds a shim executable that considers the CWD and finds the corresponding venv by whatever policy.)

> And the "just put it in a script" idea is misleading. Activation only sticks if it runs in your current shell. If you run a script, it runs in a subshell, so your terminal never actually gets activated.

So put it in an alias (like how your approach works), or source the script.

By the way, you can avoid the overhead of bootstrapping pip using the `--without-pip` option for `venv`, and then use an external copy of pip with `--python`. There are drawbacks to this, but it's generally better if you aren't going to run pip many times per venv and don't have to deal with EOL Python installs. I describe this incidentally in https://zahlman.github.io/posts/2025/01/07/python-packaging-....

> Also, if you have conda installed, python3 might point to conda's Python. That can create confusing venvs. This tool uses /usr/bin/python3 by default to avoid surprises.

That's a system-level config issue that the minority of Conda users should presumably already be aware of, if they really need to create both Python venvs and Conda environments.
by metadope | 2025-12-21 18:57:01+00:00
> gets shown to be completely factually wrong on children

I'm not sure I understand this. Who/what has shown Golding's classic novel to be "completely factually wrong"? How did you establish this? Is there a reference you could steer me towards?

I'd really be interested in exploring the background of where this idea comes from-- my curiosity piqued: Is Lord Of The Flies a misrepresentation of childhood savagery? Is there no such thing? What is it that you are contending here, and where did you get this idea?

TIA!
by Galxeagle | 2025-12-21 18:57:52+00:00
One of the big design challenges with self-driving cars like Waymo is communication with pedestrians - have to have some analogue to making eye contact or waving so pedestrians know they've been seen (possibly through audio or LED message signs)[0]

It's fascinating to me that a plane in full (emergency) autonomous mode, having run an algorithm to identify airport and landing sequence, is using speech to text to broadcast over analogue radio to the humans in the area. And the tower tentatively communicating back ('Outfitter 9, if you can hear me, cleared to land...') to do the expected final step in the exchange.

https://www.theverge.com/2023/10/13/23913251/waymo-roof-dome...
by thomassmith65 | 2025-12-21 18:58:01+00:00
I hesitated to post this. It's in questionable taste, considering the fatwa has caused harm to multiple people now. Still, it's interesting!

The following link about Rushdie is more cheerful:

BBC Desert Island Discs: Sir Salman Rushdie https://bbc.co.uk/programmes/m002mmcq
by nephihaha | 2025-12-21 18:58:27+00:00
I think this is based a lot around Earth paradigms. Microbial life is probably very common through the universe, more complex varieties less so. There does appear to be some evidence of life on/in Mars and in the upper atmosphere of Venus, although this is disputed.

Even on Earth we can find life in harsh environments, a mile down in rock, a mile up in the air, and in the deepest parts of the ocean. Some life tolerates extreme heat and cold, acid/alkaline conditions and high salt levels.
by IlikeKitties | 2025-12-21 18:58:45+00:00
> The EU Commission and several member states are also looking for new rules on data retention. In a new ”Presidency outcome paper”, the member states discuss metadata retention: which websites you visit, and who is communicating with whom, when and how often. The ambition is “to have the broadest possible scope of application” and this time some member states also want the proposal to include VPN services.
by epsters | 2025-12-21 18:59:45+00:00
Searched 'Ehud Barak' in Jmail and the results were disappointing. Which was odd because I recently read many interesting revelations about their relationship and Epstein's ties with Israel gleaned from emails between the two. The emails apparently revealed Epstein's vital role in forging security deals between Israel and the governments of Cote d'Ivore and Mongolia; Others showed Epstein offering to connect Putin with Ehud and trying to hatch a plot to replace Bashar-Al-Assad in Syria with another pro-Russian dictator - but one who would be pro-Israel also (it didn't pan out). And also emails showing Epstein setting up an introduction between Ehud Barak and Peter Thiel. Found none of this in the results.

Turns out most of the above revelations came from Ehud Barak's own hacked email account which were recently leaked by Handala, purportedly a pro-palestinian hacking group. None of the this stuff was covered in any of the mainstream news- Not by NYT , BBC, CNN, nothing. Most of the journalistic coverage had been from DropSite News. And what did The Guardian decide at the time to focus on in it's featured story regarding Epstein? Noam Chomsky.

That pretty much tells you everything you need to know about what Jeffrey Epstein was about and the role of the Governments and Media in all this. I don't believe the truth regarding Epstein will come from the 'Epstein Files', the US government, its allies or the mainstream western press. It will probably have to be from hackers, whistleblowers or the victims willing to break their confidentiality agreements. Or from any dead-mans-switches that the feds haven't manage to find and neutralize.

https://sfstandard.com/2025/11/23/extended-courtship-linking...

https://www.dropsitenews.com/p/jeffrey-epstein-ehud-barak-le...

https://www.dropsitenews.com/s/epstein-and-israel
by HarHarVeryFunny | 2025-12-21 18:59:57+00:00
Waymos rely on remote operators to take over when the vehicle doesn't know what to do, and obviously if the remote connection is gone then this is no longer available, and one might speculate that the cars then "fail safe" by not proceeding if they are in a situation where remote help is called for and inaccessible.

Perhaps traffic lights being out is what caused the cars to stop operating autonomously and try to phone home for help, or perhaps losing the connection home is itself enough to trigger a fail safe shutdown mode ?

It reminds a bit of the recent TeslaBot video, another of their teleoperated stunts, where we see the bot appearing to remove a headset with both hands that it wasn't wearing (but that it's remote operator was), then fall over backwards "dead" as the remote operator evidentially clocked off his shift or went for a bathroom break.
by lambdaone | 2025-12-21 19:00:12+00:00
This seems almost too good to be true, and the equipment is so simple that it would seem that this is a panacea. Where are the gotchas with this technology?

Clearly power capacity cost (scaling compressors/expanders and related kit) and energy storage cost (scaling gasbags and storage vessels) are decoupled from one another in this design; are there any numbers publicly available for either?
by zkmon | 2025-12-21 19:01:01+00:00
> Logs were designed for a different era. An era of monoliths, single servers, and problems you could reproduce locally. Today, a single user request might touch 15 services, 3 databases, 2 caches, and a message queue. Your logs are still acting like it's 2005.

Logs are fine. The job of local logs is to record the talk of a local process. They are doing this fine. Local logs were never meant to give you a picture of what's going on some other server. For such context, you need a transaction tracing that can stitch the story together across all processes involved.

Usually, looking at the logs at right place should lead you to the root cause.