Hacker News: zX41ZdbW

New comment by zX41ZdbW in "A map of every lighthouse"

zX41ZdbW — Sun, 04 Oct 2026 17:57:11 +0000

I have a similar project (which I created in 2024): https://adsb.exposed/

Among various datasets, it has OSM data (all of it): https://adsb.exposed/?dataset=OSM&zoom=4&lat=52.3756&lng=2.5...

And here are lighthouses: https://adsb.exposed/?dataset=OSM&zoom=3&lat=40.0444&lng=9.9...

Approaching a 10 Second Linux Kernel Build

zX41ZdbW — Sun, 27 Sep 2026 01:45:57 +0000

Article URL: https://www.phoronix.com/review/near-10-sec-kernel-build

Comments URL: https://news.ycombinator.com/item?id=49862524

Points: 4

# Comments: 0

New comment by zX41ZdbW in "Comparison of Malloc() Algorithms"

zX41ZdbW — Sat, 19 Sep 2026 02:56:27 +0000

lfalloc: https://github.com/ClickHouse/ClickHouse/pull/62826 hualloc: https://github.com/ClickHouse/ClickHouse/pull/31376

New comment by zX41ZdbW in "Comparison of Malloc() Algorithms"

zX41ZdbW — Thu, 17 Sep 2026 12:23:30 +0000

ClickHouse has been tested with jemalloc, mimalloc, tcmalloc (both variants), rpmalloc, lfalloc, hualloc, and ended up using jemalloc after a few patches and bug fixes.

New comment by zX41ZdbW in "GitHub is having trouble counting things"

zX41ZdbW — Wed, 16 Sep 2026 19:30:24 +0000

Some of the oldest PRs could no longer be found.

For example, when I decided to continue my eight-year-old PR https://github.com/ClickHouse/ClickHouse/pull/104948, I couldn't see it - neither in search nor while navigating through pages.

Direct links still work.

New comment by zX41ZdbW in "Vectorized and performance-portable Quicksort (2022)"

zX41ZdbW — Wed, 16 Sep 2026 19:25:06 +0000

Strange to see it here, the article is quite old.

Since pdqsort, vqsort, and glide sort, the current state-of-the-art are driftsort and ipnsort.

I've integrated them into ClickHouse: https://github.com/ClickHouse/ClickHouse/pull/106650

New comment by zX41ZdbW in "Ask HN: Anyone want my realtime-snapshots dataset of Hacker News?"

zX41ZdbW — Wed, 09 Sep 2026 00:05:34 +0000

I'm interested. milovidov@clickhouse.com

Mostik.ai – latent communication between AI models

zX41ZdbW — Sun, 06 Sep 2026 21:00:57 +0000

Article URL: https://mostik.ai/read-more

Comments URL: https://news.ycombinator.com/item?id=49590898

Points: 2

# Comments: 1

New comment by zX41ZdbW in "Haiku R1/beta6 has been released"

zX41ZdbW — Sun, 30 Aug 2026 22:40:10 +0000

Maybe share my old article with Haiku developers: https://clickhouse.com/blog/agentic-coding

Could be a small chance, but it has already made many engineers reconsider their AI stance.

New comment by zX41ZdbW in "Visual Analysis of Binary Files"

zX41ZdbW — Fri, 28 Aug 2026 22:25:10 +0000

I've also built a visualizer into ClickHouse, so we can analyze its binary: https://play.clickhouse.com/binary?user=binary - which code takes more space, what dependencies are too big, or what template instantiations are bloated.

New comment by zX41ZdbW in "Visualizing Binary Files"

zX41ZdbW — Tue, 25 Aug 2026 18:32:25 +0000

ClickHouse can read and visualize its own binary: https://play.clickhouse.com/binary?user=binary

It is useful to understand which dependencies, libraries, and template instantiations contribute to the size.

JIT Compiling Code in 5μs

zX41ZdbW — Sun, 23 Aug 2026 06:04:51 +0000

Article URL: https://malisper.me/jit-compiling-code-in-5-us/

Comments URL: https://news.ycombinator.com/item?id=49406387

Points: 167

# Comments: 114

Solo – a .so loader for static Linux binaries

zX41ZdbW — Tue, 18 Aug 2026 23:51:49 +0000

Article URL: https://github.com/pg83/solo

Comments URL: https://news.ycombinator.com/item?id=49354613

Points: 204

# Comments: 235

New comment by zX41ZdbW in "RayforceDB – a pure C analytics database with a Lisp-like syntax"

zX41ZdbW — Fri, 14 Aug 2026 17:26:47 +0000

Let's add it to ClickBench: https://github.com/ClickHouse/ClickBench/

New comment by zX41ZdbW in "50k Boat Names"

zX41ZdbW — Mon, 10 Aug 2026 14:07:47 +0000

If you are interested in the AIS (ship telemetry) data, my team has created a visualization project: https://adsb.exposed/?dataset=Ships&zoom=5&lat=52.3890&lng=4...

New comment by zX41ZdbW in "When Compilers Disagree About UTF‑8"

zX41ZdbW — Sun, 09 Aug 2026 21:45:25 +0000

This is one of the optimizations from ClickHouse - detect ASCII and go a fast path: https://github.com/ClickHouse/ClickHouse/blob/6cde32de1a2463...

New comment by zX41ZdbW in "Show HN: ClickBench Playground – a playground for 110 database systems"

zX41ZdbW — Thu, 06 Aug 2026 00:55:55 +0000

All databases are hosted in VMs. Most of them only support amd64, so the host machine is also amd64 - this is the only limitation. It uses hardware virtualization, so nothing is emulated.

Generalized Consensus: An Alternate Approach to Distributed Durability (2025)

zX41ZdbW — Thu, 06 Aug 2026 00:36:24 +0000

Article URL: https://multigres.com/blog/generalized-consensus

Comments URL: https://news.ycombinator.com/item?id=49190927

Points: 3

# Comments: 0

New comment by zX41ZdbW in "Show HN: ClickBench Playground – a playground for 110 database systems"

zX41ZdbW — Wed, 05 Aug 2026 20:46:12 +0000

Thanks! There is a write-up: https://clickhouse.com/blog/clickbench-playground A lot of interesting things around hosting it.

New comment by zX41ZdbW in "Faster Than Ninja"

zX41ZdbW — Wed, 05 Aug 2026 19:02:37 +0000

Thank you for Ninja!

The speed (reading the build.ninja file) was never a concern for us. If I could share a wish-list, it will be:

- Fix the possibility of a segmentation fault when the build file is damaged;

- Use a better order of execution: https://github.com/ninja-build/ninja/issues/2157