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 56)
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
  • Real-time data processing
  • Online transaction processing
  • Big-data batch handling
  • Integration with external services (Kafka, S3, etc.)
  • Super fast data queries
  • While improving, backup is still hard to configure
  • Pricing of self-hosted instances
  • Few external documentation resources
Score 10 out of 10
Vetted Review
Verified User
  • Performance - from 60 to 1,000 requests/min
  • Scalability - grows as we grow
  • Processing - predictive algorithms went from taking 48 hrs down to 15 min
  • Customer Service - monthly touchpoints
  • SSO integration was initially challenging - they are already improving this
  • Cost - each tier literally doubles in price. It would be nice if there was some discounting as you go up.
Charlie Joseph | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
  • MySQL Integration/Wire
  • Self-Managed Solution
  • Analytical Query Speeds
  • Ability to perform Translytical Queries
  • Lower price plans for their paid solution
  • A longer period of time to use the free credits
  • More Node support within self-managed
Score 10 out of 10
Vetted Review
Verified User
Incentivized
  • In handling our growing data workloads, SingleStore's scalability stands out. As our user base expands, SingleStore enables us to scale our data infrastructure horizontally by adding nodes, ensuring that our applications maintain high performance without downtime or lag, even during peak usage periods.
  • As with many high-performance database solutions, managing costs in SingleStore can be challenging, particularly for small to medium-sized enterprises. The pricing model, especially when scaling out to accommodate larger data volumes or higher transaction rates, can become significant. More flexible pricing options or clearer guidelines on managing and optimizing resources to control costs would be beneficial.
  • While SingleStore integrates well with a range of data tools and platforms, there's room for improvement in broadening its ecosystem compatibility, especially with emerging data science and machine learning tools. Enhancing integration capabilities with popular data science platforms and tools would streamline workflows and enable more seamless data analysis and machine learning model deployment within the SingleStore environment.
January 26, 2024

SingleStore

Shubham Agrawal | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
  • Gives result of complex queries on large scale dataset
  • Data ingestion is much faster
  • User friendly SingleStore dahboard
  • There are lot of improvements need to in SingleStore official document
February 08, 2023

The future is HTAP

Pierre Bazoge | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
  • HTAP workloads
  • query profiling and explanations
  • customer support
  • 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
Score 10 out of 10
Vetted Review
Verified User
Incentivized
  • 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.
  • 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.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
  • Single database which can handle data ingestion and analytical queries at the same time. Helps achieve a consistent state of the data and power real time analytics
  • Very low latency query responses
  • SQL compatibility
  • Currently the costing happens at the configuration level - S2, S4 etc and is hence not fully elastic. As an end user, I expect the same flexibility as provided by Data warehouse solutions wherein it is truly Pay as much as we use
  • More visibility into Singlestore's feature roadmap and timelines would help in planning as and end user
Score 10 out of 10
Vetted Review
Verified User
Incentivized
  • Mixing OLAP and OLTP in the same cluster
  • Support and customer success team really is great
  • OLAP performance
  • Predictable performance scaling with cluster resources
  • **Much** better monitoring
  • Alerting
  • Smaller clusters offerings
  • More granular scaling
  • Better search features
  • Multi language support for search
  • Slow query visibility and analysis in real production workload
Score 9 out of 10
Vetted Review
Verified User
Incentivized
  • Data ingestion from object stores
  • Storing data in row and columnar store
  • Data ingestion from S3 to singlestoreDB takes 6secs for 550K records with 30 columns
  • Data ingestion from JDBC sources
  • More robust and easy to use Integration with tools like spark
  • More options for setting up and doing PoC with singlestoreDB
Samiran Mudgalkar | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
  • UI design
  • Perfect SQL editor and faster query execution
  • Ease of pipeline creation for data loads
  • Need to have a place to create an admin user for the first information schema database. Because when we log in, we do not have admin access by default to the system.
  • The state of the pipeline is not available if the currently available load is finished, there is extra work to check if all your files in the current load are complete.
  • The Dashboard can be a bit more simplified than having a lot of details.
Return to navigation