--- title: "#clickhouse articles | Hashnode" description: "Explore 115 articles tagged #clickhouse on Hashnode. Tutorials, guides, and how-tos from the community." url: "https://hashnode.com/tag/clickhouse" --- Tag # #clickhouse 115 posts · 32 followers [Aritra Chakraborty](https://hashnode.com/@aidatalegends) · [4d ago](https://hashnode.com/posts/clickhouse-cloud-executable-udfs-ga-native-code-network-access-and-query-level-metrics/6af369295396ff02840171e3) ### [ClickHouse Cloud Executable UDFs GA: Native Code, Network Access, and Query-Level Metrics](https://aidatalegends.hashnode.dev/clickhouse-cloud-executable-udfs-ga-native-code-network-access-and-query-level-metrics?utm_source=hashnode&utm_medium=feed) LLM observability has a data problem hiding inside a measurement problem. Teams collect prompts, completions, model names, latency, and trace identifiers, but token-usage fields are not always present 4 min read · [aidatalegends.hashnode.dev](https://aidatalegends.hashnode.dev/clickhouse-cloud-executable-udfs-ga-native-code-network-access-and-query-level-metrics?utm_source=hashnode&utm_medium=feed) [Rita Lopes](https://hashnode.com/@rita7lopes) · [Oct 7](https://hashnode.com/posts/what-if-you-didn-t-have-to-migrate-to-gigapipe-to-find-out-if-it-s-better/6ac6ab9661410cff7c66a251) ### [What If You Didn't Have to Migrate to Gigapipe to Find Out If It's Better?](https://blog.gigapipe.com/what-if-you-didn-t-have-to-migrate-to-gigapipe-to-find-out-if-it-s-better?utm_source=hashnode&utm_medium=feed) Dual-shipping OpenTelemetry is the safest way to test a new backend before migrating. Here's what the overlap costs — and why it just got cheap. 9 min read · [blog.gigapipe.com](https://blog.gigapipe.com/what-if-you-didn-t-have-to-migrate-to-gigapipe-to-find-out-if-it-s-better?utm_source=hashnode&utm_medium=feed) [VisuaLeaf - MongoDB Data Workspace](https://hashnode.com/@visualeaf) · [Oct 5](https://hashnode.com/posts/clickhouse-database-management-tables-sql-and-schemas/6ac3fba5fecf75cf719e982c) ### [ClickHouse Database Management - Tables, SQL, and Schemas](https://visualeaf.hashnode.dev/clickhouse-database-management-tables-sql-and-schemas?utm_source=hashnode&utm_medium=feed) Browse ClickHouse tables, inspect DDL, run analytical SQL, map logical relationships, create charts, and export data to Excel with VisuaLeaf. 7 min read · [visualeaf.hashnode.dev](https://visualeaf.hashnode.dev/clickhouse-database-management-tables-sql-and-schemas?utm_source=hashnode&utm_medium=feed) [A Adarsh](https://hashnode.com/@adarshgowda) · [Sep 10](https://hashnode.com/posts/pre-aggregation-and-its-limit/6aa27d6bcfba7b2213b84b3a) ### [Pre-aggregation gets you 100× — until someone applies a filter](https://adarshgowda.hashnode.dev/pre-aggregation-and-its-limit?utm_source=hashnode&utm_medium=feed) A cube makes some questions instant and a larger set unanswerable. Design for the boundary. 6 min read · [adarshgowda.hashnode.dev](https://adarshgowda.hashnode.dev/pre-aggregation-and-its-limit?utm_source=hashnode&utm_medium=feed) [A Adarsh](https://hashnode.com/@adarshgowda) · [Aug 20](https://hashnode.com/posts/one-database-is-a-cost/6a86caf2d4e7d098199c4132) ### [One database is a cost, not a simplification](https://adarshgowda.hashnode.dev/one-database-is-a-cost?utm_source=hashnode&utm_medium=feed) Two workloads, opposite requirements. Four reasons a column store is wrong for a mutable catalog — and the join argument worth taking seriously. 7 min read · [adarshgowda.hashnode.dev](https://adarshgowda.hashnode.dev/one-database-is-a-cost?utm_source=hashnode&utm_medium=feed) [Manu Shukla](https://hashnode.com/@mr-manushukla) · [Jul 27](https://hashnode.com/posts/real-time-analytics-in-2026-lakehousert-vs-clickhouse-druid-and-pinot/6a67398c85aa4afd5bb97197) ### [Real-time analytics in 2026: Lakehouse//RT vs ClickHouse, Druid and Pinot](https://ecorpit.hashnode.dev/real-time-analytics-in-2026-lakehousert-vs-clickhouse-druid-and-pinot?utm_source=hashnode&utm_medium=feed) Real-time analytics in 2026: Lakehouse//RT vs ClickHouse, Druid and Pinot Summary. On 16 June 2026 Databricks launched Lakehouse//RT, a real-time query engine (code-named Reyden) that Databricks says 15 min read · [ecorpit.hashnode.dev](https://ecorpit.hashnode.dev/real-time-analytics-in-2026-lakehousert-vs-clickhouse-druid-and-pinot?utm_source=hashnode&utm_medium=feed) [OtezVikentiy](https://hashnode.com/@otezvikentiy) · [Jul 24](https://hashnode.com/posts/my-idle-clickhouse-was-merging-11-million-rows-every-30-seconds/6a63dd1eb5f902779f52ba83) ### [My idle ClickHouse was merging 11 million rows every 30 seconds](https://buildinggotcha.hashnode.dev/my-idle-clickhouse-was-merging-11-million-rows-every-30-seconds?utm_source=hashnode&utm_medium=feed) Why a stock ClickHouse filled 12 GB of 20 with 543 KB of my data, how merge amplification hit 1:678, and what tuning gave back: memory -66%. 7 min read · [buildinggotcha.hashnode.dev](https://buildinggotcha.hashnode.dev/my-idle-clickhouse-was-merging-11-million-rows-every-30-seconds?utm_source=hashnode&utm_medium=feed) [Jeremy Longshore](https://hashnode.com/@jeremylongshore) · [Jul 20](https://hashnode.com/posts/a-green-recovery-drill-can-still-be-lying/6a5df511f52ce55d35cb1fd9) ### [A Green Recovery Drill Can Still Be Lying](https://jeremylongshore.hashnode.dev/a-green-recovery-drill-can-still-be-lying?utm_source=hashnode&utm_medium=feed) We had a backup mechanism for a SigNoz staging stack. What we did not have was a proven restore. Those are different claims, and the gap between them is where outages become permanent. SigNoz is open- 10 min read · [jeremylongshore.hashnode.dev](https://jeremylongshore.hashnode.dev/a-green-recovery-drill-can-still-be-lying?utm_source=hashnode&utm_medium=feed) [Artem Senenko](https://hashnode.com/@slima4) · [Jun 30](https://hashnode.com/posts/building-an-uptime-monitor-in-rust-one-binary-two-databases-130k-checks-sec-per-core/6a43cd7b6f786e263714e201) ### [Building an uptime monitor in Rust: one binary, two databases, 130K checks/sec per core](https://uptimepage.hashnode.dev/building-an-uptime-monitor-in-rust-one-binary-two-databases-130k-checks-sec-per-core?utm_source=hashnode&utm_medium=feed) A build story. How Uptimepage runs HTTP/TCP/DNS/TLS checks from multiple regions on a single Rust binary backed by Postgres and ClickHouse. 9 min read · [uptimepage.hashnode.dev](https://uptimepage.hashnode.dev/building-an-uptime-monitor-in-rust-one-binary-two-databases-130k-checks-sec-per-core?utm_source=hashnode&utm_medium=feed) [Ashmit JaiSarita Gupta](https://hashnode.com/@ashmitjsg) · [Jun 28](https://hashnode.com/posts/building-log0-a-multi-tenant-incident-platform-on-kafka/6a41ab2090d12cc098cc8ecb) ### [Building log0: a multi-tenant incident platform on Kafka](https://engineeringwithashmit.hashnode.dev/building-log0-a-multi-tenant-incident-platform-on-kafka?utm_source=hashnode&utm_medium=feed) A working incident-management backend, built solo on one laptop, explained from the first measured number to the last honest caveat. This post is the map for the whole series. 10 min read · [engineeringwithashmit.hashnode.dev](https://engineeringwithashmit.hashnode.dev/building-log0-a-multi-tenant-incident-platform-on-kafka?utm_source=hashnode&utm_medium=feed)