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: 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

SingleStore - 10+ years of Experience

Rating: 9 out of 10
January 10, 2025
IncentivizedVetted ReviewVerified User
SingleStore is being used for concurrent high performance reporting powering Tableau BOBJ PowerBI and conventional .net and java pages. It is also being used for real time rep...
Continue reading
Verified user
Administrator
SingleStore25 years of experience

My Experience with SingleStore (MemSQL).

Rating: 7 out of 10
December 16, 2024
IncentivizedVetted ReviewVerified User
The SingleStore is high-performance, scalable, and real-time analytics on large datasets, particularly for hybrid transactional and analytical processing (HTAP); we had a requ...
Continue reading
Verified user
Director
SingleStore5 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

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

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

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.

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

Rating: 9 out of 10
Incentivized
January 10, 2025
Verified User
Engineer in Engineering
Financial Services Company, 5001-10,000 employees
Vetted Review
Verified User
SingleStore
4 years of experience
Use Cases and Deployment Scope
Performing real-time risk calculations on complex financial instruments. Advanced analytics at scale helps with risk management and compliance with regulatory reporting requirements. Other usages include an anomaly detection system, order management platform, and tracking and optimization movement across multiple regions in real-time. The distributed architecture and sub second query responses helps manage huge systems with ease.
Pros
  • Distributed architecture.
  • Sub-second query responses.
  • Handling time series data with high write and query performance.
Cons
  • The UI can be made more user-friendly.
  • Kubernetes integration.
  • Compression and storage efficiency.
Likelihood to Recommend
Well-Suited Scenarios: Real-Time Analytics: Financial trading platforms requiring instant insights. Operational Dashboards: Retail businesses monitoring live sales. IoT Data Processing: Smart device monitoring with high data ingestion. Fraud Detection: Banks detect suspicious transactions instantly. Less Appropriate Scenarios: Archival Storage: Cold data storage with infrequent access. Low-Volume Workloads: Small-scale apps with minimal data processing needs. Complex ETL Pipelines: Heavy data transformations without real-time demands.

SingleStore - 10+ years of Experience

Rating: 9 out of 10
Incentivized
January 10, 2025
Verified User
Administrator in Information Technology
Information Technology & Services Company, 10,001+ employees
Vetted Review
Verified User
SingleStore
25 years of experience
Use Cases and Deployment Scope
SingleStore is being used for concurrent high performance reporting powering Tableau BOBJ PowerBI and conventional .net and java pages. It is also being used for real time reporting with data loaded from OLTP systems using GoldenGate, Kafka and Spark. SingleStore is being used in Sales, Finance, Supply Chain, Inventory Management, Marketing, Servicing and Logistics reporting.
Pros
  • Powering multiple dashboards on a single screen within short span of time
  • Real time reporting for IOT devices
  • Warehouse queries powering dashboards which suffers due to concurrency in Warehouse Database Systems
Cons
  • Auto failover to DR Site
  • Eventual Consistency
  • Point in time recovery
  • Robust Monitoring
Likelihood to Recommend
SingleStore is well suited for warehouse dashboards used at executive level. There is no latency due to concurrency and the performance is terrific compared to SingleNode traditional databases.

High speed data ingestion powering IOT and other workload which also needs high speed seeks.

SingleStore support as well as Marketing team is excellent. They are always with you to troubleshoot until we achieve a fix.

Where SingleStore lacks is in OLTP systems where there is no capability of PITR. It is more like Flashback. Monitoring is still not robust, they provide exporter that can be used in Prometheus for alerting, but no monitoring rules are directly provided by SingleStore. Grafana prebuilt dashboard is provided which is good.

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.

Just get it already

Rating: 10 out of 10
Incentivized
January 09, 2025
Verified User
Engineer in Engineering
Marketing & Advertising Company, 11-50 employees
Vetted Review
Verified User
SingleStore
2 years of experience
Use Cases and Deployment Scope
SingleStore has allowed us to simplify our analytical queries. It has allowed us to eliminate intensive jobs that compiled stats for the previous day and instead given us a way to run those same queries on demand eliminating discrepancies and giving our organization the ability to tackle any analysis without having worry about it impacting other aspects of our stack.
Pros
  • Statistical analysis
  • Data ingestion
  • S3 integration
Cons
  • Schema altering
  • Lucene engine column compatibility
  • Use as a primary transactional db
Likelihood to Recommend
If analytical workloads are necessary this solves many problems and is a viable solution. It has lots of ways to ingest and export. Its not suitable as a heavy traffic transactional db, but as a piggy back it is ideal. It has been very reliable to boot, we love it!
Return to navigation