Ask HN: What database should I use for analytics data?

Re:Ask HN: What database should I use for analytics data? by PeterZaitsev on Sunday November 03, 2019 @09:49AM (#21434148)

I would surely look at ClickHouse for such use case.

If you're rolling your own solution (rather than using DBaaS) ClickHouse is unparalleled when it comes to scaling and efficiency. Its SQL is somewhat restricted but it should be able to do what you're looking very well, especially it was born out of the needs of Yandex Metrica which is quite similar use case of yours.

If you're using Kubernetes there is great Operator available from Altinity to run Clickhouse on Kubernetes.

[ Parent | on HN ]

Re:Ask HN: What database should I use for analytics data? by hwwc on Sunday November 03, 2019 @10:10AM (#21434267)

I’ve also had a great experience with clickhouse. Very easy to set up and maintain. Perhaps a little rough around the edges compared to Postgres, but I would look to clickhouse first for analytics.

[ Parent | on HN ]