First of all, this post is not a recommendation but more like a what if story. What if we use ClickHouse (which is a columnar analytical database) as our main datastore? Well, typically, an analytical database is not a replacement for a transactional or key/value datastore. However, ClickHouse is super efficient for timeseries and provides [&]

https://www.percona.com/blog/2019/01/14/should-you-use-clickhouse-as-a-main-operational-database/