ClickHouse vs. IBM Cloud Databases

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
ClickHouse
Score 9.4 out of 10
N/A
ClickHouse is an open-source, column-oriented OLAP database system enabling real-time analytical reports using SQL queries. With linear scalability, it handles trillions of rows and petabytes of data. ClickHouse Cloud offers a scalable serverless solution for real-time analytics.N/A
IBM Cloud Databases
Score 8.3 out of 10
N/A
IBM Cloud Databases are open source data stores for enterprise application development. Built on a Kubernetes foundation, they offer a database platform for serverless applications. They are designed to scale storage and compute resources seamlessly without being constrained by the limits of a single server. Natively integrated and available in the IBM Cloud console, these databases are now available through a consistent consumption, pricing, and interaction model. They aim to provide a cohesive…N/A
Pricing
ClickHouseIBM Cloud Databases
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
ClickHouseIBM Cloud Databases
Free Trial
YesNo
Free/Freemium Version
YesNo
Premium Consulting/Integration Services
YesNo
Entry-level Setup FeeOptionalNo setup fee
Additional DetailsPay for what is used: It automatically scales up and down compute resources based on the user's workload It scales storage and compute separately It automatically scales unused resources down to zero so that users don’t pay for idle services
More Pricing Information
Community Pulse
ClickHouseIBM Cloud Databases
Top Pros
Top Cons
Features
ClickHouseIBM Cloud Databases
Database-as-a-Service
Comparison of Database-as-a-Service features of Product A and Product B
ClickHouse
-
Ratings
IBM Cloud Databases
7.4
93 Ratings
16% below category average
Automatic software patching00 Ratings8.377 Ratings
Database scalability00 Ratings8.387 Ratings
Automated backups00 Ratings7.190 Ratings
Database security provisions00 Ratings8.683 Ratings
Monitoring and metrics00 Ratings5.487 Ratings
Automatic host deployment00 Ratings6.769 Ratings
Best Alternatives
ClickHouseIBM Cloud Databases
Small Businesses
SingleStore
SingleStore
Score 9.8 out of 10
SingleStore
SingleStore
Score 9.8 out of 10
Medium-sized Companies
SingleStore
SingleStore
Score 9.8 out of 10
SingleStore
SingleStore
Score 9.8 out of 10
Enterprises
SingleStore
SingleStore
Score 9.8 out of 10
SingleStore
SingleStore
Score 9.8 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
ClickHouseIBM Cloud Databases
Likelihood to Recommend
9.0
(2 ratings)
7.8
(95 ratings)
Likelihood to Renew
-
(0 ratings)
8.0
(7 ratings)
Usability
-
(0 ratings)
7.0
(6 ratings)
Support Rating
-
(0 ratings)
1.0
(10 ratings)
User Testimonials
ClickHouseIBM Cloud Databases
Likelihood to Recommend
ClickHouse, Inc.
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.
Read full review
IBM
Less Appropriate Scenario: 1) Small Scale or Low Budget Projects 2) Organizations with limited expertise in cloud technologies may find the learning curve steep, especially if they are not familiar with the IBM Cloud platform 3) If database requirements are highly dynamic and change frequently, the comprehensive features and management provided by IBM Cloud Databases might be overkill. A more flexible, self-managed solution could be preferable for adapting to rapid changes.
Read full review
Pros
ClickHouse, Inc.
  • Their MergeTree table engine provide impressive performance for data insert in bulk
  • Not only data insert but also the way MergeTree engine uses Primary Keys to sort the data and perform data skipping based on the granules its also their secret for ridiculous fast queries
  • Data compression its also great
  • They provide especial table engines that allow you to read data directly from other sources like S3
  • Since its written with C++ you have very granular data types and especial ones like enum, LowCardinality and etc, they save you a lot of storage since are stored as integer values
  • ClickHouse functions besides the ones that respect ANSI Standards are also awesome and useful
Read full review
IBM
  • The ease of setup was effortless. For anyone with development experience, a few simple questions such as name and login data will get you set up.
  • The web application to manage cluster settings, billing settings and even introspect the data was simple and most importantly worked all the time. This can not always be said for web interfaces of other products.
Read full review
Cons
ClickHouse, Inc.
  • Avro data manipulation
  • Kafka consistency
  • DDL operations errors (by replica configuration)
Read full review
IBM
  • Better cost reports, before just increasing to another tier, thus increasing the price. This is critical for early stage startups, where budget is tight.
  • Add more data center options. As a comparison, a similar service, Aiven.io has dozen more options than Compose (basically all big cloud providers). We moved from AWS to Digital Ocean, which made us stop using Compose, since Compose forces us to be either on IBM or AWS.
Read full review
Likelihood to Renew
ClickHouse, Inc.
No answers on this topic
IBM
IBM is our trusted partner which never failed to meet our expectations. Stability, efficiency, usability and security is a must have for our business which is fully provided by IBM Cloud Databases
Read full review
Usability
ClickHouse, Inc.
No answers on this topic
IBM
It is great the only things I have stumbled upon is the non standard port 80 they use and sometimes expired SSL certificate.
Read full review
Support Rating
ClickHouse, Inc.
No answers on this topic
IBM
Support is helpful enough, but we haven't always had questions answered in a satisfactory manner. At one time we realized that Compose had stopped taking database snapshots on its two-per-day schedule, and had in fact not taken one for many days. Support recognized the problem and it was fixed, but the lack of proactive checks and the inability to share exactly what happened has caused us to look elsewhere for production work loads
Read full review
Alternatives Considered
ClickHouse, Inc.
ClickHouse outperforms, especially in costs, since its compression/indexing engines are so smart, and even with very low computing power, you can already perform huge analyses of the data.
Read full review
IBM
The reason why I choose IBM Cloud Databases is that the IBM cloud toolset is already being used in other functions of the company and by using IBM Cloud Databases, the other cloud tools are better embedded and integrated. If the company is set to use amazon tools, I would go for rds.
Read full review
Return on Investment
ClickHouse, Inc.
  • 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
Read full review
IBM
  • Prove use cases prior to administering entire platform, obtain ROI faster
  • Able to achieve the technological components of our advanced analytics team without full scale purchase of AI platform
  • Developed several studies to prove out cloud Db value, speed to deploy
Read full review
ScreenShots