I do not use the tool myself. Our developers and data analysts use it.
A flexible solution with good documentation and integration
Pros and Cons
- "The tool's most valuable feature is a database. It supports portal APIs and offers good flexibility."
- "If you join our team, it should be easy for you to use ClickHouse, especially if you are a developer. However, you need to read the documentation and understand the problems you are trying to solve."
What is our primary use case?
What is most valuable?
The tool's most valuable feature is a database. It supports portal APIs and offers good flexibility. While it may not be the best on the market, it is the best open-source solution we have tried. It has a development community and good documentation, though not all is published.
The tool's integration with other tools is not complex. We use it alongside Kafka and Tableau.
For how long have I used the solution?
I have been using the product for four years.
What do I think about the scalability of the solution?
Every customer I've worked with over the past few years uses ClickHouse, including many Russian companies and those related to Russia.
Buyer's Guide
ClickHouse
November 2024
Learn what your peers think about ClickHouse. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
814,649 professionals have used our research since 2012.
How are customer service and support?
I have some experience talking with the tech support team. It was an open-source project at one point, so I used community resources for help. The best way to communicate with them was through their program channel, which had support available in both English and Russian.
How was the initial setup?
Regarding the initial installation, setup, and deployment, I can say it's easy for someone with my engineering skills. I prefer managing the installation myself rather than relying on out-of-the-box solutions.
What other advice do I have?
ClickHouse is good for analytics. Using ClickHouse is beneficial if you understand its specific purpose and advantages. Many engineers and developers mistakenly think it is an alternative to AWS databases like Postgres or MySQL, but it's not. ClickHouse has a different architecture and purpose, primarily excelling at analytical queries rather than traditional CRUD operations.
If you join our team, it should be easy for you to use ClickHouse, especially if you are a developer. However, you need to read the documentation and understand the problems you are trying to solve. As an infrastructure engineer, it shouldn't be hard either.
I rate the overall solution an eight out of ten.
Which deployment model are you using for this solution?
On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Last updated: Jun 13, 2024
Flag as inappropriateBuyer's Guide
Download our free ClickHouse Report and get advice and tips from experienced pros
sharing their opinions.
Updated: November 2024
Popular Comparisons
MariaDB
PostgreSQL
MongoDB
Elastic Search
Redis
InfluxDB
Cassandra
SingleStore
Microsoft Azure Cosmos DB
OpenSearch
Milvus
Pinecone
Buyer's Guide
Download our free ClickHouse Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links
Learn More: Questions:
- When evaluating Open Source Databases, what aspect do you think is the most important to look for?
- Did you switch from a different solution to MySQL? Can you list a few pros and cons for making the move?
- Which database is the best for session cashing?
- Which low-code (no-code) database solution do you prefer?
- Why is Open Source Databases important for companies?