Skip to main content
TrustRadius
SingleStore

SingleStore
Formerly MemSQL

Overview

What is SingleStore?

SingleStore aims to enable organizations to scale from one to one million customers, handling SQL, JSON, full text and vector workloads in one unified platform.

Read more

Learn from top reviewers

SingleStore is Fast and Furious

Rating: 8 out of 10
April 17, 2025
IncentivizedVetted ReviewVerified User
I use SingleStore for the data warehouse of a fintech, which processes payments through TCs worldwide. The integration was with Azure DataFactory, without complications, it he...
Continue reading
Victor Cáceres
Manager - Information Technology
Database Administrator (DBA)
Cooperativa CREA
SingleStore3 years of experience

SingleStore The Ultimate HTAP Database for Real-Time Performance.

Rating: 7 out of 10
February 26, 2025
IncentivizedVetted ReviewVerified User
IOT data processing and log analysis. The power of unified management is evident out of the box. Quick deployment, comprehensive troubleshooting, and customizable periodic rep...
Continue reading
Verified user
Employee
SingleStore5 years of experience

Why I like SingleStore ?

Rating: 9 out of 10
January 31, 2025
IncentivizedVetted ReviewVerified User
We use SingleStore for a super fast client experience, running real time analytics on billions of events arriving every day from various publishers channels.
Continue reading
Ziv Fridfertig
Manager - Engineering
Dev Enablement Director
Skai
SingleStore6 years of experience

"SingleStore: A Powerful All-in-One Database for Real-Time Analytics and Transactions"

Rating: 9 out of 10
January 10, 2025
IncentivizedVetted ReviewVerified User
Performing real-time risk calculations on complex financial instruments. Advanced analytics at scale helps with risk management and compliance with regulatory reporting requir...
Continue reading
Verified user
Engineer
SingleStore4 years of experience

Great database solution for apps that require analytics and those who don't want to juggle db providers

Rating: 9 out of 10
December 4, 2024
IncentivizedVetted ReviewVerified User
We are using SingleStore to power our whole app database layer. We use it both for our basic tables and also for the analytical ones. The magic is that we don't need to have ...
Continue reading
Sergiu Cazac
Director - Information Technology
Founder
Personizely
SingleStore2 years of experience
Log in with LinkedIn to see content from your network

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

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, visithttps://www.singlestore.com/pricing/

Offerings

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

Product Details

What is SingleStore?

SingleStore enables organizations to quickly and easily scale from one to one million customers, handling SQL, JSON, full text and vector workloads in one unified platform.

SingleStore Features

  • Supported: Vector database
  • Supported: Transactions (OLTP)
  • Supported: Analytics (OLAP)
  • Supported: SQL
  • Supported: JSON
  • Supported: Real-time

SingleStore Videos

SingleStore NOW 2024: Outreach / AI- and Data-Driven Sales
SingleStore Now 2024 / Snowflake + SingleStore: Better Together
SingleStore NOW 2024: Adobe / What’s New in SingleStore: AI in Production
SingleStore Now 2024: AWS / Enterprise AI Innovation: Gen AI Experimentation
SingleStore Now 2024: 6sense / AI in Production: Lessons Learned
SingleStore Now 2024: LlamaIndex / Building Multi-Agent RAG Systems
SingleStore NOW 2024 / LiveRamp: Building the World’s Largest Identity Graph without a Graph DB
SingleStore Now 2024: SAS + SingleStore = Enterprise AI at Scale
SingleStore Now 2024 / Pyler: AI-Powered Brand Safety
SingleStore Now 2024: Groq / AI Trends, and Running LLMs in the Enterprise
SingleStore Now 2024: AI with SingleStore, IBM StreamSets and watsonx.ai

SingleStore Integrations

SingleStore Competitors

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 enable organizations to scale from one to one million customers, handling SQL, JSON, full text and vector workloads in one unified platform.

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

Reviewers rate Performance highest, with a score of 9.1.

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

Comparisons

View all alternatives
Return to navigation

Reviews From Top Reviewers

View all reviews
(1-5 of 72)

Good For Interactive Analytics and Dashboards

Rating: 9 out of 10
Incentivized
December 09, 2020
DT
Darrin Thompson
Director of Engineering
Direct Employers (Human Resources, 51-200 employees)
Vetted Review
Verified User
SingleStore
3 years of experience
View profile
Use Cases and Deployment Scope
We use it to power a custom reporting and analytics solution as part of a larger product offering we sell. It has low enough latency to power impressive dashboards for our end users.

Pros
  • Processes large amounts of data with very low latency.
  • The support department is fantastic.
Cons
  • The developer experience is lacking. Running developer instances locally requires a lot of RAM.
Likelihood to Recommend
Low latency analytics or dashboards based on large numbers of records.

