ClickHouse as history storage

https://clickhouse.tech/docs/en/

https://medium.com/datatau/how-to-connect-to-clickhouse-with-python-using-sqlalchemy-760c8df8d753

ClickHouse is designed to work with huge amounts of data.

But even on small amounts of data, it continues to outperform classical solutions (MySQL, PG) if it is the storage of historical data.

It’s also nicely easy to query. Would personally like this too.