after this project I can say:
the strimzi #kafka operator is real nice. feels kubernetesy, smooth features, good documentation, example work.
the #opensearch operator shows grudging admittance that kubernetes exists. ;)
#clickhouse is a great tool. highly recommended.
open telemetry collectors are partially not mature enough. needs work still.
Moose – OSS framework to build analytical back ends with ClickHouse
ClickHouse gets lazier (and faster): Introducing lazy materialization
https://clickhouse.com/blog/clickhouse-gets-lazier-and-faster-introducing-lazy-materialization
Погружение в ClickHouse: делаем первые и успешные шаги
Привет! Меня зовут Андрей Дорожкин, и я руковожу командой администрации баз данных в Hybrid. В этом материале я поделюсь опытом работы с ClickHouse — колоночной БД, разработанной специально для аналитических запросов, которая позволяет получать результаты в разы быстрее традиционных решений. Также я подсвечу, как устроен этот продукт, чем он отличается от реляционных баз данных, и в каких сценариях его использование может дать бизнесу реальное преимущество. Пара слов о компании Hybrid. Мы — независимая AdTech-экосистема с собственным стеком технологий и решений для любых рекламных целей. Развиваем собственные технологии благодаря in-house отделу разработки, который каждый день работает над их улучшением. ClickHouse — инструмент, который мы выбираем для хранения данных за высокую скорость обработки запросов, эффективное сжатие данных и масштабируемость.
oh man there's a TUI for #clickHouse called #chdig and i really wish i knew about this a couple of years ago when i was working with a couple of teams that used clickhouse a lot because i was really curious what it looked like in there. from the chdig README there's a chart of tools and layers of abstraction for clickhouse that make a tool like this (now in #macOS #homebrew `brew install chdig`) especially useful.
Sandbox DB: универсальная песочница для погружения в Big Data, аналитику и визуализацию
Запускайте PostgreSQL, ClickHouse, Airflow, Superset и другие инструменты одним кликом: учите, экспериментируйте, осваивайте новое!
Okay, there -- first pass done. https://github.com/scottlaird/nel-collector is a #NEL (Network Error Log) collector that can listen on HTTP for NEL messages from Chrome, etc and log them to a DB.
It should be at least somewhat DB-agnostic, although I've only tested it with #clickhouse so far.
It also includes otel tracing, which is uglier than I'd like in Go, but seems to be working. I still need to get trace propagation through it to the DB backend working, but I think that's a problem with the backend config, not my code. Probably.
I'm still using #vector for this at home right now; I'll probably cut over tomorrow.
@laird #clickhouse o11y is the hot thing right now. Have you checked out #hyperdx?
This morning's accomplishment: finally setting up an otel collector at home, pointing it at #clickhouse, getting #caddy tracing via otel, and throwing a #grafana dashboard on it.
I didn't expect the dashboard to be the hard part.
Join Alkin Tezuysal's session "Unified Observability: Leveraging ClickHouse as a Comprehensive Telemetry Database" at #FOSSASIASummit2025 to learn how #ClickHouse simplifies observability, giving engineers deep system insights while minimizing infrastructure complexity.
Click here https://youtu.be/sCRXGqOPtOU?si=lWcjSCpKkuD_gLHW to watch on the FOSSASIA YouTube channel.
Here's how to turn web access logs in #clickhouse into nicely formatted maps in #grafana, like the picture that I posted yesterday.
https://scottstuff.net/posts/2025/03/21/geocoding-ip-addresses-with-clickhouse/
The hard part with this was getting IPv4 and IPv6 handling without needing special cases for either. Now that that's done, it should just be cut-and-paste to use it yourself now.
I don’t usually share AI stuff, but this is way cool.
https://www.linkedin.com/pulse/bi-dead-change-my-mind-dmitry-pavlov-2otae/
AGX – Open-Source Data Exploration for ClickHouse (The New Standard?)
Telescope – an open-source web-based log viewer for logs stored in ClickHouse — https://github.com/iamtelescope/telescope
#HackerNews #Telescope #ClickHouse #OpenSource #LogViewer #WebApp
We've focused on improving local IO and jumped up the table on ClickBench - https://benchmark.clickhouse.com/ - almost 10x faster than our previous run.
We're on ClickBench https://benchmark.clickhouse.com/, check out how we compare and see how we improve over time.
Anyone heard of or worked with PRQL? https://prql-lang.org
It's "a modern language for transforming data", designed to be a "simple, powerful, pipelined" #SQL replacement. "Unlike SQL, it forms a logical pipeline of transformations, and supports abstractions such as variables and functions. It can be used with any database that uses SQL, since it compiles to SQL."
#Rust compiler, & there are integrations for #PostgreSQL, #ClickHouse, #VisualStudioCode etc.
Oh my god! https://hub.docker.com/_/clickhouse
It's alive, our #official #docker #image is alive.
$ docker pull clickhouse
Still something is neccesry to do from the #ClickHouse side, e.g. pushing historical versions.
But still, it's a huge milestone ^_^
Now is one of the most exciting moments in my #OSS commitment. I am getting #ClickHouse in shape to being accepted in official #docker library
https://github.com/docker-library/official-images/pull/15846
Oh wow, I hope to get it done as soon as possible 
Working with a lot of analytical data on ClickHouse?
I've found the perfect tool for you! 
**chdig**: Dig into @clickhousedb with a TUI interface.
Supports flamegraphs and clusters with a top-like interface.
Written in Rust & built with @ratatui_rs
GitHub: https://github.com/azat/chdig
