MurphyA/hacker-news huggingface dataset:
Show HN: pg_stream – incremental view maintenance for PostgreSQL in Rust
by grove | 2026-02-26 19:17:49+00:00
pg_stream is a PostgreSQL 18 extension that keeps materialized views current
incrementally — no external infrastructure, no separate streaming pipeline.

You define a stream table (a SQL query + a freshness bound) and the extension
derives a delta query that processes only changed rows on each refresh cycle:

SELECT pgstream.create_stream_table(
'regional_totals',
'SELECT region, SUM(amount) AS total, COUNT(*) AS cnt
FROM orders GROUP BY region',
'1m',
'DIFFERENTIAL'
);

One INSERT into a million-row table → pg_stream touches one row's worth
of computation. Query it like any regular table.

How it works:
- Trigger-based CDC captures row changes into buffer tables inside the same
transaction (no wal_level = logical required)
- A background worker walks a topological DAG of stream tables and fires
refreshes in dependency order
- The DVM engine (differential view maintenance, DBSP framework) rewrites
your SQL into a delta query at definition time — JOINs, GROUP BY, CTEs,
window functions, LATERAL, subqueries all supported
- Stream tables can depend on other stream tables; a change to a base table
cascades automatically through the entire chain

Written in Rust using pgrx. 1,300+ tests (unit + integration + E2E).
dbt macro package included.

GitHub: https://github.com/grove/pg-stream
Docs: https://grove.github.io/pg-stream
by api | 2026-02-26 19:18:47+00:00
Valid point. I'm referring to the idea that you can achieve total equity, including rewinding history and un-doing the wrongs of the past, through legislative mechanisms, or maybe by being guilty enough and doing enough performative pennance. We can un-genocide the native Americans and un-enslave Africans if we... something? I'm actually not sure about that part. Obviously this is impossible because time travel doesn't exist, and nobody can be held responsible because all the perpetrators of those crimes are dead. The best we can do in the real world is try not to do things like this going forward, but present reality isn't encouraging.

As you can probably read into what I'm writing, I generally think today's far left and far right are insane. They form a kind of resonating cavity of insanity. The far left makes the far right seem like they might have a point, and vice versa, but they're both nuts. You might consider it a kind of stupidity laser where we are the lasing medium, our anger is the energy, and the two "mirrors" are the two sides. Each is a mirror because when you look at it closely, you run away, but then you just hit the other side and bounce back, because it's all crazy.

I don't believe in burning the world down. I do believe the current narrative zeitgeist should be burned to the ground. I think it's mostly a product of social media algorithm driven brain rot.

The problem with a politics of rage, grievance, and fantasy, is that it's ultimately impotent. It will never achieve anything. It sucks up peoples' attention and effort and delivers nothing.
by doctorpangloss | 2026-02-26 19:20:01+00:00
i like their positions. but. i don't know what the point of strong towns is. people feel very strongly (haha) about it.

i can advocate for all sorts of stuff that is unpopular. it's meaningless. this is the hard thing about advocacy! strong towns spends a lot of words on stuff, but none of it on why someone who is happy with SFH cars lifestyle do, whatever it is they are asking that person to do.

> The entire point by Strong Towns is that people don't pay for it.

okay, people aren't paying for the ADA stuff. that's bad. but it's not a crisis. SFH cars people are living in that status quo every day. and it's not because they don't care and or because they are not disabled. i don't know how much the ramp codes really matter, i am not an expert, i understand that some experts in some narrow sense say they matter, but the real problem is a lack of leadership on holistic, bigger-picture issues like how to balance the costs and benefits of these sorts of requirements. we arrive at that cost-benefit organically right now, over and over again, in the absence of leadership, and most people seem pretty happy with it, which is a huge refutation of what strong towns is saying. do you get it?

strong towns says, "paying for this shit that doesn't matter does matter", which is wrong!
by e1g | 2026-02-26 19:20:55+00:00
+1 for the idea. Enforcing hard boundaries between is surprisingly helpful for AIs to reason about how to structure their changes.

