How ClickHouse Uses JSON

The ClickHouse Terraform provider now manages ClickStack dashboards, alerts, sources, and webhooks, putting observability config in version control.

ClickHouse Grafana plugin 4.20 brings compact query mode, click-to-filter log investigation, guided variable and annotation editors, and OpenTelemetry dashboards

This release brings speedups for GROUP BY ... ORDER BY ... LIMIT, three JOIN improvements, four vector search improvements, position-aware phrase search, EXPLAIN ANALYZE, unified URL access, and more!

Treating a Gaggia espresso machine like a distributed system: instrumenting an ESP32 with OpenTelemetry, streaming shots and whole-house sensors into ClickHouse Cloud, and putting ClickStack (plus an LLM agent) on top to turn every pull into a queryable,

How a coding agent used clickhousectl to stand up a distributed ClickStack across the US, Europe, and Japan, with regional ingestion and one global view.

Recent improvements to the OpenTelemetry Collector's Datadog receiver let teams reroute telemetry from their existing Datadog agents and SDKs to ClickStack. or any OTel destination making migrations and evaluations simpler than ever.

Using ClickHouse as a webhook endpoint with HMAC verification

This post walks through the common pitfalls we see when AI generates ClickHouse schemas, drawn from real conversations with our Solutions Architecture team and patterns across dozens of customer engagements.

ClickHouse 26.2 is here! In this post, text-index and QBit data type become production-ready.

ClickHouse is fast by design, but raw database speed isn't enough. This post explores how ClickStack tightly integrates with ClickHouse to generate optimized queries — from progressive time window pagination and chunked charts to automatic use of materi

Learn how to send structured .NET logs directly to ClickHouse using Serilog — with full schema control, full-text search, and SQL queries over your log data.

High-performance full-text search, even on object storage. This deep dive from the ClickHouse engineers explains the new text index design and how it keeps queries fast at scale.

Ten best practices for getting the most out of ClickHouse, from primary key design and data types to materialized views, ReplacingMergeTree, and join optimization — illustrated with benchmarks on a 150M row dataset.

Discover how Postgres managed by ClickHouse compares to its peers in a reproducible, open benchmark.

ClickHouse 26.3 is here! In this release, async inserts are turned on by default, we've got more JOIN reordering, materialized CTES have arrived, and more!

ClickHouse now brings full-text search and large-scale analytics together in one engine, making it a powerful alternative to Elasticsearch for log analytics. This benchmark shows why.

ClickHouse 26.4 is here! In this release, more features become SQL compatible, COUNT DISTINCT gets faster, EXPLAIN gets even prettier, and more

A deep dive into how pg_clickhouse's Foreign Data Wrapper decides what SQL to push down to ClickHouse versus execute locally in Postgres .

In this blog, we explore why high cardinality behaves fundamentally differently in column-oriented databases like ClickHouse, and why the costs appear in very different places than in traditional series-based systems like Prometheus.

How we integrated the Rust Delta Kernel to replace our native Delta Lake implementation, reducing maintenance overhead while unlocking writes, schema evolution, time travel, and partition pruning.

Introducing CostBench, an open benchmark that turns cloud data warehouse runtime and billing models into comparable performance-per-dollar results.

ClickHouse 26.5 is here! In this release, we have a record number of performance optimizations, a new `filesystem` table function for querying your local file system with SQL, and more!

On June 15, 2016, ClickHouse went open source under the Apache 2.0 license. Ten years later, it's one of the most widely deployed analytical databases in the world.

Stream data from Pub/Sub in a few clicks for blazing-fast analytics over GCP infrastructure logs, application events, and operational signals. No routing through GCS or Dataflow required.

Silk is a new open-source C++ fiber runtime built for ClickHouse, combining a NUMA-aware work-stealing scheduler, io_uring I/O, and zero heap allocation in the steady state to deliver nanosecond-level fiber yields and dramatically lower tail latency for h

chDB embeds a full ClickHouse query engine inside an agent's own process, turning data access, memory, and federation into local function calls instead of network round trips, cutting the latency, retries, and token waste that come with remote queries.

ClickHouse now has an official ADBC driver, giving Ruby, R, C, and every other ADBC-aware tool zero-conversion, Arrow-native access to ClickHouse without a dedicated client for each language.

We've released @clickhouse/rowbinary a Node.js reader and writer for ClickHouse's RowBinary formats. You can import it and call its generic parser like any other library. But it also ships as an Agent Skill: point a coding agent at the bundled `SKILL.md`

The article discusses how PeerDB facilitates large-scale PostgreSQL migrations, specifically achieving a 1TB migration in just 2 hours.

ClickHouse 25.

The article discusses the development of chDB, a Python library that integrates ClickHouse with Pandas DataFrames for high-performance SQL querying.

The article reviews the significant developments and features introduced in ClickStack over its first seven months since launch, highlighting advancements such as JSON support, integration with Cli...

The article discusses key benchmarks conducted over the past year that reveal insights into performance optimization in ClickHouse.

The article discusses ClickHouse's journey of integrating Rust into its predominantly C++ codebase without undertaking a complete rewrite.

This article provides a detailed analysis of how the five major cloud data warehouses—Snowflake, Databricks, ClickHouse Cloud, Google BigQuery, and Amazon Redshift Serverless—calculate compute cost...

This article discusses the transition from OpenTelemetry (OTel) to Rotel, an open-source Rust project that enhances tracing capabilities at petabyte scale.

The article details the journey of upgrading the chDB kernel from ClickHouse v25. 5 to v25. 8. 2.

The article discusses the development of StockHouse, a real-time market analytics application that leverages ClickHouse, Massive, and Perspective to handle high-frequency financial data.

This article explores the process of tracing OpenAI agents using ClickStack, demonstrating how to build an OpenAI agent that interacts with ClickHouse and visualizes the decision-making process.

The article discusses the potential of lakehouses using open table formats like Apache Iceberg and Delta Lake for observability, highlighting their advantages in scalability, cost-effectiveness, an...

The article discusses the enhancements made to the JSON data type in ClickHouse v25. 8, which significantly improve performance and memory efficiency for analytical queries.

The article discusses the rising costs associated with observability in software engineering and proposes a shift towards open, cost-efficient architectures.

ClickHouse version 25. 8 introduces 45 new features, 47 performance optimizations, and 119 bug fixes, enhancing its capabilities as a high-performance analytical database.

This article discusses how to instrument a Next. js application using OpenTelemetry and ClickStack, focusing on the integration of observability and analytics through ClickHouse.

The article explores the potential need for Object-Relational Mappers (ORMs) in Online Analytical Processing (OLAP) environments, particularly focusing on ClickHouse.

This article discusses the significant performance improvements achieved in ClickHouse's SQL UPDATE operations, demonstrating how they can be up to 1,000× faster than traditional mutation methods t...

The article discusses the importance of LLM observability using ClickStack, OpenTelemetry, and MCP, highlighting how to instrument LibreChat for enhanced insights into AI-driven applications.

The article discusses the latest updates in ClickStack, an open-source observability stack built on ClickHouse, highlighting the introduction of native JSON support for improved query performance a...

ClickHouse version 25.

This article provides a detailed guide on building a real-time market data application using ClickHouse and Massive.