--- title: SingleStore Reviews meta\_title: 'SingleStore Reviews 2026: Details, Pricing, & Features | G2' meta\_description: Filter 118 reviews by the users' company size, role or industry to find out how SingleStore works for a business like yours. aggregate\_rating: rating\_value: 4.5 review\_count: 118 scale: '5' date\_modified: '2026-08-09' parent\_category: name: Database Software url: https://www.g2.com/categories/database-software --- # SingleStore Reviews & Product Details Claimed ###### Profile Status This profile is currently managed by SingleStore but has limited features. Are you part of the SingleStore team? [Upgrade your plan](https://sell.g2.com) to enhance your branding and engage with visitors to your profile! SingleStore enables organizations to scale from one to one million customers, handling SQL, JSON, full text and vector workloads — all in one unified platform. * * * Seller [SingleStore](https://www.g2.com/sellers/singlestore) Discussions [SingleStore Community](https://www.g2.com/products/singlestore/discuss) Languages Supported English Solution Type All-in-One Overview by Jeff Cotrupe Show More ## Value at a Glance Averages based on real user reviews. ### Time to Implement 4 months ### Return on Investment 21 months [ View More Pricing Information ](https://www.g2.com/products/singlestore/pricing) ## Top-Rated Alternatives [ ![CockroachDB](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "CockroachDB") CockroachDB 4.3/5(29) ](https://www.g2.com/products/cockroachdb/reviews) [ ![PostgreSQL](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "PostgreSQL") PostgreSQL 4.4/5(684) ](https://www.g2.com/products/postgresql/reviews) [ ![MySQL](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "MySQL") MySQL 4.4/5(1,682) ](https://www.g2.com/products/mysql/reviews) [ View All Alternatives ](https://www.g2.com/products/singlestore/competitors/alternatives) ## User Insights Average based on 118 real user reviews. Implementation Time 4 months Perceived Cost $$$$$ [Log in to unlock pricing and user insights](/login) JA Juzer A. Enterprise (\> 1000 emp.) 3/1/2024 "User Friendly and Reliable in-memory DB" 4/5 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. Review collected by and hosted on G2.com. 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. Review collected by and hosted on G2.com. 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. Review collected by and hosted on G2.com. Show More Validated ReviewerSource: Organic ![Sam P.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Sam P.") SP Sam P. Small-Business (50 or fewer emp.) 3/9/2024 "SingleStore speeds up my daily workflow" 4/5 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. Review collected by and hosted on G2.com. 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. Review collected by and hosted on G2.com. 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. Review collected by and hosted on G2.com. Show More 3/15/2024 Current UserValidated ReviewerSource: Organic ![Verified User in Primary/Secondary Education](/assets/icons/anonymous-avatar-purple-4ae1032bdb50ee5682003170c8184aee790d25958bd397abbd384ba52c596a7b.svg "Verified User in Primary/Secondary Education") AP Verified User in Primary/Secondary Education Mid-Market (51-1000 emp.) 3/8/2024 "Singlestore review" 4/5 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. Review collected by and hosted on G2.com. 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. Review collected by and hosted on G2.com. 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. Review collected by and hosted on G2.com. Show More Validated ReviewerSource: Organic ![Verified User in Telecommunications](/assets/icons/anonymous-avatar-purple-4ae1032bdb50ee5682003170c8184aee790d25958bd397abbd384ba52c596a7b.svg "Verified User in Telecommunications") CT Verified User in Telecommunications Small-Business (50 or fewer emp.) 5/16/2022 "SingleStore Advantage" 4/5 What do you like best about SingleStore? "I think the success of SingleStore will align with the adoption of HTAP. The detailed processing of large volumes of data with real-time Analytics will magnify the benefits of SingleStore." Review collected by and hosted on G2.com. What do you dislike about SingleStore? SingleStore's success is based on the widespread adoption of HTAP, which does not have a large following at this time. Review collected by and hosted on G2.com. What problems is SingleStore solving and how is that benefiting you? Concurrent loading and analytics Review collected by and hosted on G2.com. Show More 3/14/2023 Validated ReviewerSource: Organic ![Verified User in Real Estate](/assets/icons/anonymous-avatar-purple-4ae1032bdb50ee5682003170c8184aee790d25958bd397abbd384ba52c596a7b.svg "Verified User in Real Estate") AR Verified User in Real Estate Mid-Market (51-1000 emp.) 5/24/2022 "SingleStore is a great solution to help build data-intensive, cloud-based applications." 4/5 What do you like best about SingleStore? My experience was good. The concept of a super-fast, cloud-native ACID database is of course very attractive, and I think the implementation is adequate for the most part. The innovations brought to the table with SingleStore's Codegen Architecture and Universal Storage. I experimented with the sample databases provided, and the queries were indeed very fast and responsive, even when I deliberately made then very awkard and convoluted. Setting up the AWS cluster was also very easy and straight-forward. The support team was also cordial and helpful. Review collected by and hosted on G2.com. What do you dislike about SingleStore? My main concern is with the documentation and user experience. The docs and articles are a bit outdated and the examples provided do not work as intended. For example, the process to set up a data pipeline described here (https://developers.singlestore.com/blog/how-to-load-100-billion-rows-of-data-ultrafast/?utm\_source=upwork&utm\_medium=psm&utm\_campaign=7014x000002ltsdqak&utm\_content=fastapps) does not work. Besides, many pages still refer to SingleStore as MemSQL. I also found it a bit hard to locate the access point for SingleStore Studio. Query errors could be more explicit. When I input an invalid query, the error message is some variant of (ERROR 1064 ER\_PARSE\_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near), which is a bit cryptic and not very helpful. If I could, I'd allow more SQL flavours to be used, as not everyone is familiar with MySQL's peculiarities. I also would open source as many key database developments as possible, to make new discoveries more accesible to the world. Review collected by and hosted on G2.com. What problems is SingleStore solving and how is that benefiting you? The need for SingleStore DB system arises whenever you would need a way to quickly setup and manage a huge database (more than 1B rows). I think the product correctly combines the advantages of ACID guarantees with cloud-based scalability I'd definetly consider using SingleStore if I had to build a data-intensive web application. Running things on the cloud can be a little tricky and expenses can pile up if you're not careful. However, doing it correctly will get rid of a lot of headaches in SWE and make your product better for developers and consumers. Review collected by and hosted on G2.com. Show More Validated ReviewerSource: Organic ![Carlos A.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Carlos A.") CA Carlos A. Lead Data Developer Enterprise (\> 1000 emp.) 7/10/2022 "Amazing solution" 4/5 What do you like best about SingleStore? I liked the speed to upload data and the potential to load big volumes so it is solution that thinks out of box. Review collected by and hosted on G2.com. What do you dislike about SingleStore? The GUI is not so clear, sometimes is difficult to find some obvious thing like create a database Review collected by and hosted on G2.com. Recommendations to others considering SingleStore: I really recommend for companies that it is starting to think in big data world. Review collected by and hosted on G2.com. What problems is SingleStore solving and how is that benefiting you? I have seen the potential to load big volumes of files so I am interesting to see how it works to query and aggregate big volumes as well with multiples joins. Review collected by and hosted on G2.com. Show More Validated ReviewerSource: Organic ![Varshini S.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Varshini S.") VS Varshini S. Database Engineer Information Technology and Services Enterprise (\> 1000 emp.) 12/7/2021 "Amazon RDS Cluster is managed efficiently thanks to SingleStore DB" 4/5 What do you like best about SingleStore? SingleStore DB is effective for managing all database applications and their dependencies from both on-premise and cloud platforms. It provides super-fast insights about the ingestion and performance statestics whenever a DB query is processed. It provides excellent data redundancy capabilities in which multiple operational data connectors can work together to share resources within that particular data cluster. SingleStore DB manages all the synchronization issues in case if a cluster malfunctions as it ensures that we are able to access our database from other regions. Review collected by and hosted on G2.com. What do you dislike about SingleStore? I don't find anything to dislike about SingleStore DB as its great for my usage and manages my database application clusters in a fantastic manner. Its dashboard is transparent and insightful so its also easy to evaluate our application deployments. Review collected by and hosted on G2.com. What problems is SingleStore solving and how is that benefiting you? The best thing about SingleStore DB is it ensures the high availability of our database clusters which are established as Amazon RDS clusters in our organization. It also allows me to automate a lot of processes in our cluster, which will allow us to obtain notifications in case if there are high computational resource requirements for our cluster. The failover condition is effectively handled by SingleStore DB thanks to its data replication strategies, in which cluster availability is ensured by replicating our Amazon RDS servers. Data locking feature is also convenient while working with a distributed cluster as updation and deletion of nodes occur in real-time and SingleStore DB ensures to visualize the changes in real-time on its intuitive dashboard. Review collected by and hosted on G2.com. Show More Current UserValidated ReviewerIncentivizedSource: G2 invite ![Verified User in Consumer Goods](/assets/icons/anonymous-avatar-purple-4ae1032bdb50ee5682003170c8184aee790d25958bd397abbd384ba52c596a7b.svg "Verified User in Consumer Goods") AC Verified User in Consumer Goods Small-Business (50 or fewer emp.) 9/10/2019 "Great performance and super easy to deploy" 3.5/5 What do you like best about SingleStore? By making use of the memsql-ops tooling, I'm able to quickly and easily spin up an entire cluster with HA. Review collected by and hosted on G2.com. What do you dislike about SingleStore? The database makes heavy use of memory (which is one of its selling points), which can make it challenging in instances where large queries can bring a node to a halt due to out of memory issues. Improved understanding of the system and better monitoring can help work around that potential pit fall. Review collected by and hosted on G2.com. Recommendations to others considering SingleStore: If you're able to accomodate the high-ish system requirements for a MemSQL cluster, and have the need for a high performance database for large datasets, give MemSQL a go. Review collected by and hosted on G2.com. What problems is SingleStore solving and how is that benefiting you? Running queries over large data sets in reasonable amounts of time. We've been able to pump through many millions of records in seconds, where in other database systems we were having our queries time out. Review collected by and hosted on G2.com. Show More Response from Rob Richardson of SingleStore [Editedit](https://www.g2.com/survey_responses/singlestore-review-3173308/official_response/edit) That’s phenomenal you’ve reached HA so quickly. What are the out-of-memory errors you encountered? How can we improve the documentation to make these easier to discover? Reach out to community@memsql.com. We’d love to learn more about your experiences. Current UserValidated ReviewerIncentivizedSource: G2 invite on behalf of seller ![Garrett G.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Garrett G.") GG Garrett G. Director of Product Management Information Technology and Services Mid-Market (51-1000 emp.) 9/13/2019 "Scaling Without Worries" 3.5/5 What do you like best about SingleStore? The ease with which our team can build out new data models and deploy them into our production systems without worry that our infrastructure can handle it. Review collected by and hosted on G2.com. What do you dislike about SingleStore? While MemSQL is an excellent managed database service, the price tag for the features that they deliver is fairly high compared to the market. Review collected by and hosted on G2.com. What problems is SingleStore solving and how is that benefiting you? We are able to unify massive content delivery data across our clients in the Global 2000, and have built out a market leading analytics stack on top of that that we are able to deliver back to our clients. We have been able to rapidly develop and scale data models that have made us a leader in our space. Review collected by and hosted on G2.com. Show More Validated ReviewerIncentivizedSource: G2 invite on behalf of seller ![Verified User in Financial Services](/assets/icons/anonymous-avatar-purple-4ae1032bdb50ee5682003170c8184aee790d25958bd397abbd384ba52c596a7b.svg "Verified User in Financial Services") CF Verified User in Financial Services Enterprise (\> 1000 emp.) 9/13/2019 "Good fit as an operational data store for legacy databases" 4/5 What do you like best about SingleStore? Fast response times which makes it a good fit for an alternate ODS for legacy databases like Db2 on mainframe. Also, it has potential to be used for both for transaction processing as well analytical queries. Review collected by and hosted on G2.com. What do you dislike about SingleStore? Some of the data types supported by legacy databases are not supported by MemSQL Review collected by and hosted on G2.com. Recommendations to others considering SingleStore: A good option for ODS with legacy databases. Also, the in-memory processing means it can support both transaction processing as well as analytical queries. Review collected by and hosted on G2.com. What problems is SingleStore solving and how is that benefiting you? On legacy databases like Db2 on mainframe, a bulk of the transactions are for read while a small part is related to write. Porting the data onto MemSQL and creating a copy allows the application to divert the inquiry calls to the alternate database thereby saving lot of money. Review collected by and hosted on G2.com. Show More Response from Rob Richardson of SingleStore [Editedit](https://www.g2.com/survey_responses/singlestore-review-3188082/official_response/edit) It sounds like you’ve really become successful migrating your legacy workload reads to a more performant database. Would you be willing to do a case study with us so we can highlight your achievements to the industry? Reach out to community@memsql.com. Validated ReviewerIncentivizedSource: G2 invite on behalf of seller ## Questions about SingleStore? Ask real users or explore answers from the community Get practical answers, real workflows, and honest pros and cons from the G2 community or share your insights. [ Ask about SingleStore ](https://www.g2.com/products/singlestore/discussions/new) ![Samvida P.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Samvida P.") SP Samvida Pathak • Last activity over 3 years ago Is there provisin forthe software to be open source or will this be only following a Pay for Services model? 1 Upvote 1 [ Join the conversation ](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) GU Guest User What are the benefits and drawbacks of using SingleStore for database management? 0 Upvotes 0 [ Join the conversation ](https://www.g2.com/discussions/what-are-the-benefits-and-drawbacks-of-using-singlestore-for-database-management) [ View all Discussions ](https://www.g2.com/products/singlestore/discuss) ## Pricing Insights Averages based on real user reviews. ### Time to Implement 4 months ### Return on Investment 21 months ### Perceived Cost $$$$$ [ View More Pricing Information ](https://www.g2.com/products/singlestore/pricing) SingleStore Comparisons ![Product Avatar Image](https://images.g2crowd.com/uploads/product/image/small_square/small_square_2b00e05c107c3273cea5264090c3c1d0/snowflake.jpg "Product Avatar Image") Snowflake 4.6/5(764) [ Compare Now ](https://www.g2.com/compare/singlestore-vs-snowflake) ![Product Avatar Image](https://images.g2crowd.com/uploads/product/image/small_square/small_square_cee19035e959576dd35e1ad8c03f4a97/cockroachdb.png "Product Avatar Image") CockroachDB 4.3/5(29) [ Compare Now ](https://www.g2.com/compare/cockroachdb-vs-singlestore) ![Product Avatar Image](https://images.g2crowd.com/uploads/product/image/small_square/small_square_251be2af3ae607c45c14e816eaa1cf41/postgresql.png "Product Avatar Image") PostgreSQL 4.4/5(684) [ Compare Now ](https://www.g2.com/compare/postgresql-vs-singlestore) ##### ##### SingleStore Features Database Features Storage Availability Stability Support Text Search Data Types Performance Workload Management Advanced Indexing Query Optimizer Management Data Schema Query Language ACID - Complaint [ View More Features ](https://www.g2.com/products/singlestore/features) ##### Categories on G2 [Relational Databases](https://www.g2.com/categories/relational-databases)[Vector Database](https://www.g2.com/categories/vector-database)[Real-time Analytic Database](https://www.g2.com/categories/real-time-analytic-database) ##### Explore More [What bot platform handles the handoff from chatbot to a live human agent well without the customer having to repeat themselves?](https://www.g2.com/discussions/bot-platforms-what-bot-platform-handles-the-handoff-from-chatbot-to-a-live-human-agent-well-without-the-customer-ha)[Which rebate management systems are most trusted by procurement teams, based on user reviews?](https://www.g2.com/discussions/which-rebate-management-systems-are-most-trusted-by-procurement-teams-based-on-user-reviews)[What's the best CPQ software with custom pricing features](https://www.g2.com/discussions/what-s-the-best-cpq-software-with-custom-pricing-features) [IBM Consulting vs Capgemini vs HP Enterprise Consulting for enterprise mobility: which mobility consulting firm provides the best risk assessment and vendor selection support for regulated industries?](https://www.g2.com/discussions/ibm-consulting-vs-capgemini-vs-hp-enterprise-consulting-for-enterprise-mobility-which-mobility-consulting-firm-provides-the-best-risk-assessment-and-vendor-selection-support-for-regulated-industries)[Which supplier risk management app is best for handling third-party risks](https://www.g2.com/discussions/which-supplier-risk-management-app-is-best-for-handling-third-party-risks)[Which fleet management platforms can a team get live quickly without a long implementation process or relying on IT the whole way through?](https://www.g2.com/discussions/which-fleet-management-platforms-can-a-team-get-live-quickly-without-a-long-implementation-process-or-relying-on-it-the-whole-way-through) [Show MoreShow Less](javascript:void(0);)