How ClickHouse Uses Apache

This article benchmarks five major cloud data warehouses—Snowflake, Databricks, ClickHouse Cloud, BigQuery, and Redshift—across various scales of data to compare their cost-performance.

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

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.

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 new capabilities of ClickHouse Cloud to query Iceberg and Delta Lake tables through the DataLakeCatalog engine.

ClickHouse Release 25. 9 introduces significant enhancements, including 25 new features, 22 performance optimizations, and 83 bug fixes.

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.

This article discusses the implementation of Change Data Capture (CDC) from Delta Lake to ClickHouse, detailing the architecture, components, and a reference implementation in Python.

ClickHouse version 25.

The article discusses how ClickHouse efficiently queries Parquet files, a key storage format for Lakehouse architectures, without requiring data ingestion.

The article discusses a data visualization hackathon using ClickHouse to visualize Foursquare places, showcasing the dataset's structure, loading process, and visualization capabilities.

ClickHouse version 25. 4 introduces 25 new features, 23 performance optimizations, and 58 bug fixes, enhancing query performance and community contributions.

The article discusses the integration of Rust into ClickHouse, emphasizing the strategic decision to enhance the system without rewriting it entirely in Rust.

ClickHouse version 25.

ClickHouse version 24. 12 introduces 16 new features, 16 performance optimizations, and 36 bug fixes, enhancing usability and performance for users.

The article announces the new ClickHouse SQL Playground, designed to simplify querying large datasets with over 35 datasets and 220 example queries.

This article explores the integration of the Perspective library with ClickHouse to create real-time visualizations of streaming Forex data.

This article discusses the integration of ClickHouse, a high-performance columnar database, with Estuary Flow, a data integration platform, to enable real-time analytics on Salesforce data.

This article discusses how to quickly integrate analytics into applications using ClickHouse Cloud Query Endpoints, highlighting the benefits of API endpoints for simplifying SQL interactions.

This article provides an update on the evolution of ClickHouse's internal data warehouse (DWH) over the past year, highlighting improvements in data processing capabilities and user access.

The article announces the public preview of the Fivetran destination for ClickHouse Cloud, enabling users to load data from over 500 sources seamlessly.

This article explores the use of Apache Iceberg and ClickHouse to analyze global internet speeds using the Ookla dataset.

ClickHouse version 23. 12 introduces significant enhancements, including 21 new features, 18 performance optimizations, and 37 bug fixes.

The article discusses Goldsky's architecture utilizing ClickHouse, Redpanda, and Apache Flink for efficient blockchain data analytics.

This article discusses the CGW Stack, which combines ClickHouse, Grafana, and WarpStream to provide a cost-effective and efficient logging solution at scale.

This article discusses strategies for making large data loads into ClickHouse resilient and efficient, particularly when migrating from other systems.

This article explores how to integrate ClickHouse with OpenAI models using User Defined Functions (UDFs) to enhance SQL workloads with AI capabilities.

This article discusses the integration of ClickHouse with Kafka Connect and Confluent Cloud to facilitate real-time event streaming, particularly for Ethereum Cryptocurrency events.

This article serves as an introductory guide to implementing Change Data Capture (CDC) between PostgreSQL and ClickHouse, utilizing native features and tools like Debezium and Kafka.

This article discusses how to integrate real-time analytics into a Supabase application using ClickHouse, highlighting the differences between OLTP and OLAP databases.

This article delves into the Apache Parquet format and its integration with ClickHouse, focusing on file reading and writing optimizations.

This article provides an in-depth exploration of Apache Parquet, a columnar storage format, and its integration with ClickHouse, a powerful analytical database.

ClickHouse Release 23. 2 introduces significant enhancements including 18 new features, 30 performance optimizations, and 43 bug fixes.

This article explores the integration of ClickHouse and BigQuery for real-time analytics, highlighting their complementary strengths.

The article introduces the ClickHouse Query Cache, a new feature designed to enhance performance by caching the results of expensive SELECT queries.

ClickHouse Release 23. 1 introduces significant enhancements including 17 new features, 17 performance optimizations, and 78 bug fixes.

This article provides a comprehensive introduction to the various data formats supported by ClickHouse, focusing on how to effectively import and export data using these formats.

This article announces the beta release of the open-source Kafka Connect Sink for ClickHouse, aimed at providing exactly-once delivery semantics for data ingestion from Kafka.

This article discusses building an observability solution using ClickHouse, focusing specifically on log data collection and querying.

The ClickHouse 22. 11 release introduces 15 new features, 5 performance optimizations, and 32 bug fixes, enhancing the capabilities of this open-source columnar database.

This article explores the use of Apache Superset for visualizing data stored in ClickHouse, highlighting its extensibility, security features, and various visualization capabilities.

The ClickHouse 22.

The article discusses the evolution of data structures in Yandex. Metrica, detailing the transition from MyISAM tables to LSM-trees and ultimately to the column-oriented database ClickHouse.