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

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
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
  • 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
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.
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.
  • Data Ingestion
  • Scaling Writes and Reads
  • Compressing Data
  • Support
  • Short learning curve
  • MySQL to SingleStore replication
SingleStore HTAP engine is well suited for real-time analytics, fast ingestion, scaling OLTP system like MySQL.
When you need to run reports or perform aggregates on billions of rows and you get result in seconds, you cannot get this experience with other OLTP engines.
I wish DBtLab was a little more developer and supported for SingleStore. This would allow to perform better data transformation.
You can use stored procedures, but DBTLabs has become a standard for dimensional modeling in data warehousing projects. This is probably why SingleStore has trouble piercing in the data warehouse world. It is definately capable to compete with Snowflake when it comes to scalability, query performance, data compression, but Snowflake has ravaged the data warehouse market in few years and large corporations have already invested lots of money in migrating into Snowflake.
The SingleStore community needs to grow. Everyone who uses SingleStore loves it.
March 01, 2024

Singlestore is Great!

Score 9 out of 10
Vetted Review
Verified User
Incentivized
We use it as our main database solution. We use it to query large datasets in large analytical queries.
  • Speed
  • Ingestion
  • Customer Service
When analytics are needed on millions of rows of data SingleStore is a great solution.
Jon Milsom | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
We use SingleStore to ingest, store, and process data from our hardware player trackers. The challenge is the amount of data (hundreds of millions of rows) and being able to query it quickly.
  • Fast ingest via Pipelines
  • Standard SQL syntax
  • Fast query times
  • The dashboard should show a list of recent backups (you have to run a query to get this information right now)
SingleStore is well suited to handling tables with huge numbers of rows and being able to query these. It does its own thing with auto-incremented primary keys, so it may be difficult to migrate legacy MySQL applications with large numbers of tables.
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.
  • 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.
Business analytics is one of the areas where SingleStore really helped. As we implemented BI platforms, the previous DB would bog down so bad that it negatively affected our online products. Moving to SingleStore made a huge difference. General performance is amazing. We gained speed in areas we were not even expecting to the point we had to slow down or put rate limits in place to avoid duplications - something completely unexpected. The hosted service is great. We no longer have to worry about maintenance, db infrastructure or system updates which saves a significant amount of time for the IT team.
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.
  • 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
SingleStore is a phenomenal solution and replacement to MySQL/MariaDB. Being able to instantly start using it without any prior experience is fantastic, as other solutions required learning new syntax which slows development.

In addition, SingleStore offers many opt-in features such as Rowstore rather than being obliged to use it. I believe it’s better to use features as needed, rather than being forced to dive in and deal with learning things.

One of the biggest factors to what drew me to SingleStore was the self-managed option, being a startup at the time we didn’t want to pay for a solution. We still use the self-managed option 2 years later, and couldn’t imagine using anything else.
Score 10 out of 10
Vetted Review
Verified User
FLOWD uses SingleStore as its data store for water usage readings. It needs to deal with the ingestion of hundreds of water monitoring devices and provide real time analytics to users.
  • Data Ingestion
  • Real Time Analytics
Big Data ingestion and real time analytics capability/performance is crucial to the success of our water monitoring IoT Platform - FLOWD
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.
  • Computation
  • Sharded infrastructure
  • Query optimization tools/AI Assistants
  • Granular user-permissioning in the online UI
  • More robust server-level telemetry data
  • Easier to access/use database log information
SingleStore is excellent at computing heavy workflows. The column-store table design combined with efficient sharding strategies make for a beast of a database that lets you compute large queries at ease. Singlestore also offers a variety of developer tools such as SQrL (their AI assistant) and their Query Profiler, which are massively helpful for figuring out what bottlenecks exist in a given query.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
We use it as our analytical database. It is more reliable and faster than our previous vendor. It also allowed us to replace another service that frees up $1500/month. We retrieve thousands of records at a time quickly.
  • Delivering thousands of records at blazing fast speeds
  • full text search
  • scaling
  • Improved UI for their portal
  • Better ticket system
  • More workers on workspace
Reliable, scales and you can do full text search across the data. Customer support ticketing system could be improved but it's barely a con
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.
  • Low latency
  • Better concurrency
  • Query cost is bit higher.
