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

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

Fast Performance.

Rating: 7 out of 10
November 21, 2024
IncentivizedVetted ReviewVerified User
We use it to achieve fast performance and low latency with our custom applications. It has helped to improve performance compared to other database technologies.
Continue reading
Verified user
Analyst
SingleStore2 years of experience

Stellar performance and amazing tech support

Rating: 10 out of 10
November 15, 2024
IncentivizedVetted ReviewVerified User
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. SingleS...
Continue reading
Verified user
Engineer
SingleStore2 years of experience

The future is HTAP

Rating: 8 out of 10
November 9, 2024
IncentivizedVetted ReviewVerified User
We use SingleStore as the primary database for our Digital Marketing OS. It allows us to process transactions and answer complex analytical queries within the same database.
Continue reading
Pierre Bazoge
C-Level Executive - Engineering
CTO (Chief Technical Officer)
Rimdian
SingleStore2 years of experience

Robust, Fast, and Scalable Database Solution

Rating: 9 out of 10
June 6, 2024
IncentivizedVetted ReviewVerified User
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...
Continue reading
Nir Levy
Executive - Research & Development
VP R&D, DevOps, and Products
Zoomd Technologies
SingleStore1 year 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.3.

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 58)

The future is HTAP

Rating: 8 out of 10
Incentivized
November 09, 2024
PB
Pierre Bazoge
CTO (Chief Technical Officer)
Rimdian (Marketing & Advertising, 1-10 employees)
Vetted Review
Verified User
SingleStore
2 years of experience
View profile
Use Cases and Deployment Scope
We use SingleStore as the primary database for our Digital Marketing OS. It allows us to process transactions and answer complex analytical queries within the same database.
Pros
  • HTAP workloads
  • query profiling and explanations
  • customer support
Cons
  • visibility over memory management
  • the code source is closed, so we can't audit it for backdoors
  • would help to manage cluster settings via the UI without SQL
Likelihood to Recommend
SingleStore shines where you want to execute complex analytical queries over your datasets in real-time, and still want to handle transactions. It prevents you from having a transaction database and a separate async analytical database. However, running SingleStore is expensive, it requires a powerful cluster with a lot of RAM. If you don't need to process real-time analytics, you won't benefit much from SingleStore.

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

Rating: 9 out of 10
Incentivized
December 04, 2024
SC
Sergiu Cazac
Founder
Personizely (Computer Software, 1-10 employees)
Vetted Review
Verified User
SingleStore
2 years of experience
Use Cases and Deployment Scope
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 multiple types of databases, it's just a single database which is a drop-in replacement for MySQL and it works almost exactly the same at the API level with some differences, which we can live with but hope they can improve upon (like column adjustments on the fly, foreign keys, etc.)
Pros
  • Analytical queries
  • Basic SQL usage similar to how you would use MySQL
Cons
  • Column mutations (from null to not null, or type changes)
  • Foreign keys
  • Unique columns (for columnstore)
Likelihood to Recommend
It's perfect if you don't want to juggle multiple database providers for analytical and other app data. Also, it's great that it's managed.

Robust, Fast, and Scalable Database Solution

Rating: 9 out of 10
Incentivized
June 06, 2024
NL
Nir Levy
VP R&D, DevOps, and Products
Zoomd Technologies (Information Technology & Services, 51-200 employees)
Vetted Review
Verified User
SingleStore
1 year of experience
View profile
Use Cases and Deployment Scope
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
Pros
  • Real-time data processing
  • Online transaction processing
  • Big-data batch handling
  • Integration with external services (Kafka, S3, etc.)
  • Super fast data queries
Cons
  • While improving, backup is still hard to configure
  • Pricing of self-hosted instances
  • Few external documentation resources
Likelihood to Recommend
I would recommend SingleStore for use cases where a relational database is needed for handling both online transaction processing (OLTP), online data streaming, and batch big-data processing. Since it supports both in-memory and disc-based tables, it is suitable for handling large tables as well as smaller, fast ones.
SingleStore is MySQL compatible in terms of connection so you could use it with any connector that supports MySQL, and is mostly TSQL compatible so if you come from Transact-SQL background the switch will be simple.
While supporting JSON and document datatypes, I would not use SingleStore as a main document database, as its strengths lay in the relational realm.

Stellar performance and amazing tech support

Rating: 10 out of 10
Incentivized
November 15, 2024
Verified User
Engineer in Engineering
Computer Software Company, 1-10 employees
Vetted Review
Verified User
SingleStore
2 years of experience
Use Cases and Deployment Scope
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.
Pros
  • 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.
Cons
  • Although backups are robust, better support for incremental backups would be nice to have.
  • Support for IPv6 in the firewall settings for the cloud-based product would be useful.
  • An interface for scheduling maintenance in the cloud-based product would be a great improvement, though I hear that's coming soon.
Likelihood to Recommend
Our workload is 100% analytical. We also have to ingest a lot of data each month. SingleStore is a perfect match for our needs because it has fast pipelines for data ingestion and great performance, even in large and complex queries. We need fast response times for our user interface and great performance in our ETL processes, which are rather complicated. SingleStore handles all of this very well.

Fast Performance.

Rating: 7 out of 10
Incentivized
November 21, 2024
Verified User
Analyst in Other
Computer Hardware Company, 10,001+ employees
Vetted Review
Verified User
SingleStore
2 years of experience
Use Cases and Deployment Scope
We use it to achieve fast performance and low latency with our custom applications. It has helped to improve performance compared to other database technologies.
Pros
  • Fast performance.
  • Pre-aggregation.
  • Little latency.
Cons
  • Ease of use.
  • Not having to spend so much time modeling the data to get it ready.
  • Cost.
Likelihood to Recommend
Well-suited for pre-aggregations and performance improvements.
Return to navigation