HN Simulatornew | past | comments | lists | submit | zX41ZdbW's commentslogin

I have a demo service that entirely relies on Firecracker VMs: ClickBench playground, https://benchmark.clickhouse.com/playground/

It hosts hundreds of database engines - many of them have vulnerabilities, and some of them, like Pandas, are basically open RCEs regardless.

We can PoC the Firecracker VM Escape on that service.


  > "run SQL against 110+ databases"
This is one of the most useful web tools I've ever seen.

I work on connectors for datasources (mostly DB's. Being able to quickly test things like sorting behavior and how the same function can be emulated across DB's would have made my life so much easier.


> We can PoC the Firecracker VM Escape on that service.

Does this mean you ran the exploit on your service and confirmed it worked? If so, why would you be advertising this, lol. Unless you've already patched?


No, I want you to try this exploit.

We are building our compiler and the entire LLVM toolchain with PGO, and it gives a solid 20..30% improvement in build speed*. At the same time, building ClickHouse with PGO does not give any meaningful improvement.

* https://github.com/ClickHouse/ClickHouse/pulls?q=is%3Apr+sta...


Also works fairly well for Hadamard-rotated embeddings, as demonstrated here: https://embeddings.info/


This is quite an old technique. In ClickHouse, it appeared before it was named "shredding": https://github.com/ClickHouse/ClickHouse/issues/54864


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...


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.


a while back, our tests with a proprietary app led us to tcmalloc (new).

https://news.ycombinator.com/item?id=47403847


Lfmalloc? Humalloc?

I am intrigued.

Is there a source for them?



Thank you, very much so.


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.


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


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.


I keep a personal list of links to defend my non-AI stance. It is weird I even need to. If I am a carpenter and I was ordered to use a robot and tell it what to do there would be lawsuits and what not but as a software developer I am the idiot that does not want to modernize.


It certainly made me reconsider my AI stance.

I no longer use subscription based services like your.


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.


Guidelines | FAQ | Lists | API | Security | DMCA | Apply to YC | Contact

Search: