search

umami-software / umami

Umami is a simple, fast, privacy-focused alternative to Google Analytics.
https://umami.is
MIT License
22.23k stars 4.14k forks source link

[Feature Request] ClickHouse backend support #601

Closed marswong closed 2 years ago

marswong commented 3 years ago

Traditional RDBMS is really slow at large-scale OLAP, it's time to speed up OLAP with a better database and ClickHouse is a good choice today.

mikecao commented 3 years ago

We are limited to what is supported by Prisma. Adding any other database would take significant work.

Form1ca commented 3 years ago

We are limited to what is supported by Prisma. Adding any other database would take significant work.

i was thinking about using clickhouse. if you are interested i can add support clickhouse

Also have to use something for the cache - for example rabbitmq

Kdecherf commented 3 years ago

Should ClickHouse support be added to umami, please do not make it a requirement as I turned away Plausible because of that :pray:

Form1ca commented 3 years ago

Should ClickHouse support be added to umami, please do not make it a requirement as I turned away Plausible because of that 🙏

what problem you get in Plausible and clickhouse?

Kdecherf commented 3 years ago

@Form1ca I'm using umami for a small blog on a server with restrained resources. When I tested Plausible, ClickHouse consumed too much resources for my needs, backup was not fun at all and in overall it was overkill for my workload. I don't find this stack relevant for monosite/small sites.