ClickHouse offers a friendly, unassuming, first impression. With it’s compatibility with MYSQL’s wire protocol, many may think that it should be easy to integrate with your existing system. With it’s promises of speed, it may seem like like a compelling option for your database application.
However, doing even the most simple thing in ClickHouse becomes a mess incredibly quickly, and the speed advantages often come at the cost of data accuracy. Programmers are often left out in the cold to design/redesign systems specifically to play nice with ClickHouse, which operates on a paradigm that relatively few are familiar with.
Digital life in the frozen tundra.