Try our new research platform with insights from 80,000+ expert users

ClickHouse vs SingleStore comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Mar 5, 2025

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

ClickHouse
Ranking in Vector Databases
10th
Average Rating
8.8
Reviews Sentiment
7.7
Number of Reviews
10
Ranking in other categories
Open Source Databases (6th)
SingleStore
Ranking in Vector Databases
13th
Average Rating
8.8
Reviews Sentiment
7.4
Number of Reviews
7
Ranking in other categories
Database as a Service (DBaaS) (7th)
 

Mindshare comparison

As of March 2025, in the Vector Databases category, the mindshare of ClickHouse is 2.9%, up from 0.9% compared to the previous year. The mindshare of SingleStore is 1.5%, up from 1.1% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Vector Databases
 

Featured Reviews

ArpitShah - PeerSpot reviewer
Open-source freedom with efficient data handling and room for documentation growth
A significant area for improvement is the documentation, which is not comprehensive and lacks centralized resources, making it difficult to find information. Additionally, ClickHouse lacks robust support for transactional data, which limits its use as a primary database. My developer experience could be enhanced through better-organized documentation, perhaps by offering a cheat sheet or centralized guide for common setup and usage scenarios.
Hitesh Kunchakuri - PeerSpot reviewer
A reasonably priced product that offers good speed and seamless support
Currently, I can't think of any areas that require improvement because SingleStore was recently launched in the market. The product can be developed further to provide more appropriate output to users as it is one of the areas where there are shortcomings. The current SingleStore model provides output based on the RANK function. If a user searches for a liquor bottle, then with all the data the product has, it will search for the liquor bottle in the data, and based on a match, the product has an algorithm to rank the product because of which the paragraph that has the best match will be ranked as a 100, the next one as 99, following which the next product will be ranked as 98 and so on. The output from the solution will fetch you all the 100 products that are available in a store, but sometimes a user might require a product with a 97 or 98 percent match from the DB, meaning the product doesn't always work to provide a 100 percent match, an area I feel that can be optimized in the product. Currently, SingleStore's features are excellent as it can read documents, images, and everything. The product works seamlessly for me.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"The best thing about the tool is that I can set it up on my computer and run queries without depending on the cloud. This is why I use it every day."
"It's easier to work with big data and calculations using the product."
"If you have a real-time basis, you should take a look at ClickHouse because it works on a vector database, and the querying is super fast compared to traditional databases."
"We faced a challenge with deploying ClickHouse onto Kubernetes. Recently, we've been using ClickHouse Cloud, and the main issue is the high cost of the cloud service. The pricing isn't very competitive, especially for startups. I would instead buy a server and self-host if I have enough disk space. Besides that, ClickHouse has done very well, with clear goals and effective execution."
"The tool is column-based and infinitely scalable."
"The tool's most valuable feature is a database. It supports portal APIs and offers good flexibility."
"ClickHouse is open source with no vendor lock-in, providing excellent freedom to choose any vendor without restrictions."
"The main feature of ClickHouse is the optimizer because we had too many records to deduplicate, and the optimizer took this task by itself."
"The paramount advantage is the exceptional speed."
"The ability to store data in memory is a standout feature, enhanced by robust failover mechanisms."
"The product's initial setup phase was pretty straightforward, with no complex processes."
"MemSQL supports the MySQL protocol, and many functions are similar, so the learning curve is very short."
"The most valuable feature is the ability to create pipelines, streamline and extract data from the pipelines."
"The product can automatically reinstall and reconfigure in case of a shutdown."
"It's a distributed relational database, so it does not have a single server, it has multiple servers. Its architecture itself is fast because it has multiple nodes to distribute the workload and process large amounts of data."
 

Cons

