SingleStore

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
SingleStore
Score 9.7 out of 10
N/A
SingleStore aims to deliver the world’s fastest distributed SQL database for data-intensive applications: SingleStoreDB, which combines transactional + analytical workloads in a single platform.
$0.69
per hour
Pricing
SingleStore
Editions & Modules
OnDemand
$0.69
per hour
Offerings
Pricing Offerings
SingleStore
Free Trial
Yes
Free/Freemium Version
Yes
Premium Consulting/Integration Services
Yes
Entry-level Setup FeeOptional
Additional Details
More Pricing Information
Community Pulse
SingleStore
Considered Both Products
SingleStore
Chose SingleStore
We found SingleStore to be significantly superior to bare-bones MySQL as it offers better performance and scalability. It is also richer in terms of the query language supported, stored procedures, and connectivity. We also found it to be more robust than MySQL and with better …
Chose SingleStore
SingleStore is built for fast data ingestion and fast queries against large tables (> billions of rows). This is possible because of the column store engine that SingleStore uses. SingleStore also support a memory engine. Pipelines is also another big advantage. Being able to …
Chose SingleStore
SingleStore has outperformed these in speed and performance. However it is more expensive but has been worth the cost so far.
Chose SingleStore
We knew early on that MySQL (Amazon Aurora) would not be suitable for this workload as it cannot query our time series data as fast as SingleStore. We also use MongoDB Atlas for another application but we could not achieve the raw speed we saw from SingleStore. Our technical …
Chose SingleStore
We were initially using AWS Aurora which worked well at the time but as we grew it just felt like a lumbering beast - even with tier upgrades. We started looking at caching & search options to help make searches faster - we were already using redis. We looked at and even …
Chose SingleStore
Timescale was the biggest alternative option we looked at for SingleStore, however the requirement to learn a new syntax (due to not being SQL compatible) was our biggest pain point.

Supporting a new language would require alterations to the Laravel framework, as this only …
Chose SingleStore
SingleStore provides an abstraction layer in managing a sharded database solution reducing complexity for the FLOWD team. Coupled with the SingleStore Managed Service, we are partnering with SingleStore to provide FLOWD services to various utilities & councils.
Chose SingleStore
SingleStore is eons faster than other database providers, and it absolutely crushes calculations & aggregations. While other providers may have a few quality of life enhancements over SingleStore, the speed benefits of SS far outweigh the cons. At the end of the day, speed …
Chose SingleStore
SingleStore provides performance for real-time data analytics application where as Snowflake is more for data engineers and not fast enough for real-time data analytics apps.
Chose SingleStore
As I said before, we felt that running queries on BigQuery for every query is really slow, especially from an user point of view. After seeing the drastically improved latency of SingleStore we decided to use to solve this issue. We currently use it to run low volume queries …
Chose SingleStore
SingleStore was the fastest sql database we have tried, allowing for analytical queries on TBs of data.
Chose SingleStore
We've tried both these above, to solve ingestion and analytical queries. Dynamo was a perfect ingestion service, but it didn't allow us to run intense analytical queries. Aurora helped us run these analytical queries, and ingestion was reasonable, BUT the queries were simply …
Chose SingleStore
Very similar offerings. SingleStore promise a faster query speed and better cost structure. Vector databases is anoter offering that is unique to SingleStore.
Chose SingleStore
SingleStore outperformed both MongoDB and PostgreSQL for OLAP workloads. Its ability to shard data and handle parallel processing of SQL "JOIN" queries across shards is a game changer.
Chose SingleStore
We looked at Microsoft Azure SQL, MariaDB, Vertica, and RedShift. Our criteria were cost and performance. We also needed compatibility with the Azure cloud as this is where our other systems were running. This was in 2020. After approximately three months of evaluation, we …
Chose SingleStore
SingleStore is simply easier to use and most importantly much, much faster. For Big Data, it is an absolute life saver :)
Chose SingleStore
We selected SingleStore due to its multi cloud nature, SQL compatibility and customer references who operate similar applications as us
Chose SingleStore
It seems that SingleStore is good at being able to handle complex queries against large datasets out of the box. In the past, we've had to do quite a bit of manual configuration and database performance tuning, but SingleStore (so far) has seemed to require minimal …
Chose SingleStore
SingleStore achieves same or much better performance, while avoiding all data sync and migration
Chose SingleStore
The SQL dialect seems to be pretty compatible, and I especially appreciate that you can connect to it with native MySQL tooling.
Chose SingleStore
Well honestly, Initially I thought it would be just another SQL Relational Database Management System but when I actually signed up and use SingleStore, I was amazed to see such integration of intuitive and easy-to-use UI and such powerful performance. So, the CSV for cosmetic …
Chose SingleStore
first and important advantages is super fast, the million of data can be treated on Seconds
Top Pros
Top Cons
Best Alternatives
SingleStore
Small Businesses
Google Cloud SQL
Google Cloud SQL
Score 8.7 out of 10
Medium-sized Companies
Snowflake
Snowflake
Score 9.0 out of 10
Enterprises
SAP IQ
SAP IQ
Score 9.0 out of 10
All AlternativesView all alternatives
User Ratings
SingleStore
Likelihood to Recommend
9.8
(56 ratings)
Likelihood to Renew
9.2
(4 ratings)
Usability
9.1
(7 ratings)
Availability
9.1
(1 ratings)
Performance
9.8
(30 ratings)
Support Rating
9.1
(7 ratings)
Implementation Rating
9.1
(1 ratings)
Ease of integration
9.1
(1 ratings)
Product Scalability
9.1
(1 ratings)
Vendor post-sale
9.1
(1 ratings)
Vendor pre-sale
9.1
(1 ratings)
User Testimonials
SingleStore
Likelihood to Recommend
SingleStore
SingleStore HTAP engine is well suited for real-time analytics, fast ingestion, scaling OLTP system like MySQL. When you need to run reports or perform aggregates on billions of rows and you get result in seconds, you cannot get this experience with other OLTP engines. I wish DBtLab was a little more developer and supported for SingleStore. This would allow to perform better data transformation. You can use stored procedures, but DBTLabs has become a standard for dimensional modeling in data warehousing projects. This is probably why SingleStore has trouble piercing in the data warehouse world. It is definately capable to compete with Snowflake when it comes to scalability, query performance, data compression, but Snowflake has ravaged the data warehouse market in few years and large corporations have already invested lots of money in migrating into Snowflake. The SingleStore community needs to grow. Everyone who uses SingleStore loves it.
Read full review
Pros
SingleStore
  • Technical support is stellar -- far above and beyond anything I've experienced with any other company.
  • When we compared SingleStore to other databases two years ago, we found SingleStore performance to be far superior.
  • Pipeline data ingestion is exceptionally fast.
  • The ability to combine transactional and analytical workloads without compromising performance is very impressive.