We recently rolled out our own static analysis using oxc-parser and oxc-resolver, and it runs surprisingly fast (<1s for ~100K LOC). For us, it was definitely worth adding this layer of defence against The Slop.
by RGamma | 2026-02-26 19:21:11+00:00
IMHO if you can afford some setup time just skipping the DE entirely is still the best option. My i3wm setup plus some scripts and services was super lean and efficient. Still buried it for reasons I can't remember, switched distro too, but when I find the time I'm eager to create a tiling WM, wayland native UI on NixOS again.
by craftkiller | 2026-02-26 19:21:19+00:00
I definitely agree that is weird and off-putting, but I recently moved to an area with a grocery store that is the complete opposite: the cashiers stand there silently through the whole order. That's also off-putting despite my introversion. I think we need a middle ground with a simple mandatory polite greeting like "Welcome to Hank's" and then after that leave it up to being organic/authentic.
by the_af | 2026-02-26 19:21:40+00:00
> It's hard to tell any more.

Wait, I think I have the answer!

"You're in a desert, walking along in the sand when all of a sudden you look down and see a tortoise. It's crawling toward you. You reach down and flip the tortoise over on its back. The tortoise lays on its back, its belly baking in the hot sun, beating its legs trying to turn itself over. But it can't. Not without your help. But you're not helping. Why is that?"
by hardolaf | 2026-02-26 19:21:49+00:00
I also live in Chicago but unlike you, I have musculoskeletal issues that can be minor to the point of not noticing or to the point of it being painful to walk more than 2-3 blocks at a time. So doubling the distance between blocks would be the difference between me being able to use the bus and me needing to drive or use the far more expensive for taxpayers paratransit service.

And beyond that, the 6% of average time savings seen in studies of similar systems would be about the same improvement as adding curb bump outs which would save the bus time by not needing to repeatedly merge back into traffic. And that work is already happening across the city without inconveniencing anyone or causing users with disabilities from being discriminated against by armchair urban planners.
Show HN: Tasuki – A Task Aggregator for Waybar
by zfleeman | 2026-02-26 19:21:55+00:00
I'm loving the momentum behind Linux, particularly Arch, right now. I've used it for years but recently have been switching all of my workflows to it. I wanted a quick way to see all my tasks at a glance without context-switching between apps. Since I already use Waybar, it felt like the natural place to make that available. There wasn't really something out there for that, and I had todos scattered amongst different local notes and Obsidian, so I built Tasuki to aggregate them together.
by jorvi | 2026-02-26 19:21:57+00:00
No, a high skill floor is the opposite. It means that anyone can pick up the thing and immediately do decently.

To put it simply, think assault rifle vs sniper rifle. Anyone can use the AR and spray and pray and do pretty okay. You can't do that with the sniper rifle. So the AR has a high skill floor (minimum effectiveness) whereas the sniper rifle has a low skill floor (low minimum effectiveness). But the AR has a low skill ceiling too a point where you can put in endless amounts of skill and see no improvement in effectiveness. The sniper being an infinite range OHKO can scale to the end given aim skill and map knowledge.

Another example would be Reinhardt in Overwatch. You can tell a noob to "look in that direction and deploy shield" and they will contribute to the team. You can't put a noob on Widowmaker and have them contribute (as) significantly.
by less_less | 2026-02-26 19:21:57+00:00
I picked Hunter's Point because I used to live near it. The problems from decommissioning radioactive ships are bad, but they're far from the only pollution that was there. Lots of VOCs, solvents, oils, radiation from other stuff (eg, glow-in-the-dark equipment made with radium), heavy metals, pesticides, PCBs, and what have you.

But sure, there are other shipyards they cleaned up in less than three decades.
by 05 | 2026-02-26 19:22:43+00:00
0%? Extremely unlikely. [0] Is your plan as an evil overlord to implement the stack ranking killing the evilest 10% generation after generation for the good of humanity?:)

Also hope you’re going global since other populations will quickly outcompete the docile sub-population if given chance.

[0] https://en.wikipedia.org/wiki/Genetics_of_aggression
by dilawargopang | 2026-02-26 19:23:04+00:00
Hey HN,

I built this after losing a hackathon where PHI leakage was the blocker. phi-redactor is a reverse proxy that sits between your app and OpenAI/Anthropic, automatically detecting and masking all 18 HIPAA Safe Harbor identifiers before they leave your network.

