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.9.

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

(89)

Attribute Ratings

Reviews

(1-25 of 55)
Companies can't remove reviews or game the system. Here's why
Nir Levy | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
We are using SingleStore database as our main database in both production and non-production workloads. We are using both memory-based tables and disc-based tables (AKA column-store) and can easily join and query all tables. Our use of SingleStore is for many diverse business use cases, ranging from online data streaming, OLTP, and big-data batch processing.
SingleStore proved to be an excellent business and technical partner, with a top-of-line technical product and good business and technical support. Support is provided either directly from the supplier or from SingleStore's trusted partners
Score 10 out of 10
Vetted Review
Verified User
We recommend SingleStore to our customers who face scalability issues with their OLTP or OLAP systems. Many companies use database engines that are inappropriate for specific data computing tasks. For example, MySQL is not meant for analytics or real-time analytics. SingleStore is.
SingleStore compresses data, which lowers your disk footprint, thus saving storage costs.
Most of the time, we'll do a discovery about our customer pain points and determine if SingleStore is the right fit. We'll then work with SingleStore to do a POC to ensure we meet all customer requirements.
Score 10 out of 10
Vetted Review
Verified User
We use SingleStore for our various web apps. We were previously using AWS RDS which was slowing things down as we added more data and added more analytics, queries, and data enrichment tasks. Moving to SingleStore removed all of those bottlenecks.
Charlie Joseph | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
At Tebex we use SingleStore to power our game analytics SaaS. SingleStore is used to power our translytical queries, given that we solely rely on one database solution. We have investigated numerous solutions in the past, which have all required running multiple database solutions in parallel. One for transactional queries and the other for analytical queries. This makes foreign keys impossible to work with, in addition to opening up to multiple points of failure if things were to go wrong. Our use case at Tebex is to give in-game creators the ability to get a better view into their game server analytics. SingleStore makes this process very easy, and the MySQL wire integration has made working with SingleStore a lot easier than the competitors we looked at.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
SingleStore is used as source of truth for our data. It is one of our main database providers. Singlestore acts as a 1) historical ledger for granular log level data, as well as 2) a compute engine for deriving new metrics. Our use-cases for SingleStore span various environments including production, test, UAT, & development.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
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 for a much faster response, significantly improving user experience.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
The app we've built at Particl runs large analytical queries, and requires the ability to ingest large amounts of data 24/7. Most other services we looked into were not able to handle our analytical queries, or could not ingest the data quick enough. SingleStore has resolved this issue, which is mission critical.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
In our data-centric organization, SingleStore is integral for managing, processing, and analyzing vast amounts of data in real-time, enhancing our ability to serve dynamic insights to end-users. It adeptly addresses the critical need for speed and scalability in data operations, enabling swift data queries and seamless infrastructure expansion without sacrificing performance. Our application of SingleStore spans various functions, from operational systems to advanced analytics, facilitating a unified data view that supports coherent business strategies. Its real-time processing capabilities allow us to offer personalized user experiences, such as tailored recommendations and instant analytics dashboards. SingleStore's role is not just in data management; it's a catalyst for leveraging data as a strategic asset, fostering innovation and driving efficiency across our organization, thus aligning with our growth and evolving business needs.
January 29, 2024

The future of databases

Farrokh Mansouri | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
My team and I have engaged with SingleStore, discussing the potential use of their database in our newly developed application. In collaboration with the SingleStore team, we conducted a POC to show the advantages of using SingleStore in our application.
January 26, 2024

SingleStore

Shubham Agrawal | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We are using SingleStore as a DBMS. We wanted fast engine which reflects the data on portal immediately for better user experience. Also there were couple of use-cases where we wanted capability of transactional and real-time analysis. And SingleStore has fulfilled this requirement in my organization as it has capability of fast ingest and high-performance queries.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
SingleStore is the primary Database we use in our org. It powers all our use cases which include insights , dashboards and journeys in our customer's pages. We use SingleStore to pretty much store everything and retrieve a huge volume of data in near real time without experiencing any downtime. It has an excellent interface which makes it much better tool than others
Score 10 out of 10
Vetted Review
Verified User
Incentivized
We use SingleStore to manage a large and complex analytical workload for multiple financial customers. SingleStore is the database behind our real-time user interface. SingleStore also hosts our dashboards that display a mixture of data computed dynamically at the time of display and pre-computed values generated when data is ingested. Our software allows users to track the performance of retirement plans, and to compare data across plans. Many of these operations are data-intensive and we've been able to roll out many new and often compute-hungry features since switching to SingleStore two years ago.
Rex Elardo | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
I was doing some data engineering for this one client, and I thought that migration would take up to two weeks. In the end, thanks to Single store I was able to get everything done in less than an hour! The learning curve was incredibly easy, and incredibly well documented!
Score 8 out of 10
Vetted Review
Verified User
Incentivized
We are an analytics SaaS product and currently use Singlestore as our primary database. Customer data from different sources - website, ad platforms, CRM are streamed into singlestore and our end users can directly query this data from our web application. Queries are run against the singlestore database which helps us in streamlining the ingestion and analytical use cases.

The core business problems being solved by Singlestore are - having a unified database for customer data, running low latency queries and serving responses within tight SLAs to our clients
Score 8 out of 10
Vetted Review
Verified User
Incentivized
We have a lot of queries for analyzing data about student engagement and courses chosen and bought; we need to get future trends by combining our data with the data coming from open sources and bought. Most problems are related to the processing of big volumes of data and presenting it using tableau and power bi dashboards.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
It's our main data store. SingleStore replaced MySQL, PostgreSQL, Redis and Elasticsearch. It's being used for OLAP, OLTP, search and cache at the same time.
SingleStore has seriously decreased our infrastructure complexity, allowing us to move faster and with more confidence.
It has also allowed us to decrease infrastructure cost.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We use singlestoreDB as our landing storage for our product. Our product provides insights in data and quality of data. For that we require fast ingestion feom sources like S3, GCS and Azure Blob. We extensively use singlestoreDB's PIPELINE function for ingesting data into SingleStoreDB. We ran our ML algorithms on the data stored on singlestoreDB. Which gave us really good results and helped optimize our algorithms by using some of its inbuilt features
Samiran Mudgalkar | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
The most important use case is to load huge files into a distributed database system within a short span of time without having memory and time complexities. Whenever there is a need of transferring data for ETL during the staging phase and data warehousing stage, the load should be transferred without a lot of resource usage. Especially in the cloud space, the lesser we use the resources, the more cost-effective it is.
Return to navigation