Near immediate time from record ingest to availability in large queries.

SingleStore - The Performance Beast

Rating: 9 out of 10
March 07, 2022
AS
Anant Sirohi
Software Engineer(DE)
Crisp Analytics (Computer Software, 201-500 employees)
Vetted Review
Verified User
SingleStore
1 year of experience
View profile
Use Cases and Deployment Scope
I'd be using SingleStore as the primary Database so as to handle real-time ingestion and analysis of data with big volume. The existing data model is working on processing batch data which is not much efficient and fast. I'll be ingesting the data from Kafka and because of the great compatibility of SingleStore with Kafka, I'll be using it to build reports on the top of the data.
Pros
  • super fast data ingestion and queries
  • commonly used formats such as csv, json and parquet are well supported
  • MySQL engine allowing the customers also to work easily
  • minimum administration needed
  • support team is quick and helpful
Cons
  • Every time i run a new query, it opens a new query result tab
  • Lot of RAM required while running Developer instances locally
  • limited information on the running queries
Likelihood to Recommend
It would be really fast for OLTP workloads as compared to MySQL and can be used in this use case. While working on large datasets, I've experienced that SingleStore has much faster processing capabilities and is highly recommended in such scenarios.

SingleStore outlook from a guy who handles infra , traffic and latencies

Rating: 10 out of 10
March 16, 2022
Use Cases and Deployment Scope
I am a DevOps Engineer and I work on Kubernetes, Cloud, I had a use case where I was working on creating a product that can calculate Kubernetes and cloud costs and represent it in that use case I was supposed to ingest data which was being populated in s3 to my database on which I can run queries, this using SingleStore could have been seem-less as it makes data ingestion from cloud simpler and since it helps running lot vol queries with smaller response time could have helped me lower the latency of my service.
Cons
  • Did not find support for User Defined Functions.
  • It opens a new query result tab and that feels irritating to me personally.
  • Lot of RAM required while running Developer instances locally.
Pros
  • Compatibility with S3 and data formats such as Parquet, JSON, and CSV
  • Can be Deployed on a Kubernetes Cluster and can be scaled seamlessly.
  • Great UI and support documentation available to look and work around.
  • Scale out capability
  • Fast data ingestion and queries
  • Can be used to lower the latencies of various services
Likelihood to Recommend

SingleStore provides for customer-facing internal users but fails for production usage

Rating: 8 out of 10
Incentivized
August 30, 2021
Verified User
Director in Other
Internet Company, 501-1000 employees
Vetted Review
Verified User
SingleStore
1 year of experience
Use Cases and Deployment Scope
SingleStore is used for 2 main use cases:
  • In-house developed A/B testing analysis tool uses this to fetch raw data in real-time when end users analyse the tests using the UI.
  • Machine learning models fetch the raw data and calculate needed features in real-time instead of preprocessing the data by the data engineers.
Pros
  • Return results of complex queries scanning TBs of data in sub-seconds.
  • Customer support team answer tickets quickly and provide guidance.
  • MySQL engine which allows to query using simple MySQL drivers from different clients.
  • Queries profiling is easy to use and helps investigating performance.
Cons
  • Loading batch data using pipelines is complex.
  • No native monitoring and alerts of resources (CPU, RAM, etc.).
  • Performance is strongly coupled with number of nodes (sometimes extra nodes hurt the performance).
  • Very expensive compared to other databases.
Likelihood to Recommend
SingleStore is well suited for analyzing big raw data in order to provide users with timely fashioned answers, as well as helping less technical teams to be independent of engineering teams and use simple SQL in order to use this data. The problem is that when there's a need to support more than a few TBs the price is very expensive and therefore it will be harder to use for applications in production when sub-second (less than 20ms) response is required.

Meet the SingleStore, a platform for fast analytics and real time insights.

Rating: 10 out of 10
February 17, 2022
Verified User
Professional in Information Technology
Computer Software Company, 1-10 employees
Vetted Review
Verified User
Use Cases and Deployment Scope
I would use SingleStore databases on e-commerce websites where loads of data are being generated, and where you need a fast data collection to analyze user behaviors and provide real time recommendation.
Pros
  • Fast on intense data load
  • Few clicks away to have the environment setup
  • Easiness/speed to load data from different pipelines
  • Great speed on running complex queries
Cons
  • SQL Editor opens a new result tab on every query run
  • Consumption of RAM memory through browser if you have many queries
Likelihood to Recommend
SingleStore environment is easy to adapt, it is extremely fast on collecting data from different sources (AWS, GCP or Azure), provides monitoring of activities and easy use multiple databases. It is good for analytical and recommendation based scenarios, and provides fast results on complex queries. In SingleStore platform queries execution open new tab result for each run, which makes it difficult to navigate over the results.
Return to navigation