# SingleStore Reviews **Vendor:** SingleStore **Category:** [Real-time Analytic Database Software](https://www.g2.com/categories/real-time-analytic-database) **Average Rating:** 4.5/5.0 **Total Reviews:** 118 ## About SingleStore SingleStore enables organizations to scale from one to one million customers, handling SQL, JSON, full text and vector workloads — all in one unified platform. ## SingleStore Reviews ### 1. Great near real-time analytics database **Rating:** 4.5/5.0 stars **Reviewed by:** Matt N. | Enterprise (> 1000 emp.) **Reviewed Date:** March 04, 2024 **What do you like best about SingleStore?** I have had a great experience using SingleStore. It can ingest massive amounts of change events from Kafka and keep up. It ingests this data within 3-5 seconds of update in our main application. Most of the queries we send to SingleStore come back within 5 seconds and work well with highly concurrent (thousands of customers) environments. For providing customer-facing dashboards and reporting, it is really fast and everything I expect. It also has a great ecosystem with its managed service running in AWS, Azure, and GCP, with support for customer-managed keys and other enterprise features we need. It also has cool newer features like database branching and fast JSON queries (it treats JSON like any other columnar data). It is like a really fast version of Snowflake or Databricks. It is easy to get up and going with SingleStore pipelines (no external tools like Kafka Connect or Apache Flink are required since they have SingleStore pipelines), and customer support is great too when I wasn't able to figure it out on my own. **What do you dislike about SingleStore?** It isn't open source, which I prefer. Despite being proprietary, they do make it fairly easy to use their free version on Docker or their managed free forever solution (but quite limited). The sales/procurement process can be a bit onerous too. **What problems is SingleStore solving and how is that benefiting you?** Faster ingest and query speed than most competing products. This results in a better user experience for our customers since they are often creating ad-hoc dashboards in our product and expect the experience to be snappy. As they are building new charts, reports, and dashboards, they iterate through different versions and tweak the settings, and each time they do this, they want the queries to come back within a second or two. Then, when they have 5-10 widgets on a dashboard, they expect those to come back within a couple of seconds. This great experience enables us to democratize reporting for our users and are delighted with our work management product. ### 2. Singlestore is best in market compared to Google's Bigquery **Rating:** 5.0/5.0 stars **Reviewed by:** Satwik L. | Freelancer, Small-Business (50 or fewer emp.) **Reviewed Date:** September 12, 2024 **What do you like best about SingleStore?** I like the scalability, versatililty in the product with architecture itself which can be used for multi models. **What do you dislike about SingleStore?** I feel singlestore is not beginner friendly as early stage developer in AI era. **What problems is SingleStore solving and how is that benefiting you?** SingleStore is best when I am creating saas applications for modern scaling architecture, multitenancy and easily customisable products. ### 3. User Friendly and Reliable in-memory DB **Rating:** 4.0/5.0 stars **Reviewed by:** Juzer A. | Enterprise (> 1000 emp.) **Reviewed Date:** March 01, 2024 **What do you like best about SingleStore?** Accessing and Loading relational data into tables is pretty efficient, reliable and fast. Having Singlestore employee as a consultant in the organisation helped us get answers from Singlestore to resolve a lot of minor issues and questions we had with this product. **What do you dislike about SingleStore?** It lacks replication product to replicate data on table by table basis from one cluster to another remote cluster. We need a reject file created for all rejected rows during pipeline load of millions of rows of a table, instead of abending at the first rejected row. **What problems is SingleStore solving and how is that benefiting you?** Transferring Data from Mainframe DB to in-memory DB on distributed platform is our long term goal. Also one of directive from our management is to have a never-down DB and Singlestore is the DB we are going to use to achieve it for our application. ### 4. SingleStore speeds up my daily workflow **Rating:** 4.0/5.0 stars **Reviewed by:** Sam P. | Small-Business (50 or fewer emp.) **Reviewed Date:** March 09, 2024 **What do you like best about SingleStore?** I use Singlestore daily, and it has great features. Their docs are very thorough, which makes it easy to find answers to question. Their support is very responsive. **What do you dislike about SingleStore?** Some of things inherent with the implementation of SingleStore make some tasks tedious, such as updating an enum column. **What problems is SingleStore solving and how is that benefiting you?** SignleStore allows our users to get data fast. The MySql flavor it uses makes it easy for us to query the data and find insights quickly. It also allows us to ingest massive amount of data quickly. ### 5. Singlestore review **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Primary/Secondary Education | Mid-Market (51-1000 emp.) **Reviewed Date:** March 08, 2024 **What do you like best about SingleStore?** The fact that it's the best of both worlds of row store and column store. It's easy to use and setup. We've been using it for a lot of our high throughput use cases and it has worked wonders. **What do you dislike about SingleStore?** A lot of the technology and functionality as it comes with a proprietary database is under the hood which makes is difficult to debug issues. And it takes a lot of back and forth with their support team to explain the issue and hopefully get a resolution. **What problems is SingleStore solving and how is that benefiting you?** Giving us the best of both worls of row store and column store so that we can do real time aggregates as well as individual row retrieval. ### 6. Successfull Co-Innovation Partnership **Rating:** 5.0/5.0 stars **Reviewed by:** Abel M. | Enterprise (> 1000 emp.) **Reviewed Date:** March 01, 2024 **What do you like best about SingleStore?** Query and Ingestion Speed at Scale over Multi-Model Storage w/ Simplicity . **What do you dislike about SingleStore?** Medium UX for Self-Hosted versions and medium materialization features **What problems is SingleStore solving and how is that benefiting you?** Chatbot, Customer Mobile Banking RT Analytics , Customer Intelligence for RT decision (multiple scenarios) ### 7. Database that changed our company **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Small-Business (50 or fewer emp.) **Reviewed Date:** March 08, 2024 **What do you like best about SingleStore?** Singlestore has made our data processing much easier and faster with its tooling **What do you dislike about SingleStore?** Pipelines can be slow and there's not very many logs around them **What problems is SingleStore solving and how is that benefiting you?** Data Processing -> makes cleaning & processing data easier ### 8. Singlestore Power of Analytics **Rating:** 5.0/5.0 stars **Reviewed by:** Franck L. | Data Sleek Founder, Information Technology and Services, Enterprise (> 1000 emp.) **Reviewed Date:** October 01, 2022 **What do you like best about SingleStore?** Singlestore is a MySQL drop-in solution. It supports Mysql Protocol. This database cluster solution allows you to scale horizontally and also vertically. You can add aggregators to scale high concurrency or leaf nodes to shard your data (Singlestore can rebalance the data with just 1 SQL command). Singlestore supports a fast array of analytical functions. You can also ingest data from their pipeline feature. Using SQL, you can create pipelines to connect to S3, Kafka, HDFS, Azure, and more and consume data in real-time without locking tables. **What do you dislike about SingleStore?** There are some limitations. You cannot use Foreign Keys (FK). Modifying clustered keys is not supported. Altering tables also has some limitations. Auto-incremental values are not always sequentials. **What problems is SingleStore solving and how is that benefiting you?** Real-time or near real-time analytics. Singlestore can ingest data using pipelines via tables or stored procedures. The non-lock mechanism allows users to query tables in real-time. Singlestore columnstore engine provides excellent compression (up to 80-90%), and aggregated queries just fly ! ### 9. The Best All-in-One Database Solution **Rating:** 5.0/5.0 stars **Reviewed by:** Charlie J. | Founder, Small-Business (50 or fewer emp.) **Reviewed Date:** November 10, 2022 **What do you like best about SingleStore?** I love how I'm able to use one database for transactional data (like storing users, and any associated data) alongside analytical data (like mass querying records). Every other solution I looked at required me to maintain 2 seperate databases, certainly not ideal in any means.. **What do you dislike about SingleStore?** Their managed solution starts out hefty, and I do wish they had cheaper options available. However they have a fantastic self-hosted version, which means there is no downsides to SingleStore. **What problems is SingleStore solving and how is that benefiting you?** Being able to use one centralised database for both types of data, saves me a ton of headache while also harnessing out of the box performance gains with SingleStore. **Official Response from Jeff Cotrupe:** > Charlie Joseph is an innovator and leader in leveraging real-time data to deliver amazing user experiences and build his business. We are proud to be supporting Analyse, the world's go-to-solution for Minecraft analytics, and excited to see Charlie continually taking his rapidly-growing company to the next level! ### 10. Amazing Experience - Really great product and support **Rating:** 5.0/5.0 stars **Reviewed by:** Herman S. | Lead Data ETL / ML Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** May 25, 2022 **What do you like best about SingleStore?** I really enjoyed using the SingleStore website! I found the tutorial and UI to be very clean and easy to use. The tutorial was helpful as well to some extent. The blogs/tutorials you guys write I think are instrumental in helping new users use your platform and follow along. More on this in another question. In terms of product, I liked being able to visualize the different parts of the node aggregation and seeing how the data was being inserted as well as its speed. I think being able to visualize the nodes working together was helpful in seeing the data being moved from one location to another. I think this is helpful in understanding where the costs are going as well, and what steps I can take in order to reduce cost while not hurting performance. **What do you dislike about SingleStore?** Not too much - I disliked the tutorials/documentation surrounding the work (to some extent). They were slightly different than what I actually needed to do (according to the Upwork specs). I think tutorials are a vital way to onboard new people to the platform. Making sure that each step is perfectly clear and identical (or near identical) to what needs to be done is important since having the first-impression onboarding process be as frictionless as possible will really set a positive tone for using your service more. As a developer, clear documentation is everything! **What problems is SingleStore solving and how is that benefiting you?** I think investing in good architectures and solutions early on is critical. Once certain infrastructure and processes are in place, it becomes more difficult to switch down the line. ## SingleStore Discussions - [Is there provisin forthe software to be open source or will this be only following a Pay for Services model?](https://www.g2.com/discussions/is-there-provisin-forthe-software-to-be-open-source-or-will-this-be-only-following-a-pay-for-services-model) - 1 comment, 1 upvote - [How the complex and internal architecture is different from native MySQL](https://www.g2.com/discussions/how-the-complex-and-internal-architecture-is-different-from-native-mysql) - 1 comment, 1 upvote - [When does it hang running memsql-ops --start sometimes](https://www.g2.com/discussions/when-does-it-hang-running-memsql-ops-start-sometimes) - 1 comment, 1 upvote - [Can we Use Amazon Kinesis to ingest data into memsql](https://www.g2.com/discussions/can-we-use-amazon-kinesis-to-ingest-data-into-memsql) - 1 comment, 1 upvote - [How to simplify scaling of MemSQL cluster?](https://www.g2.com/discussions/16032-how-to-simplify-scaling-of-memsql-cluster) - 1 comment, 1 upvote - [View SingleStore pricing details and edition comparison](https://www.g2.com/products/singlestore/reviews/singlestore-review-4258652?section=pricing&secure%5Bexpires_at%5D=2026-05-23+06%3A42%3A32+-0500&secure%5Bsession_id%5D=30f66a61-e11d-4a3a-bee1-4fa6c64efee5&secure%5Btoken%5D=277a6937e840e65f6c75ba187a39e4cb3160d7bada065d3ac9e285f1b7f7bc3d&format=llm_user) ## SingleStore Features **Management ** - Data Schema - Query Language - ACID - Complaint - Data Replication **Data Indexing** - Semantic Search - Indexing Data **Query latency** - Lower query latency - Continuous queries **Support ** - Text Search - Data Types - Languages - Operating Systems **Data latency** - Lower data latency - Data pipeline performance **Security** - Database Locking - Access Control - Encryption - Authentication **Filters** - Accurate Search - Single Stage Filtering - Vector Database **Connectors** - Faster ingestion - Built-in connectors **Performance ** - Disaster Recovery - Data Concurrency - Workload Management - Advanced Indexing - Query Optimizer **Scale** - Linearly scalable database - Storage management **Architecture** - Data security - Lockless architecture **Database Features** - Storage - Availability - Stability - Scalability - Security - Data Manipulation - Query Language ## Top SingleStore Alternatives - [PostgreSQL](https://www.g2.com/products/postgresql/reviews) - 4.4/5.0 (644 reviews) - [CockroachDB](https://www.g2.com/products/cockroachdb/reviews) - 4.3/5.0 (27 reviews) - [MySQL](https://www.g2.com/products/mysql/reviews) - 4.4/5.0 (1,576 reviews)