Hacker News: sdairs

New comment by sdairs in "Ten years of ClickHouse in open source"

sdairs — Fri, 19 Jun 2026 14:03:39 +0000

Yes https://clickhouse.com/blog/clickhouse-full-text-search-obje...

New comment by sdairs in "ClickHouse Agent Skills"

sdairs — Thu, 05 Feb 2026 10:45:42 +0000

It's using Vercel's skills CLI, so its not custom to these particular skills. You can just place the files yourself, too.

New comment by sdairs in "Ask HN: What are the best engineering blogs with real-world depth?"

sdairs — Tue, 23 Dec 2025 13:21:07 +0000

https://clickhouse.com/blog?category=engineering

ClickHouse Acquires LibreChat

sdairs — Sun, 09 Nov 2025 23:25:26 +0000

Article URL: https://clickhouse.com/blog/librechat-open-source-agentic-data-stack

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

Points: 2

# Comments: 0

New comment by sdairs in "AOL to be sold to Bending Spoons for $1.5B"

sdairs — Wed, 29 Oct 2025 19:33:58 +0000

Least offensive Bending Spoons acquisition to date. I don't really mind if they kill this one?

New comment by sdairs in "Uv is the best thing to happen to the Python ecosystem in a decade"

sdairs — Wed, 29 Oct 2025 19:28:48 +0000

Everything from the astral team has been superb, I don't want to use Python without ruff & uv. Yet to try "ty", anyone used it?

New comment by sdairs in "A sharded DuckDB on 63 nodes runs 1T row aggregation challenge in 5 sec"

sdairs — Fri, 24 Oct 2025 19:46:54 +0000

Thanks for clarifying; I'm not trying to take anything away from you, I work in the OLAP space too so it's always good to see people pushing it forwards. It would be interesting to see a comparison of totally cold Vs hot caches.

Are you looking at distributed queries directly over S3? We did this in ClickHouse and can do instant virtual sharding over large data sets S3. We call it parallel replicas https://clickhouse.com/blog/clickhouse-parallel-replicas

New comment by sdairs in "Disable AI in Firefox"

sdairs — Fri, 24 Oct 2025 18:59:07 +0000

Chrome does suck ass, hence why I use Firefox and said I don't want to use Chrome, lol. But I want Firefox to be a good browser in its own right, not just "not Chrome". Firefox is just about over the "acceptable" line for me, as a power user for 15+ years (and under that line for most normal users) so I continue to use it, but they're neglecting it in favor of these useless AI features.

New comment by sdairs in "A sharded DuckDB on 63 nodes runs 1T row aggregation challenge in 5 sec"

sdairs — Fri, 24 Oct 2025 18:49:06 +0000

ClickHouse is the market leader in real-time analytics so it's an interesting take that you don't think it qualifies.

New comment by sdairs in "Disable AI in Firefox"

sdairs — Fri, 24 Oct 2025 17:42:32 +0000

Yeah I'm not at all interested in Brave, that's a dumpster fire of it's own. And that still gives control to Google by owning the defacto implementation of browsing the internet. There needs to be an actual alternative to Chrome.

New comment by sdairs in "Disable AI in Firefox"

sdairs — Fri, 24 Oct 2025 17:25:14 +0000

I've used Firefox for 15 years and I really don't want to use Chrome. Can Mozilla just, like, make a good browser?

New comment by sdairs in "A sharded DuckDB on 63 nodes runs 1T row aggregation challenge in 5 sec"

sdairs — Fri, 24 Oct 2025 16:37:28 +0000

Pretty big caveat; 5 seconds AFTER all data has been loaded into memory - over 2 minutes if you also factor reading the files from S3 and loading memory. So to get this performance you will need to run hot: 4000 CPUs and and 30TB of memory going 24/7.

New comment by sdairs in "Libghostty is coming"

sdairs — Tue, 23 Sep 2025 19:27:09 +0000

Yeah ClickHouse is written in C++, though rust is also possible https://clickhouse.com/blog/rust - would be cool to see zig!

New comment by sdairs in "OpenTelemetry collector: What it is, when you need it, and when you don't"

sdairs — Tue, 23 Sep 2025 11:09:29 +0000

Yeah metrics, logs, traces and can do session replay

New comment by sdairs in "OpenTelemetry collector: What it is, when you need it, and when you don't"

sdairs — Fri, 19 Sep 2025 12:51:46 +0000

ClickHouse doesn't use ZooKeeper anymore, and if you're just using a single server you don't need to worry about coordination :)

ClickStack/HyperDX is a polished OOTB stack that has an all in one image you can deploy to get started, so you don't need to worry about the ClickHouse side until you need to really scale (which is where ClickHouse really shines).

New comment by sdairs in "OpenTelemetry collector: What it is, when you need it, and when you don't"

sdairs — Thu, 18 Sep 2025 21:32:59 +0000

Sounds like you should take a look at ClickStack (HyperDX) to me

New comment by sdairs in "Optimizing ClickHouse for Intel's ultra-high core count processors"

sdairs — Thu, 18 Sep 2025 09:45:03 +0000

Yeah "Optimizing ClickHouse for Intel's ultra-high core count processors" is the original, unchanged article title, it's just been submitted slightly differently on HN (surprised mods haven't changed it here actually)

New comment by sdairs in "Optimizing ClickHouse for Intel's ultra-high core count processors"

sdairs — Wed, 17 Sep 2025 21:13:04 +0000

We do! (and we're hiring!)

New comment by sdairs in "Optimizing ClickHouse for Intel's ultra-high core count processors"

sdairs — Wed, 17 Sep 2025 20:56:53 +0000

how long until I have 288 cores under my desk I wonder?

New comment by sdairs in "Optimizing ClickHouse for Intel's ultra-high core count processors"

sdairs — Wed, 17 Sep 2025 20:43:03 +0000

ClickHouse works in-process and on the CLI just like DuckDB, but also scales to hundreds of nodes - so it's really not limited to just large scale. Handling those smaller cases with a great experience is still a big focus for us