DEV Community

Discussion on: ClickHouse: The Good, The Bad, and The Ugly

Collapse
 
lindesvard profile image
Carl-Gerhard Lindesvärd

What I try to explain here is that Clickhouse actually not is your ordinary relationship database. Clickhouse is a powerful beast but you need to know some things about it before you start. I hope it can help a few out there.

I started to use clickhouse 2 years ago and didn't have much knowledge about columnar databases then, so a lot of the stuff in the article are real world issues I assume many does.

Anyway, thanks for reading and commenting.

Collapse
 
xwero profile image
david duymelinck • Edited

My comment is not meant to shame you. It is a general observation about people adopting a different database type while not understanding it.
Another thing, besides thinking SQL is for relational databases, I see is that people use the relational mindset to structure other database types. If you don't structure the database the right way, the performance will be poor. And most of the times the database type will be blamed.

We all have a learning curve when we start using a unknown technology. The thing I learned over the years is to first get enough knowledge to find out what problem is the technology solving and how does it do that. And then start to explore if it helps you to solve the problem that made you look at the new technology.

Thread Thread