What do you like best about the product?

Everyone knows that ClickHouse is the fastest database on the planet, massively reducing the hardware footprint to $100 for most projects. But what makes it shine is the enormous range of procedural functions that can be intertwined with the SQL, which bridge scripting with query negating repetitive queries altogether and allowing itterative, selective and extrapolative access to extended field formats such as complex structures. Finally, the materialised view pre-calculates an abstracted table in the background. All around, it's incredible.

What do you dislike about the product?

There are no significant drawbacks except a slight learning curve when you get started, but as standard SQL works fine, the transition into more complex queries is painless, and the documentation helps a lot.

What problems is the product solving and how is that benefiting you?

Querying billions of records on a $100 device and speed benefit me the most.