Skip to content

ClickHouse engineering resources


  • 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

  • Mastering Kubernetes observability: a guide to monitoring modern architectures

    Learn why traditional Kubernetes monitoring fails at scale and how to master observability with a modern cost-effective database-first approach.

    Aditya Somani • Last updated: Jan 21, 2026

  • What is observability in 2026? Why it's an analytics problem and why your database matters.

    Observability in 2026 is an analytics problem. Learn why the traditional "three pillars" model fails and how a unified ClickHouse database solves cost and latency issues.

    Aditya Somani • Last updated: Jan 7, 2026

  • 8 top New Relic alternatives to break the pricing trap (2026 guide)

    Escape New Relic's pricing trap and vendor lock-in. Our 2026 guide compares the top 8 observability alternatives—including Datadog, Grafana, and ClickHouse—for pricing, data ownership, and SQL support.

    Aditya Somani • Last updated: Dec 15, 2025