Timescaledb is based on Postgres, always bet on Postgres...
Does Timescaledb do streaming? I was under the impression that it was more focused on OLAP for time data.
I'm pretty sure Timescaledb is a very good product, but columnar vs row-based reactive streaming systems tend to very different needs.
I guess there's different tradeoffs when you have a gazillion of these sensors or their output requires complicated parsing in the pipeline. But even then...
I haven't used it much but it does do "continuous aggregates".