New Tips and Tricks that Every ClickHouse Developer Should Know

New Tips and Tricks that Every ClickHouse Developer Should Know

Cristina Munteanu

Building analytic applications on ClickHouse? Great choice!
In this talk, we’ll show 7 tricks to develop analytic apps that are fast, cost-efficient, and easy to maintain. They include loading data from S3, using aggregation instead of joins, applying materialized views, using compression effectively, and many others. As you learn them you’ll also gain insight into how column storage, parallel processing, and distributed algorithms make ClickHouse the fastest analytic database on the planet.
Join us to unleash the power of real-time data today!

Deep Dive on ClickHouse: Sharding and Replication Webinar

Deep Dive on ClickHouse: Sharding and Replication Webinar

Ryhan Sunny

This talk walks you through sharding and replication, showing how Altinity experts enable clusters that deliver fast queries over petabytes of data. Starting with basic definitions of each, then moving to practical issues.

Webinar Slides. Tips and tricks every ClickHouse user should know

Robert Hodges

By Robert Hodges and Altinity Engineering Team
Slides for the Webinar, presented on Dec 3, 2019 
Webinar recording is available here

New users of ClickHouse love the speed but may run into a few surprises when designing applications. Column storage turns classic SQL design precepts on their heads. This talk shares our favorite tricks for building great applications. We’ll talk about fact tables and dimensions, materialized views, codecs, arrays, and skip indexes, to name a few of our favorites. We’ll show examples of each and also reserve time to handle questions. Join us to take your next step to ClickHouse guruhood!

Webinar: Tips and tricks every ClickHouse user should know.

Webinar: Tips and tricks every ClickHouse user should know.

Robert Hodges

New users of ClickHouse love the speed but may run into a few surprises when designing applications. Column storage turns classic SQL design precepts on their heads. This talk shares our favorite tricks for building great applications. We’ll talk about fact tables and dimensions, materialized views, codecs, arrays, and skip indexes, to name a few of our favorites. We’ll show examples of each and also reserve time to handle questions. Join us to take your next step to ClickHouse guruhood!