Company
Date Published
Author
Alan Braithwaite
Word count
974
Language
English
Hacker News points
None

Summary

ClickHouse is a distributed database designed for OLAP applications that has gained the author's conviction as the de-facto standard due to its high write throughput, fast aggregations, and simplicity of operation. The database's "bottoms-up" approach allows it to take full advantage of modern hardware capabilities. It uses the Log Structured Merge Tree (LSM Tree), invented in 1991 by Patrick O'Neil, which is also used by prominent databases like Bigtable, HBase, LevelDB, Apache Cassandra, and InfluxDB. ClickHouse integrates many optimizations that make it efficient on hardware, including SIMD instructions and CPU-cache efficient data structures. The database is easy to learn and use, with a simple packaging that makes it familiar to people having experience with relational/SQL databases. The author's experience using ClickHouse has shown its power in aggregating HTTP analytics, building metrics and analytics for Segment's Protocols product, and providing instant value to companies at all maturity levels.