Hacker News Reader

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/: ClickHouse.

PD: I should have a blog or something where I put this predicts :)

View on HN

What is ClickHouse and why do all projects move to it?

https://clickhouse.com/

ClickHouse 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.

ClickHouse 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.

Reply on news.ycombinator.com