Math Games in ClickHouse® — Solving Project Euler Problems
ClickHouse is an extremely versatile DBMS. When presenting it to newbies, I sometimes describe it as a combination of four “F”-s: Fast, Flexible, Fun and Free. We often benchmark ClickHouse in different scenarios to demonstrate how fast it is. Case…
New Tips and Tricks that Every ClickHouse® Developer Should Know
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,…
Deep Dive on ClickHouse®: Sharding and Replication Webinar
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.
Altinity Quick Start for ClickHouse®: Creating Your First Application
This talk explains what ClickHouse is and how to install it. We then work through the basics of inserting and selecting data, followed by tips on how to maximize the legendary performance of ClickHouse.
Size Matters: Best Practices for Trillion Row Datasets on ClickHouse®
This webinar walks you through best practices for designing a schema, loading data, and running queries on very large datasets.
All about JSON and ClickHouse®: Tips, tricks, and new features!
This webinar covers JSON features from A to Z starting with traditional ways to load and represent JSON data in ClickHouse.
Webinar: Tips and tricks every ClickHouse® user should know.
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…