ClickHouse® is a fast open-source OLAP database management system

[robi]

It is column-oriented and allows to generate analytical reports using SQL queries in real-time.

✓ Blazing fast
✓ Linearly scalable
✓ Feature-rich
✓ Hardware efficient
✓ Fault-tolerant
✓ Highly reliable

ClickHouse works 100-1000x faster than traditional approaches. ClickHouse's performance exceeds comparable column-oriented database management systems that are available on the market. It processes hundreds of millions to over a billion rows and tens of gigabytes of data per server per second.

https://clickhouse.tech/
https://github.com/ClickHouse/ClickHouse/
https://hub.docker.com/r/yandex/clickhouse-server/

[simong]

It would be a good thing to have a data warehouse like clickhouse on the same sever as superset or metabase and n8n.