[jsumrall]

This and Materialize seemed like great tools. I met some of the team of Rising Wave at the Kafka conference last year in London and was impressed by their work. It may be great if you need such a tool.

In the end, I went with ClickHouse and it's materialized views feature. It might not be quite as powerful as what these other tools are doing, but it works for us, and it's really easy to set up. Before we were using Timescale's continuous aggregates, which had good performance, but require some domain knowledge to setup. ClickHouse materialized views are great because you don't need to be an expert to use them. And even so, performance is still very good.

We wrote about it briefly here: https://blog.picnic.nl/building-a-real-time-analytics-platfo...

[oulipo]

My use-case is IoT devices sending data, and I'd want to keep the eg last 6 months of data for review, and some agregates, and archive + delete older data

I was going to go with Timescaledb for "simplicity" (eg having a single database)

would Postgres+Clickhouse be indicated for this?