4 ms·
What is ClickHouse and why do all projects move to it?
by funOtter 5y ago
What is ClickHouse and why do all projects move to it?
- hffftz 5y agohttps://clickhouse.com/ https://clickhouse.com/
- hodgesrm 5y agoClickHouse is an extremely fast SQL data warehouse that supports vectorized query execution, column storage, and efficient compression. It's also Apache 2.0 licensed and sets up on a dev laptop in about 60 seconds. The SQL is somewhat ideosyncratic (in a good way, I believe). It takes some experience to use it to its full capabilities. Not all projects move there but if you want fast analytic queries on a few billion rows up to a few petabytes, it's really hard to beat. Disclaimer: I work for Altinity, which supports ClickHouse.
- mekster 5y agoClickHouse is not good for updates and deletion, so if you want general storage of data, stick to RDBMS. Analytics are typically append only, so ClickHouse works order of magnitude faster than RDBMS.