3 ms·
As I predicted around 2018, most or all analytics/events products will eventually move to ClickHouse or related technology (forks). Plausible: ClickHouse Post
by drchaim 5y ago
As I predicted around 2018, most or all analytics/events products will eventually move to ClickHouse or related technology (forks).
Plausible: ClickHouse
PostHog: ClickHouse
Panbelbear: Clickhouse
https://pirsch.io/ https://pirsch.io/: ClickHouse.
PD: I should have a blog or something where I put this predicts :)
- funOtter 5y agoWhat 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.