How it works:
- Request hits the proxy → Presidio + spaCy detect PHI (names, SSNs, MRNs, dates, etc.)
- PHI replaced with clinically coherent fakes (John Smith → Robert Chen, not [REDACTED])
- Sanitized request forwarded to the LLM
- Response comes back → synthetic tokens rehydrated to originals
- Your app sees the real data, the LLM never does

Technical details:
- 10 custom Presidio recognizers including FHIR/HL7v2 support
- Fernet-encrypted SQLite vault for mapping persistence
- SSE streaming with buffer-based rehydration
- Tamper-evident hash-chain audit trail
- 256 tests passing

Apache-2.0. Feedback welcome — especially from anyone doing healthcare AI in production.
by vanhoefm | 2026-02-26 19:23:20+00:00
I'm a co-author on the paper: I would personally indeed not use the phrase "we can break Wi-Fi encryption", because that might be misinterpreated that we can break any Wi-Fi network.

What we can do is that, when an adversary is connected to a co-located open network, or is a malicious insider, they can attack other clients. More technically, that we can bypass client isolation. We encountered one interesting case where the open Wi-Fi network of a university enabled us to intercept all traffic of co-located networks, including the private Enterprise SSID.

In this sense, the work doesn't break encryption. We bypass encryption.

If you don't rely on client/network isolation, you are safe. More importantly, if you have a router broadcasting a single SSID that only you use, we can't break it.
by kodama-lens | 2026-02-26 19:23:41+00:00
I switched our entire container build setup to buildkit. No kaniko, no buildah, no dind. The great part is that you can split buildkitd and the buildctl.

Everything runs in its own docker runner. New buildkitd service for every job. Caching only via buildkit native cache export. Output format oci image compressed with zstd.
Works pretty great so far, same or faster builds and we now create multi arch images. All on rootless runners by the way
by brailsafe | 2026-02-26 19:24:05+00:00
> And you're kind of confirming my original thesis, that its a class of drugs created by the ruling class for the working class to make the best workers for capital/ruling class, which it seems to have accomplished that in your case...

I don't take amphetamine specifically, methylphenidate, which seems to have no pronounced influence on the apparently correlation based study outcome. Taking these drugs however is not something I approach lightly, but it's also not something I do for anyone else. If anything, it helps me maintain my own adult life. The job is an incidental but important factor.
by lrasinen | 2026-02-26 19:24:14+00:00
I couldn't let this be, so I went through the commits and as far as I can tell, that's the case. The committer/author names and timestamps are consistent with using --author on a commit (... or in a few cases, --amend --author).

Except one: commit 3d1fdddf9 has Jia Tan as both author and committer but the author timestamp is in +0300 while the commit timestamp is +0800.
by teaearlgraycold | 2026-02-26 19:24:38+00:00
To be clear I’m not sure what I’m doing is vibe coding because I write some of the code and read/understand what the LLM writes.

I think I’m learning less (about the code) but making more. Maybe that’s okay? There are other things to learn about. My code has users, it processes money. I user test, I iterate, I see what works and what they need.
by nineteen999 | 2026-02-26 19:24:53+00:00
We didn't even have to offshore for lots of bad code to be written.

Looks at the scores of Ycombinator startups that wrote a shitload of awful code and failed. Good ideas, pretty websites, but not a lot of substance under the hood. The VC gathering aspect and online kudos was way more important to them than actually producing good code and a reliable product that would stand the test of time.

Pretty much the most detestable section of the HN community. IMNHSO. I notice they're much quieter than usual since the whole vibe coding thing kicked off.
by gigel82 | 2026-02-26 19:24:54+00:00
Reposting a comment I made on an earlier thread on this.

We need to be super careful with how legislation around this is passed and implemented. As it currently stands, I can totally see this as a backdoor to surveillance and government overreach.

If social media platforms are required by law to categorize content as AI generated, this means they need to check with the public "AI generation" providers. And since there is no agreed upon (public) standard for imperceptible watermarks hashing that means the content (image, video, audio) in its entirety needs to be uploaded to the various providers to check if it's AI generated.

