ClickHouse as the Looking Glass for OLTP Data

ClickHouse as the Looking Glass for OLTP Data

When users come to Altinity.Cloud, many are not trying to replace non-analytical databases like MySQL or PostgreSQL. They want to migrate data to ClickHouse and keep it in sync with the database, just like a mirror. In this post, we look at a ‘pure ClickHouse’ approach, highlighting interesting features and problems that require external tools.

ClickHouse Dictionaries, Reloaded!

ClickHouse Dictionaries, Reloaded!

ClickHouse external dictionaries are a “ClickHouse way” to handle multi-dimensional schema. ClickHouse Dictionaries Explained was the very first article in the Altinity blog three years ago. ClickHouse has improved significantly since then, and dictionaries have achieved a new level of utility. In this article, I will explain two new cool ClickHouse features that completely change the way how dictionaries can be used. Change in a good sense, of course.