What users are saying about
4 Ratings
2 Ratings
4 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 9.4 out of 100
2 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 7 out of 100

Likelihood to Recommend

ClickHouse

The most important thing when using ClickHouse is to be clear that the scenarios in which you want to use it really are the right ones. Many users think that when a database is very fast for a specific use case, it can be extrapolated to other contexts (most of the time different) in which a previous analysis has not been carried out.
ClickHouse is an analytical database, as such, it should be used for such purposes, where the information is stored correctly, the data volumes are really large and the queries to be performed are not the typical traditional queries on several columns with multiple aggregations. ClickHouse is not the solution for this.
On the other hand, if your case is not one of the above, it is quite possible that ClickHouse can help you. Where ClickHouse shines is when you are looking for aggregation over a particular column in large volumes of data.
Anonymous | TrustRadius Reviewer

Valentina

If you have to manage a lot of different databases from different vendors, you could do well by standardizing on this product. It checks all the boxes for a proper database management studio. You would only have to learn one product to manage them all.However, if you are looking to find a good product for a single database vendor, you might be better off finding a tool that was designed specifically for that vendor product.
Aaron Smith | TrustRadius Reviewer

Pros

ClickHouse

  • Opensource
  • High performance
  • Multiple engines to adapt user cases
  • Easy configuration of data replication
Anonymous | TrustRadius Reviewer

Valentina

  • Foreign Key Constraint data viewer! This was a tremendously helpful feature that not many other products have. Just pick a constraint and see the data in the child tables! No setup required!
  • Supports any and every database imaginable.
Aaron Smith | TrustRadius Reviewer

Cons

ClickHouse

  • Avro data manipulation
  • Kafka consistency
  • DDL operations errors (by replica configuration)
Anonymous | TrustRadius Reviewer

Valentina

  • Somewhat laggy performance. Boot up speed was on the slow side and connecting to our database servers was also a little slower than other products.
  • User interface can be a little clunky. Instead of the usual tree view of servers, databases, and schemas, you are presented with lists that you click on and get new windows to pick the new list of data from. Not organized efficiently.
Aaron Smith | TrustRadius Reviewer

Alternatives Considered

ClickHouse

ClickHouse was not compared to them as a competitor but as the ideal partner to complete an information analysis system, providing users with the most complete and efficient tools. Therefore, in this case it was considered that it would be the ideal candidate due to its characteristics compared to the other competitors.
Anonymous | TrustRadius Reviewer

Valentina

Compared to Microsoft's SQL Management Studio, Valentina studio was comparable, just harder to get used to in the UI department. It ran slightly slower than other products but did save some time with neat features they baked into the product.However, in using DBeaver Community and DBForge Studio for PostgreSQL from Devart, we found different products that the team ultimately decided to use. DBeaver has all of the features we needed most (minus the constraint data viewer) and a more intuitive UI that we were used to. DBForge Studio for PostgreSQL has a very standard Windows look and feel and lacks some features, like database/table designers, but makes up for those shortcomings in the much easier filtering and sorting options right in the data grids. You can even write a query and edit the data returned, which is something we don't see in many of these tools.Our team ultimately settled on the developers using DBeaver and the support team that needs data viewing/editing capabilities using DBForge Studio.
Aaron Smith | TrustRadius Reviewer

Return on Investment

ClickHouse

  • Queries that used to take more than 2 minutes now take less than 1 second
  • Possibility to analyze use cases in real time (before was impossible)
  • The applications are more complete and the users decisions are better
Anonymous | TrustRadius Reviewer

Valentina

  • It saved time in some areas of finding child data by not having to write queries to find it.
  • The user interface caused some extra training for some users and ultimately caused them to not like using it.
Aaron Smith | TrustRadius Reviewer

Pricing Details

ClickHouse

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Valentina

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?

Add comparison