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.

(excellent #observability talk at FOSDEM using #clickhouse for observability - basically pretty much what I'm doing atm :))

looking forward to tomorrow's #clickhouse for #observability talk because that's precisely what I'm having and doing https://fosdem.org/2025/schedule/event/fosdem-2025-5960-o11y-in-one-exploring-a-unified-telemetry-database/

interestingly #bluesky seems to have an #sqlite db per user as mentioned in this article about how they use #clickhouse https://clickhouse.com/blog/building-a-medallion-architecture-for-bluesky-json-data-with-clickhouse

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.

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

fourth #clickhouse cluster in the making it's called sadhouse because it's for broken stuff (which is actually not easy to process) and hooked the fifth team on it to give it a serious try themselves.

All benchmarks are liars.

Also, here’s a set of db benchmarks from #clickhouse:

https://benchmark.clickhouse.com/

Various DBs including:
- #mysql
- #postgres
- #sqlite
- #timescaledb
- #alloydb
- #mariadb

This is the result of disabling and deleting Clickhouse logs and traces. 12GB worth of stuff not related to the real data.

spending the week counting stuff to once and for all answer ALL of the "how many" and "how often" and "how big" and the group noun for #clickhouse is of course block and not cluster

(I'm taking bets that I can build this based on SQLite if I set my mind to it I learned a lot of creative database stunts at #postgres meetups and now from #clickhouse and I'm telling you folks a database is a framework to be used to build platforms not to just passively sit there in a corner hidden behind a cache databases aren't some mimimi :)

200 mio rows in my toy #clickhouse feeding on my prod #kafka for 8 months now without fail

b. pointed me to crossplane let's see if I can build a local #crossplane thing to deploy a #clickhouse into my local infra :)

#clickhouse shit as usual pretty cool and gives me some more ideas :) #fosdem (clickhouse has really awesome short videos on cool stuff you can do plus very practical blog articles I'm inching through all of them and build it..)

The #clickhouse team is at #fosdem! Look for @tylerhannan in an auspiciously bright yellow vest or for completely undercover Alexey Milovidov plus more core DB developers. If you find them, you will get special swag - including these custom keychains (first come, first serve!)

I'm also going to do a lot more #prometheus and #victoria, A LOT more #clickhouse, a bunch of #kubernetes AND #nomad because I just have to have more container platforms. I want to trial #nats and #benthos as new platform glue and hopefully get to modernize #kafka to the raft-based new version which I call #kraftka and it's pronounced kraft-ka I insist and #elasticsearch / #opensearch needs some love too. I have #perses running and victoria logs, too #platforming #observability

so. now I need to fiddle with #clickhouse so that I can pass the #sqlite table engine this whole damn sqlite-ceph-vfs file uri thing and then I have a processing pipeline from kafka to clickhouse materializing shit into sqlite to ceph and have tiny sqlite databases to go safely stored in #ceph (or I use the S3 engine but I think that can't point to an sqlite file in S3) Why am I doing this? BECAUSE I CAN ITCH NEEDS SCRATCH :)

Reverse DNS lookups of the IPv4 space https://reversedns.space #clickhouse