Read full review
Cons
SingleStore
  • We wish the product had better support for High Availability of the aggregator. Currently the indexes generated by the two different aggregators are not in the same sequential space and so our apps have more burden to deal with HA.
  • More tools for debugging issues such as high memory usage would be good.
  • The price was the one that kept us away from purchasing for the first few years. Now we are able to afford due to a promotion that gives it at 25% of the list price. Not sure if we'll continue after the promotion offer expires in another 2 years.
Read full review
Likelihood to Renew
SingleStore
We haven't seen a faster relation database. Period. Which is why we are super happy customers and will for sure renew our license.
Read full review
Usability
SingleStore
[Until it is] supported on AWS ECS containers, I will reserve a higher rating for SingleStore. Right now it works well on EC2 and serves our current purpose, [but] would look forward to seeing SingleStore respond to our urge of feature in a shorter time period with high quality and security.
Read full review
Reliability and Availability
SingleStore
We have not experienced any downtime in the two years that we have been using SingleStore.
Read full review
Performance
SingleStore
SingleStore's performance is incredible. Our predictive algorithms went from taking 24-48 HOURS down to 15 minutes allowing our team to run those much more frequently. Previously, we were limited to about 60 requests per minute due to table locks. Implementing columnstore on SingleStore allowed us to receive 1000 requests per minute.
Read full review
Support Rating
SingleStore
Very responsive to trouble tickets - Often, I think, the SingleStore's monitoring systems have already alerted the engineers by the time I get around to writing a ticket (about 10 - 20 mins after we see a problem). I feel like things are escalated nicely and SingleStore takes resolving trouble tickets seriously. Also SingleStore follows up after incidents to with a post mortem and actionable takaways to improve the product. Very satisfied here.
Read full review
Implementation Rating
SingleStore
We allowed 2-3 months for a thorough evaluation. We saw pretty quickly that we were likely to pick SingleStore, so we ported some of our stored procedures to SingleStore in order to take a deeper look. Two SingleStore people worked closely with us to ensure that we did not have any blocking problems. It all went remarkably smoothly.
Read full review
Alternatives Considered
SingleStore
Timescale was the biggest alternative option we looked at for SingleStore, however the requirement to learn a new syntax (due to not being SQL compatible) was our biggest pain point. Supporting a new language would require alterations to the Laravel framework, as this only offered SQL integration out of the box. This alteration would be time consuming and would limit our scope to future hiring due to the new syntax.
Read full review
Scalability
SingleStore
We needed more memory on our cluster. SingleStore handled it very smoothly.
Read full review
Return on Investment
SingleStore
  • As the overall performance and functionality were expanded, we are able to deliver our data much faster than before, which increases the demand for data.
  • Metadata is available in the platform by default, like metadata on the pipelines. Also, the information schema has lots of metadata, making it easy to load our assets to the data catalog.
Read full review
ScreenShots