SingleStore is best suited for high concurrency and low latency query executions.
Score 7 out of 10
Vetted Review
Verified User
Incentivized
We use SingleStore for all our database needs. We rely on it to store terabytes of data and do complex analytical queries very quickly.
  • Speed
  • Profile complex queries
  • Ticketing system is slow
  • Web app crashes a lot
When intense analytical queries are needed to be done on billions of rows of data then SingleStore is great and outperforms other databases. If an application just requires transactional operations then its probably overkill.
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.
  • Large Analytical Queires
  • Data Ingestion
  • Columnar Storage Compression
  • Support
  • A world where certain tables could use foreign keys.
  • Easier way to resume/restart data ingestion
SingleStore is great for large amounts of data, and handling highly performant queries at scale, across many tables. We've built intense queries, that finish extremely quick, helping us provide realtime data.

If a company is not needing this type of performance, or do not need complex analytical queries, I'd recommend looking else where for a simpler and cheaper database service.
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.
  • 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.
Well-Suited
1. Real-Time Analytics -Ideal for platforms needing instant data analysis, like financial trading systems.
2. Operational Intelligence-Great for sectors such as e-commerce or logistics that require real-time operational decision-making.
3. Scalable SaaS Applications - Suitable for fast-growing SaaS applications due to its excellent scalability.

Less Appropriate
1. Budget-Constrained Projects - Not the best fit for projects with limited funding due to its cost structure.
2. Complex Data Warehousing- Other solutions might be better for deep analytical queries over massive, historical datasets.
3. Unstructured Data Storage-Less efficient for storing and managing large volumes of unstructured data like images or videos.
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.
  • high query speed
  • vector databases
  • transactional and analytical database in one
  • head to head comparison with the competition
  • Simplification of the ETL process
  • Integration with more BI platforms.
SingleStore is suitable when using transactional and analytical databases in one. SingleStore is highly scalable for new applications where they start small while planning for a large future growth.
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.
  • 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
SingleStore is perfectly suited for ingestion of big-data at faster speed
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
  • Ingest huge volume of data
  • Query and retrieve huge volume of data
  • Very highly reliable datastore
  • More compatibility with mysql's sql like query
  • better admin interface
usage as document store is still very limited . Using SingleStore as a relational database is a breeze but using it as a document store to needs a lot of improvement.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
We use it as our application database and have a tremendous performance impact since we are using SingleStore. We also like how it has developed and what future benefits it will offer.
  • Speed
  • Performance
  • Sizing
  • Managed Service
  • Pricing
  • Larger User base
Suited well for application databases. Not best fit for key-value storages.
February 08, 2023

The future is HTAP

Pierre Bazoge | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
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.
  • 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
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.
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.
  • 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.
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.
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!
  • Speed
  • documentation
  • efficiency
  • I would love an SDK
  • A CLI would be cool
  • Beyond that, the nodes work great! I was confused at first but then understood how each plan is different
If you have a massive database, then Singlestore is perfect for you! You can save lots of time on many projects, get everything faster :)
However, if you database is relatively small (under 1GB) then the value that SingleStore provides may not be there for you. Yes, even 1GB can take 15 minutes to upload sometimes but that is not awful.
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
  • 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
Any application which needs 1. Low Latency query responses and 2. Access to real time data would benefit from implementing SingleStore. Use cases which are not time sensitive and can run in adhoc batch mode may be well suited to work off data warehouses. Also, SingleStore helps reduce operational overhead in terms of engineers managing batch and real time flows separately
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.
  • Scalability on demand.
  • Near real time performance.
  • Easy query profiling.
  • Usability
  • Reliability and Availability.
  • Performance
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 to transfer 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 SingleStore is perfect for running data analytics workloads due to how easy it is to get data in & out. The performance and ease of use of the product are almost unmatched, which saves us a tremendous amount of time over having to spin up custom RDS instances for data analytics.
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.
  • 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
It has transformed into my go to database software. The only scenario in which I wouldn't use or recommend it, is if their base managed cluster is too expensive and I don't want to managed it myself
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
  • 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
singlestoreDB can be used for both staging data and creating marts on which ML algorithms can be run.
The most interesting part is their pipeline function which allows really fast and consistent ingestion of data. And setting up these pipelines is really easy with configurations for sources system creds.
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.
  • 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.
1. The one place where it is required the most is, during ETL processing where the resource utilisation is optimized and faster data load is achieved.

2. The places where it is not suited are, when the data load is very low and there is not much difference achieved while execution of data loads.
Return to navigation