Skip to main content
TrustRadius
SingleStore

SingleStore
Formerly MemSQL

Overview

What is SingleStore?

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.

Read more
Recent Reviews
Read all reviews

Awards

Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards

Reviewer Pros & Cons

View all pros & cons
Return to navigation

Pricing

View all pricing

OnDemand

$0.69

Cloud
per hour

Entry-level set up fee?

  • Setup fee optional
For the latest information on pricing, visithttp://www.memsql.com/pricing

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting/Integration Services
Return to navigation

Product Details

What is SingleStore?

The world’s leading brands rely on data to make the right business decisions, to deliver exceptional customer experiences, and to stay ahead of the competition. This reliance on data brings with it a need for simplicity, speed, and scale. SingleStore aims to deliver the world’s fastest distributed SQL database for data-intensive applications: SingleStoreDB. By combining transactional + analytical workloads, the vendor states that SingleStore eliminates performance bottlenecks and unnecessary data movement to support constantly growing, demanding workloads. Customers spanning every vertical, including many Fortune 500/Global 2000/Inc.5000 brands, choose SingleStore to unleash the power of their data and supercharge real-time data experiences for their customers.

SingleStore Videos

The World's Fastest Database for Data-Intensive Applications
The Real-Time Revolutionorld's Fastest Database for Data-Intensive Applications
Data-Intensive Applications in Action
Building a Database for Real-Time Applications
A Customer's Big Data Journey From One to Many Products Under a Single Platform

SingleStore Integrations

SingleStore Technical Details

Deployment TypesOn-premise, Software as a Service (SaaS), Cloud, or Web-Based
Operating SystemsLinux
Mobile ApplicationNo
Supported CountriesGlobal
Supported LanguagesEnglish

Frequently Asked Questions

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.

Oracle Database, Microsoft SQL Server, and MongoDB are common alternatives for SingleStore.

Reviewers rate Performance highest, with a score of 9.8.

The most common users of SingleStore are from Small Businesses (1-50 employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(88)

Attribute Ratings

Reviews

(1-25 of 28)
Companies can't remove reviews or game the system. Here's why
Score 10 out of 10
Vetted Review
Verified User
We performed 2 MySQL to SingleStore migrations. In both cases, the customer was very happy with the results. For one customer, they were able to reduce the TCO by 50%. For the other customer, they were able to provide better performance for their application. We are also working on another project to reduce the data storage cost and improve the performance for an IOT company.
Jon Milsom | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
We have not taken advantage of this as we only use SingleStore on a greenfield project. That said, we are using SingleStore ONLY as a database AND session store. We would normally operate a separate Redis (Elasticache) instance for session storage.
Score 10 out of 10
Vetted Review
Verified User
SingleStore has allowed us to have a single platform for all our db needs both big and small. Previously we had a few "side" databases for little things that we didn't want to have bog things down. We also had a side db for some very complex queries and analytics that would always starve out the resources from the web apps. Now all of that is in one centrally managed place.
Charlie Joseph | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
As mentioned in a previous question, the majority of other solutions we looked at required multiple databases to manage - which not only meant multiple points of failure, but would also be a headache when doing any form of foreign key lookups.

SingleStore has been an awesome solution for translytical queries, and has made data management a breeze. We are able to focus on our data structure, instead of worrying about database structures.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Singlestore has done a decent job at collecting our data into one platform (as far as I can tell-- other parts of the org might use different database providers).

I would be cautious to say that SingleStore can replace multiple databases though. Singlestore is certainly an excellent compute engine and as a source of truth, but I do see possible use cases for wanting multiple databases.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
SingleStore quickly ingests our data from s3 files, which allows us to process and insert the data in a timely manner. Before, we were using a NoSQL database to handle ingestion, which made analytical queries extremely difficult and complex. The only recommendation I would have for ingesting data is ensuring that you have enough CPU to handle the data.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
SingleStore has been great at bringing all our data together into one spot. This has made it way easier to handle our data. We don't have to juggle multiple databases anymore, which makes everything simpler. We can roll out new stuff quicker without having to mess with moving data around. Basically, SingleStore has made our data management a lot smoother and less of a headache.
January 29, 2024

The future of databases

Farrokh Mansouri | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
We haven't achieved that objective. Our team recently learned about SingleStore and we started our development using a different database. That's why, our SingleSore adoption is going to be gradual and slower. If we knew about SingleStore a few years ago, this might have been different.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
SingleStore handles all our data. But this was also true of our previous provider because all our data is relational. However, we are considering some future features that might take advantage of SingleStore's ability to handle unstructured data, JSON columns, and so forth. One feature that we like about SingleStore is how easy it is to run queries across multiple databases. This was far from straightforward with our previous provider.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
One issue is that files and records are spread out across many locations, making it difficult to retrieve the information you need. For example, we have financial information stored in an accounting database, and customer data is in a customer relationship management (CRM) platform. To derive meaningful insights from our data, we have had to manually cross-reference multiple data sources, which has led to errors and misinformed decisions. There was also a lot of time and money associated with managing scattered information silos, not to mention the wasted effort involved when data is duplicated because employees don’t know that the specific data they need already exists in the system. SingleStore helped us to resolve most of these types of problems by combining all our data in one place.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We use singlestoreDB for our products backend<br>We use it to store our user data as well the data on which we perform data quality checks with our ML algorithms.<br>By doing this we saved the cost of maintaining different database systems for our products data and the user input data on which we perform operations.<br>
Return to navigation