Hacker News Reader

__son Type Server Protocol

That describes how hands off MS was with Postgres committers ime a few years ago. Useful to house them to for helpful office hours too. We'll see how that holds up post HorizonDB

__son We should be more ambitious with the software we build

I feel like a cat stuck up in a tree

__son We should be more ambitious with the software we build

LLMs are great for being nerdsniped. I started work on walshadow (reading pg wal into clickhouse) to demonstrate the project's infeasibility, but pieces started coming together into something reasonable & order of magnitude faster

The project would've been impossible for me without LLMs. & even with them there's an argument that this project is pushing complexity limits too far. But at least with ETL there's a clear feedback loop to build on

__son Qwen3-Coder writes less secure code when told it's for a US persona

model produces lower quality code when told to break fast and move things

__son Nine-Inch Snails

> giant African land snails

Brings back memories of Africanized bees

__son Ask HN: Why do people say "I built it" when we should say "Claude built it"?

Is your manager doing code review?

__son ClickHouse C – Talk to ClickHouse using its native binary protocol

With pg_clickhouse this doubled throughput while reducing memory usage. The original motivation was to supplant clickhouse-cpp to remove C++ from codebase (c++ runtime doesn't play nice with postgres runtime)

Nice not needing text parsing for postgres/clickhouse value conversions

& you can use this format over http

__son QGIS bans AI assisted contributions

Sure, which is why in first comment they say

> I'd like to open another topic about the usage of LLM for review, auditing and security purposes, but I think this is a very separate thread, and we'll open discussions at the user conference before any formal discussions.

__son ClickHouse C – Talk to ClickHouse using its native binary protocol

nitpick: this library requires consumer give io callbacks (potentially through the included clickhouse-client.h header), or use the sans-io interface (which clickhouse-c-rs[1] uses to implement tokio layer), which makes it capable of talking over native tcp protocol, http, or stdin/stdout (clickhouse local). ClickHouse has both native protocol[2] & native format[3]

1: https://github.com/ClickHouse/clickhouse-c-rs

2: https://clickhouse.com/docs/resources/develop-contribute/nat...

3: https://clickhouse.com/docs/resources/develop-contribute/nat...

__son Trump administration is suspending Microsoft from a green card program

I worked at MS Vancouver office in 2019, majority was people with visa issues to US. Even I was Canadian from Ontario who ended up there because I couldn't get visa to move to SF

__son Trump administration is suspending Microsoft from a green card program

Brown nosing would be if Satya was awarding Trump the award

__son “Math 2.0” will need to value mathematical progress more holistically

tbf GM explaining their 2700 elo moves are only understandable when vague, as elo goes up explanation becomes closer to "in this specific position there's these dpecific lines", why should 3500 elo moves have simple reasoning?

Maybe if we start with giving simple AI generated analysis of those clumsy humans with their measly 2700 elo moves

__son RIP, vector database

I literally had opening slide about Worse is Better when adding mysql support to peerdb. Lots of things in mysql have v1 as stupidest thing that works, then v2 fixes issues

There's a bunch of internal types like decimal vs newdecimal, binlog started out statement based until they realized uuid generation is random so added data replication on top. CDC offset started as filepos before GTID was made so offset could survive failover

There were aspects of the design I appreciated (logical slots in postgres have a bunch of drawbacks avoided by just appending to 2nd serial log which has an expiry date instead of tracking clients' offsets), but developing against protocol you learn to not try build a consistent mental model

__son Upgrade your desktop: Ubuntu 26.04.1 LTS is now available

yy.mm

__son Platform-independent SIMD in Go

Writing to maps is common

__son Platform-independent SIMD in Go

I'm fine with Go, worked on peerdb & wal-g in Go. I enjoy programming in C too which lacks memory safety. I just don't claim otherwise

__son Platform-independent SIMD in Go

Java data race doesn't segfault

__son Platform-independent SIMD in Go

Yes, writing to maps isn't threadsafe, hence sync.Map. I learned this the hard way

__son Platform-independent SIMD in Go

go data races aren't memory safe

__son Meta takes down a critical video about meta AI Glasses after filming at Meta

https://www.etsy.com/ca/listing/4352861484/smart-glasses-led...

> Take control of your privacy with this easy-to-use LED and Camera Blocker

__son Montreal adopts bylaw banning insults against police, municipal employees

> Other municipalities in the province, including Quebec City, Laval, Longueuil and Sherbrooke, already have similar bylaws.

apparently it can be

__son WalShadow: Sub-second Postgres replication to ClickHouse from physical WAL

yes toast is a pita. we're currently working on 3 modes:

1. disabled

2. clickhouse, stores toast chunks on clickhouse then pulls them to resolve

3. shadow, stores toast in shadow catalog, obviously less latency than clickhouse but demands disk space

__son WalShadow: Sub-second Postgres replication to ClickHouse from physical WAL

we require wal_level=logical, would be nice to support looser in future

agreed that there's a huge complexity cost to going this route

__son Canada welcomes EU proposal to become 'associate member'

This was under Jean Chrétien who recently gave a speech: https://www.cpac.ca/headline-politics/episode/jean-chretien-...

He supported US in Afghanistan, but refused to support war in Iraq since he didn't consider there to be sufficient evidence of WMD

__son Ask HN: What are you working on? (September 2026)

This weekend I threw together a randomizer for Death Howl. Having done a few challenge runs I wanted more out of custom mode

https://github.com/serprex/RandomHowl

__son Blizzard Revives 'StarCraft' Franchise with Open-World Sci-Fi Shooter

Meanwhile Nintendo announced Ocarina of Time remake out November

__son IKEA made a mod for Skyrim [video]

see https://en.wikipedia.org/wiki/Dumb_Starbucks

__son Neki – Sharded Postgres

https://x.com/samlambert/status/2083235983336865916 very funny

__son Neki – Sharded Postgres

m8gd local nvme

__son Codex on GPT6 Astra Low launched a rocket into space in Factorio Space Age 2.1

There's vod: https://m.twitch.tv/videos/2867906622