Hacker News — 2026-07-03#

Top Story#

An American Privacy Emergency A guest post on Scott Aaronson’s blog by Cynthia Dwork sounding the alarm on a recent US Commerce Department directive (DAO 216-26) that effectively bans differential privacy and modern disclosure avoidance techniques for the Census,. By mandating a return to 1970s-era “coarsening” methods, the directive forces an impossible choice between useless statistical data and the deanonymization of citizens, sparking outrage across the CS theory community,,.

Front Page Highlights#

It Still Can’t Do My Job: Four Years of Moving Goalposts (2022–2026) A brutal, historically receipts-backed teardown of how developers have consistently shifted the goalposts on AI capabilities over the last four years. It cuts through the current wave of “AI is just autocomplete” cope, reminding us that yesterday’s “impossible” is today’s baseline,, and predicting the steady automation of the on-call pager and legacy monolith refactors,.

Hunting a 16-year-old SQLite WAL bug with TLA+ SQLite finally patched a 16-year-old race condition in its Write-Ahead Log that could lead to database corruption. Canonical’s dqlite team used TLA+ formal verification to model the exact sequence of states triggering the bug, proving that their own distributed implementation was immune thanks to stricter locking,. Peak HN catnip: formal methods successfully applied to the world’s most ubiquitous database.

PostgreSQL and the OOM Killer: Why We Use Strict Memory Overcommit An excellent deep dive into Linux memory management that started as a justification for running Postgres with strict overcommit, but evolved into a forensic hunt for a kernel bug. The Ubicloud team tracked down a single-character inversion in Linux 6.5 that caused a massive 648 GB leak of “phantom” committed memory,,.

60% Fable cost cut by converting code to images and having the model OCR it An absolutely wild, lossy hack to dodge LLM pricing structures. Because Claude’s vision tokens are billed by pixel dimensions rather than character count, this local proxy renders bulky system prompts and tool docs into PNGs for the model to OCR,. It slashes token bills by up to 70% for dense contexts, proving once again that developers will do anything to optimize a pricing discrepancy.

Commodore 64 Basic for PostgreSQL Someone actually embedded a statically recompiled 1982 Microsoft/Commodore 6502 ROM into Postgres as a procedural language extension. It executes functions by running a virtual C64 power cycle in memory in 15 microseconds, mapping OUT parameters by walking the old BASIC simple-variable table. It is entirely useless for production and utterly magnificent.

The Free Market Lie: Why Switzerland Has 25 Gbit Internet and America Doesn’t A sharp look at how treating telecom infrastructure as a regular consumer product leads to natural monopolies and rent-seeking in the US, while Germany wastes billions on redundant parallel trenches,,. Switzerland got it right by forcing a shared, neutral Layer-1 physical fiber network where multiple ISPs compete purely on service and price, delivering 25 Gbps residential connections,.

Half-Baked Product A painfully accurate startup fable about an oven company that prioritizes building a “Ramadan mode” and a “candle button” over fixing a core algorithm that burns 10% of its bread,,,. It perfectly captures how sales-driven feature creep and the desperate pursuit of enterprise pilots invariably result in unmaintainable technical debt and a demoralized engineering team,.

Show HN & Launches#

Show HN: Mcpsnoop – Wireshark for MCP provides a much-needed transparent proxy and TUI for debugging Model Context Protocol traffic between clients and servers. Wordgard is a new open-source, semantic in-browser rich-text editor from Marijn Haverbeke, the creator of ProseMirror. On the utterly insane end of the spectrum, crustc: entirety of rustc, translated to C demonstrates compiling the Rust compiler into a functional C codebase using a custom toolchain, explicitly targeting obscure hardware lacking LLVM support,,.

Discussion & Debate#

Odin, Wikipedia and Engagement Farming generated a massive, heated meta-discussion. The post exhaustively dissects the drama surrounding Wikipedia’s deletion of the Odin programming language page, calling out the creator and prominent figures like Casey Muratori for farming engagement and crying “ideological gatekeeping” instead of understanding basic Wikipedia notability guidelines,,. It’s a fascinating look at the clash between modern developer influencer culture and traditional, institution-style verification standards,.