"The main issue is the lack of documentation. Many features are available but are not fully documented, which can make finding information challenging."
"One issue is that you need persistent volumes. Otherwise, if one system goes down, you lose data in that cluster."
"There aren't too many improvements I'd suggest for ClickHouse as it covers all my needs. There are just a few technical issues. For example, sometimes, when you want to get unique values and use certain tables, they don't work as expected. But it's not a major problem."
"I would like ClickHouse to work more on integration with third-party tools."
"ClickHouse has its own concept of database triggers and doesn't support traditional database triggers."
"We had a lot of troubles while deploying a whole cluster."
"There are some areas where ClickHouse could improve. Specifically, we encountered incompatibilities with its SQL syntax when migrating queries from MySQL or SQL to ClickHouse. This difference in details made it challenging to figure out the exact issues. Additionally, we faced difficulties due to the lack of a proper Django driver for ClickHouse, unlike MySQL, which Django supports out of the box."
"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."
"It is not the optimal choice for direct data collection through queries, and it's more suited for aggregation tasks."
"For new customers, it's very tough to start. Their documentation isn't organized, and there's no online training available. SingleStore is working on it, but that's a major drawback."
"We don't get good discounts in Pakistan."
"Having the ability to migrate servers using a single command would be extremely beneficial."
"Poor key distribution can significantly impact performance, requiring a backward approach in design rather than adding tables incrementally."
"The product can be developed further to provide more appropriate output to users as it is one of the areas where there are shortcomings."
"There should be more pipelines available because I think that if MemSQL can connect to other services, that would be great."
 

Pricing and Cost Advice

"The tool is free."
"We used the free, community version of ClickHouse."
"For pricing, if you use the self-hosted version, it would be free. Cloud services pricing would be an eight out of ten. I try to minimize costs but still have to monitor usage."
"The tool is open-source."
"ClickHouse has an open-source version, which is free to use and has almost all the features."
"ClickHouse Cloud is not expensive compared to other databases, costing a few dollars per month while providing fast performance."
"If you have an in-house deployment on Kubernetes or something, it's going to be very cheap since you'll be managing everything."
"SingleStore is a bit expensive."
"The price of the product is okay compared to the other available solutions in the market. SingleStore is a reasonably priced product, considering the functions it offers."
"Using it for analytical purposes can be cost-effective in the long run, especially in terms of infrastructure."
"They have two main options: cloud installation and bare-metal installation, each with different pricing models."
"The product's licensing is not expensive. It is comparable."
"I would advise users to try the free 128GB version."
report
Use our free recommendation engine to learn which Vector Databases solutions are best for your needs.
842,194 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Computer Software Company
27%
Financial Services Firm
15%
Educational Organization
14%
Manufacturing Company
9%
Financial Services Firm
33%
Computer Software Company
13%
Healthcare Company
5%
Manufacturing Company
5%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What is your experience regarding pricing and costs for ClickHouse?
ClickHouse is open source without direct fees, unlike other databases that have hidden fees or restrict hosting to their platforms. The open-source nature of ClickHouse allows for complete flexibil...
What needs improvement with ClickHouse?
A significant area for improvement is the documentation, which is not comprehensive and lacks centralized resources, making it difficult to find information. Additionally, ClickHouse lacks robust s...
What is your primary use case for ClickHouse?
The main use case for ClickHouse is as a data warehouse for handling large volumes of data that exceed the capabilities of traditional databases like Postgres. I use it for creating dashboards and ...
What do you like most about SingleStore DB?
The paramount advantage is the exceptional speed.
What is your experience regarding pricing and costs for SingleStore DB?
Using it for analytical purposes can be cost-effective in the long run, especially in terms of infrastructure. While building an on-premise cluster incurs an initial cost for servers with ample RAM...
What needs improvement with SingleStore DB?
There's a noteworthy consideration when it comes to collecting massive amounts of data. It is not the optimal choice for direct data collection through queries, and it's more suited for aggregation...
 

Comparisons

 

Overview

 

Sample Customers

Information Not Available
6Sense, ADNOC, Adobe, Akamai, CARFAX, Cigna, Cisco, Comcast, DBS Bank, Dell, Dentsu, EY, FirstEnergy, GE, Goldman Sachs, Heap, Hulu, IMAX, Kakao, Kroger, LG, LiveRamp, Lumana, NBC, OpenDialog, Outreach, Palo Alto Networks, PicPay, RBC, Samsung, Siemens, SiriusXM, SK Telecom, SKAI, Sony, State Street Financial, STC, SunRun, TATA, Thorn, and ZoomInfo.
Find out what your peers are saying about ClickHouse vs. SingleStore and other solutions. Updated: March 2025.
842,194 professionals have used our research since 2012.