Skip to content
Download full logoDownload logomark

ClickHouse engineering resources

  • OLTP vs OLAP

    OLTP handles transactional reads and writes in milliseconds; OLAP scans billions of rows for analytics in sub-second time. Architectures, decision rules, and where the line blurs.

    Last updated: May 27, 2026

  • What is a columnar database?

    A columnar database stores each column on disk separately to cut I/O and compress aggressively. Here is what that means in practice and when to use one.

    Last updated: May 25, 2026

  • Database compression: encodings, codecs and ratios

    Learn how databases compress data, the trade-offs between row and column storage, and why ClickHouse delivers industry-leading compression ratios.

    Last updated: May 6, 2026

  • 7 things to consider when choosing a cloud data warehouse

    This guide examines seven critical factors that actually matter when evaluating data warehouses for production use. We'll compare how ClickHouse, Snowflake, BigQuery, and Redshift handle each consideration, drawing from documented capabilities, architectural designs, and real-world customer experiences.

    Last updated: Nov 18, 2025

  • Open table formats

    In this guide, we'll explore the Iceberg, Delta Lake, and Hudi open table formats.

    Last updated: May 9, 2025

  • Data catalog

    In this guide, we'll explore data catalogs for open table formats like Iceberg, Delta Lake, and Hudi, explaining how these metadata systems make modern data lakes more powerful and accessible.

    Last updated: May 9, 2025

  • Apache Iceberg

    Apache Iceberg transforms data lakes into robust lakehouse architectures with its high-performance table format. This article explores Iceberg's origins, key features like ACID transactions and schema evolution, and demonstrates how to query Iceberg tables in ClickHouse using both direct and catalog-based approaches.

    Last updated: May 21, 2025

  • Top 5 cloud data warehouses in 2026: Architecture, cost, and open-source

    Compare the top cloud data warehouses of 2025: Snowflake, BigQuery, Redshift, Databricks, and ClickHouse. Analyze cost efficiency, real-time performance, and open-source architecture.

    Last updated: Apr 13, 2026

  • What is a data lakehouse?

    The data lakehouse combines the best of data warehouses and data lakes into a unified architecture. We'll explore its key components, advantages, and how ClickHouse fits into this modern analytics platform.

    Last updated: Apr 17, 2026

  • What is Real-Time Analytics? A Complete Guide (2026)

    Discover what real-time analytics is, its key benefits, and its use cases, such as fraud detection. Learn how it differs from batch and what to look for in a database.

    Last updated: Apr 14, 2026

  • Best real-time analytics database for star schema and fast joins (2026 guide)

    Compare real-time analytics databases for star schema and fast cross-table joins. Learn what to test in 2026 and choose the right engine for your workload.

    Last updated: Apr 8, 2026

  • Managed Postgres for AI and Real-Time Apps

    Learn how managed Postgres on NVMe with native ClickHouse CDC and pg_clickhouse eliminates the ETL tax and scales from OLTP to real-time analytics and AI apps

    Last updated: Apr 7, 2026

  • The ultimate guide to Open Source Observability in 2026: From silos to stacks

    Explore the top open source observability stacks for 2025. Compare ELK, LGTM, and unified observability solutions like ClickStack for cost, scale, and high-cardinality data.

    Last updated: Nov 10, 2025

  • A practical guide to observability TCO and cost reduction

    Tired of exploding observability bills? Learn how to calculate your true TCO and see how to cut architecture costs by 70-90% vs. ingest-based pricing.

    Last updated: Nov 26, 2025

  • How to engineer cost-efficient open source observability with ClickHouse (ClickStack) - 2026 technical playbook

    A technical guide for engineers to build a cost-efficient observability stack. Learn how to use ZSTD codecs, Materialized Views, and Tiered Storage with ClickHouse to reduce observability data footprint by 10x.

    Last updated: Jan 7, 2026

<-Prev
1
…
8
9
10
…
12
Next ->