Yes, it sounds crazy, but that's the plan; imagine every image you post on Facebook/X/Reddit/Whatsapp/whatever gets uploaded to Google / Microsoft / OpenAI / UnnamedGovernmentEntity / etc. to "check if it's AI". That's what the current law in Korea and the upcoming laws in California and EU (for August 2026) require :(
by mrguyorama | 2026-02-26 19:25:25+00:00
The democrat party wanted to push socialized healthcare 70 years ago and didn't succeed. They tried again during Obama's term but couldn't get the votes because at least one "Democrat" politician openly refused to vote for a socialized health care plan.

What do you want? If there were more Democrats in office in 2010 we would have already had socialized healthcare.

People keep getting pissed that the party without power can't do things. If you want a politician to change something, you have to vote for them first

Even the people who vote for Trump understand that, but so many people who think they are smart can't understand that about voting for democrats. They continue to get pissed that the democrats secure the presidency and nothing else and can get nothing done as is intentionally the design of the american system

FDR's New Deal was possible because the Democrat party held about 80% control of both houses of congress and the presidency. Their threat to pack the supreme court to bypass them worked because it was trivially doable for them. You want a New New Deal? You have to vote for more Democrats.
by LeoJB | 2026-02-26 19:25:59+00:00
Whenever I find myself on Twitter there’s always a handful of new people hitting insane MRR figures in their first month of launching an app.

A short confident line like “BRB Printing Money” or “Just hit 300K MRR les’go! ” backed up by a convincing chart. Either a screenshot or short recording.

Example:
https://x.com/leojbarnett/status/2027033450205577577?s=20

The tweets bring the clicks, the likes, the shares, the curiosity from other young guns desperately wanting the same.

“How bro?” “What’s the app?!” “Killing it!”.

So how hard could it be to mock up a convincing interactive chart using lovable I wondered?

3 screenshots, 2 prompts. Done. In 5 mins.

Introducing MRR NOW

Play with it here:
https://mrrnow.lovable.app/

Just set your dates and target MRR.

I want it to to be true when I see these. I love people winning. Especially youngsters like the App Mafia gang who you can quite easily tell work HARD and have their heads firmly screwed on.

But there’s a wave that’s passed and there’s only so many habit trackers that can be making these figures now?

The main point of this is to raise awareness towards how easy it is to make something convincing in the age of AI. We all know not to believe anything we see online. Add charts to the list!

All we can do is keep it real, get outside and AB test our ways to victory and not overnight success. Have a crack a going viral though for sure.

It’s a marathon! Enjoy the journey.

Need help creating something?

Connect with me here @ leojbarnett

Disclaimer:

MRRNOW is a self-created fictional mock-up for illustrative purposes only. It is not affiliated with, endorsed by, or connected to any founder, company, or platform. All figures, data, charts, and performance metrics shown are fictional and not real. This demo is intended solely to illustrate how convincing-looking dashboards can be created and should not be relied upon as factual, commercial, or representative of any real results.
by dirk94018 | 2026-02-26 19:26:13+00:00
toast is sed with a brain. I got tired of cut and paste and made my own tool. Then I decided to let the AI drive and tried toast | bash, pretty good but AIs are terrible at escaping, got annoyed and wrote a shell for AI to use called jam. Wanted a bot to answer my texts, so I wrote iMessage, a cli tool. Now you can do iMessage -c iMessage | toast | iMessage and it answers texts. There is more and now its a startup, Unix re-imagined for AI: https:/linuxtoaster.com
by TrueGeek | 2026-02-26 19:26:41+00:00
> As PRs, would you still then need to remain self-employed (forever)?

Nope, once we get PR we have the same rights as citizens except: we can't vote in national elections, and we can't leave the country for too long without losing the residency permit.

> I've bookmarked your website for further inspiration

Haha, last blog post was, what, 2 years ago!
by 1vuio0pswjnm7 | 2026-02-26 19:26:50+00:00
Works where archive.ph is blocked:

https://www.msn.com/en-us/news/world/americans-are-leaving-t...

No Javascript, text-only, HTTPS opitional:

https://assets.msn.com/content/view/v2/Detail/en-in/AA1X5a4f...
by llbbdd | 2026-02-26 19:27:23+00:00
I was looking for a good TUI tool for diffs recently, but I'm not sure yet if what I want exists already (and I don't think this tool does it (yet?)). I've been moving my workflow out of VSCode as I'm using TUI-driven coding agents more often lately but one thing I miss from my VSCode/GitHub workflow is the ability to provide a comment on lines or ranges in a diff to provide targeted feedback to the agent. Most diff tools seem to be (rightfully) focused on cleanly visualizing changes and not necessarily iterating on the change.

I admit I haven't looked super hard yet, I settled on configuring git to use delta [0] for now and I'm happy with it, but I'm curious if anyone has a workflow for reviewing/iterating on diffs in the terminal that they'd be willing to share. Also open to being told that I'm lightyears behind and that there's a better mental model for this.

[0] https://github.com/dandavison/delta/
by bordra | 2026-02-26 19:27:29+00:00
Do you know what data your photos reveal about you? Every image you share contains hidden metadata exposing your exact location, daily schedule, and technical details that can fingerprint your device. Whether you’re a photographer or privacy-conscious, you need to be aware of this risk. DropTidy lets you delete this data in your browser. Total Privacy: Everything happens inside your browser. Deep Analysis: Find hidden privacy risks. Lossless: Keeps original quality and resolution.
by lunar_rover | 2026-02-26 19:27:33+00:00
It's quality issue from my experience. Nobody ever bothered with polishing the defaults and the "option bombardment" is really bad incoherent design instead of having too many things.

I remember spending hours customising the KDE 5 task bar clock, trying to correct the padding. Eventually I gave up customising it and switched to GNOME.

KDE app customisation is also a mess compared to something like foobar2000.
by rglover | 2026-02-26 19:27:45+00:00
The article addresses this by making the point that prototypes != production. Arduino is great for prototyping (authors opinion; I have limited experience) but not for production-level manufacturing.

LLMs are effectively (from this article's pov) the "Arduino of coding" but due to their nature, are being misunderstood/misrepresented as production-grade code printers when really they're just glorified MVP factories.

They don't have to be used this way (I use LLMs daily to generate a ton of code, but I do it as a guided, not autonomous process which yields wildly different results than a "vibed" approach), but they are because that's the extent of most people's ability (or desire) to understand them/their role/their future beyond the consensus and hype.
by PaulHoule | 2026-02-26 19:28:43+00:00
As a passenger I don't know if I believe this. [1]

The basic bane of the passenger's life is that the bus company just does what it wants and is not responsive to your needs.

Let's imagine a world where bus service is competitive and wildly profitable -- there is going to be a LOT more bus service, bus companies are going to be tripping over each other to add new routes, run more busses because improved frequency and better service means: more money to afford running more busses.

If we just say "there is a pool of $X million a year" then buses are always going to be scarce and there is no incentive for the bus operator to improve in any way whatsoever because they can run the worst service possible and get $X million or run the best service possible and get $X million.

I was first exposed to the "free buses" idea in the 1990s and it has some logic because collecting fares does slow buses down, but transit geeks I respect now are skeptical because the real problem with buses is that there aren't enough routes and they don't run frequently enough: it is not like there is this vast population of people who can't afford to ride the bus, rather there are many people for whom the bus is dead to them because the bus doesn't come where they are or go where they want to go when they want to.

[1] I'm in the unusual situation that I ride the bus almost every day from a rural location and ride for free because I work at a university with a nearly impossible parking situation. It works for me because I work 9-5 and I'm a software developer so if i am 30 minutes late one morning it is not like there are customers who need me right then. The bus service has been close to perfect for the last two months but we've had plenty of times when 30 minutes late in the morning or evening has been absolutely routine.
by mst98 | 2026-02-26 19:28:45+00:00
Yeah, the idea is that you set up a repo for a project (the hive), and then once you have the hive, you can set up multiple combs (git clones, not workspaces) and work in parallel. Suppose you have like 3-5 issues / tickets you're working on - the idea is that you can do this in parallel, in isolated dirs, and jump between them in one place. I used to have to do this in tabs in zellij / sessions in tmux and remember which sessions is which issue / ticket. Also having to manually git clone everytime was annoying. So this is an abstraction to simplify this. Does that make sense?