# 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. ### 11. Wicked fast and easy to use database **Rating:** 4.5/5.0 stars **Reviewed by:** Michael Z. | Chief Technology Officer, Small-Business (50 or fewer emp.) **Reviewed Date:** November 15, 2022 **What do you like best about SingleStore?** Easy to build pipelines, fast migration path from mysql, easy to learn and understand how it works. Benefits of a rowstore and speed of a columnstore. **What do you dislike about SingleStore?** Backups do not work well- we have had several issues with these. **What problems is SingleStore solving and how is that benefiting you?** Allows very fast ingestion of 300M digital asset exchange trades daily so we can create real-time prices. ### 12. High performance database ingestion for OLTP and OLAP **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Banking | Enterprise (> 1000 emp.) **Reviewed Date:** July 14, 2022 **What do you like best about SingleStore?** - I have been using Microsoft SQL Server and related tools for more than 11 years. - UI is minimal and slick. Mostly, I have used SSMS and Visual studio to access the databases. There will be lot of options in SSMS/Visual studio but we wont be using most of them and it will be confusing. I like SingleStore's minimal UI. - UI options are easy to understand and navigate. - Setting up a cluster with S-16, 128 vCPU and 1 TB RAM took less than 3 minute. - Literally with 5 min, I was able to sign up and start using the database. - Guided tutorial was helpful based on what we want to achieve. - Setting up a pipeline and starting it from SQL is very nice and handy. - In a traditional setup, I would have used SSIS, ADF, Informatica or some other ETL to build the pipeline and then load the data. - It is a time consuming process to build the ETL packages and maintaining the same. - Literally, with just two sql command I can create and start the pipeline. I like this approach so much. - It is super fast in processing the very large volume of data. I have loaded 100B records in 40 minutes. The configuration I was using was S-16, 128 vCPU and 1TB RAM. The CSV file is AWS us-east region and I spun up a maching in Azure Netherlands region. This could be the reason it took 40 min. Otherwise it would have been even faster it was in same availability group. - In Microsoft SQL Server, I would have used BULK INSERT to load the CSV file. Most of the time, it was painful to do it if the size of the file is huge (more then 2GB). I will be getting out of memory error due to maching config. Then I go and split the file into several chunk and then try to load. It was never a good experience for me. But, with singlestore, all I need was two commands to create and start the pipeline. I like this. I like how SingleStore can be used for different types of data load like streaming and batch data. **What do you dislike about SingleStore?** - Monitoring section was somewhat confusing for me. - I was trying to see which query is running, but it was asking to start profiling. - I was not clear whether we have to start profiling to check the active queries and node details. - Even if we need to start profiling, to check the node details was not making sense to me. We should be able to see the nodes details and what is going on. - I did not know what to do in Monitoring section. So I started the profiling. The options were not clear for me. I have selected custom timeframe 60 min. I was under the impression that the profiling will run for 60 min in the background and I can see the active queries and node details. That could have been better or it could have been communicated to the user better. - I prefer to access and manage the database from the desktop application. I did not find any desktop application provided by SingleStore. **What problems is SingleStore solving and how is that benefiting you?** Loading huge volume of data like 100 billion records in 40 minutes with S-16 cluster, 128 vCPU and 1TB RAM. This will be a huge time saver and can produce the reports almost near time. ### 13. Excellent experience with this product. **Rating:** 4.5/5.0 stars **Reviewed by:** MUHAMMAD W. | Data Analyst (BI Engineer), Small-Business (50 or fewer emp.) **Reviewed Date:** June 09, 2022 **What do you like best about SingleStore?** We can handle large dataset analysis. Singlestore provides us with the capability to do so at incredible speed. I can confidently say that organizations should move to SingleStore database. Also provides the facility for heterogeneous databases connectivity. **What do you dislike about SingleStore?** I had some issues with configuration and docker that took too much time to create an environment, but customer support helped me through it. But it's really great after that. **Recommendations to others considering SingleStore:** SingleStore should have some certifications like Microsoft Azure, IBM, etc so that developers can be able able to pass that and upgrade their profile also. **What problems is SingleStore solving and how is that benefiting you?** SingleStore’s unified database facilitates fast-paced analytics for organizations looking to embrace diverse data and accelerate their innovations. SingleStore is currently the only database in the industry that addresses both analytical and transactional workloads for the multi-cloud world. ### 14. Very user-friendly, high-performance data analytics solution **Rating:** 5.0/5.0 stars **Reviewed by:** Ruslan S. | Solutions Architect & Consultant, Small-Business (50 or fewer emp.) **Reviewed Date:** April 12, 2022 **What do you like best about SingleStore?** The onboarding experience and how easy it is to get started. As someone who works with many clients, I particularly liked the ability (and ease) to quickly spin up a temporary database and ingest a large amount of data to run queries against. This is extremely useful for short-term (several days to 2 weeks) analytics projects. The logistics of setting up a new database are night & day in comparison to using RDS. **What do you dislike about SingleStore?** "Dislike" is a strong term. After my initial experience with the product, there wasn't anything I particularly disliked, but here are some notes on how I think the user experience could be made better: - It would be good to get the real time status of a pipeline; when I was running the test data import, the row count of the table kept changing every few seconds as more data was loaded. There was no real way to know when the entire set finished importing. On this note, it would be great to have a general view of all the queries that are currently running in the database, and their progress. This would come in particularly useful when building applications that run analytics workloads and debugging those applications. - (UX improvement) support for multiple SQL editor tabs in the web front end would be great, especially considering that the web interface appears to be designed to be the primary method for humans to interact with the database. **What problems is SingleStore solving and how is that benefiting you?** There is a multitude of scenarios where this tooling would be very helpful. Particularly -- read-only queries against massive datasets (for example: if this tool existed five years ago, it would have saved us months of custom PostgreSQL optimization that we had to do and would have likely worked out-of-the-box for what we needed). ### 15. SingleStore Performance **Rating:** 5.0/5.0 stars **Reviewed by:** Muhammad T. | Specialist DevOps Engineer (Commercial), Enterprise (> 1000 emp.) **Reviewed Date:** May 10, 2022 **What do you like best about SingleStore?** SingleStore is a really awesome and fast technology. Its fast-loading and fast data retrieval won my heart. It supports multiple sources just like CSV, JSON, and so on. **What do you dislike about SingleStore?** As a new user, it was a bit difficult to understand, but it became more and more logical over time. it took me almost an hour to understand all the functionality. But upon grasping the SingleStore UI, I realized how powerful it is! Also, I recommend checking out this Getting Started on SingleStore tutorial video: https://www.youtube.com/watch?v=bIFrJJkUftA **What problems is SingleStore solving and how is that benefiting you?** The basic problem of data loading was solved by SingleStore service. Raw Data loading takes a lot of time after which I need to transform the loaded data. SingleStore made my job easier, what I used to do in a day, now I can do it in a few minutes ### 16. Excellent platform for the data storage. **Rating:** 4.5/5.0 stars **Reviewed by:** f158095 M. | Data Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** July 12, 2022 **What do you like best about SingleStore?** The concept of the database was excellent to store a large amount of data in an online database provider. Highly recommended for new users or firms to adopt this platform **What do you dislike about SingleStore?** The performance was not very good but still is better than other databases, when you deal with different other databases. So performance should be improved in the future. **What problems is SingleStore solving and how is that benefiting you?** When you deal with a large amount of data or big data, the databases mostly do not support such big data or cause low-performance issues, and sometimes for very big data, you need to store it on different servers so SingleStore is solving this problem. ### 17. Credible Performance - OLTP and OLAP Database in One Shot **Rating:** 5.0/5.0 stars **Reviewed by:** Jerry O. | Principal Data Architect, Small-Business (50 or fewer emp.) **Reviewed Date:** June 11, 2022 **What do you like best about SingleStore?** My first experience with SingleStore was exceptional. I didn't need any documents or someone to guide me on how to use SingleStore. The user interface was very friendly and easy to navigate. Scaling up and down the cluster was very fast. I would commend SingleStore team on how they were able to lower network latency moving data across different cloud providers and were able to achieve credible performance. **What do you dislike about SingleStore?** I would have loved SingleStore to logically group tables, views, and similar objects in a schema adopting the Database >> Schema >> Table logical structure. **What problems is SingleStore solving and how is that benefiting you?** SingleStore is bringing Transactional and Analytical datastore into one database. This feature has helped my clients in reducing costs and providing near real-time analytics. ### 18. SingleStore Advantage **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Telecommunications | Small-Business (50 or fewer emp.) **Reviewed Date:** May 16, 2022 **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." **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. **What problems is SingleStore solving and how is that benefiting you?** Concurrent loading and analytics ### 19. 10X faster than MySQL, Postgres, Oracle and 1/4 the cost **Rating:** 5.0/5.0 stars **Reviewed by:** Sumit D. | Senior Data Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** July 22, 2022 **What do you like best about SingleStore?** Below are the advantages of Singlestore over some of the relational databases which i have worked with for over 10 years - Mysql - singlestore is super fast compared to this and infrastructure upgrades are no more a pain here due to Devops enabled for rapid deployment postgresql - singlestore has Better Performance due to the possibility of running highly concurrent workloads. Also real time insights are possible in singlestore Oracle - singlestore is 10*faster than oracle and also is 1/4th cost of oracle **What do you dislike about SingleStore?** Nothing as of now to be very honest but would share if I find any in coming days. **What problems is SingleStore solving and how is that benefiting you?** SingleStore is helping in creating the data pipeline and then making it super fast behind the scene which would definitely help the business where wait time is minimal . ### 20. For large-scale, data-intensive, always-on, data problems, I don't think you can beat SingleStore. **Rating:** 4.5/5.0 stars **Reviewed by:** Tyler M. | Freelance Solution Architect and Data Analyst, Small-Business (50 or fewer emp.) **Reviewed Date:** June 13, 2022 **What do you like best about SingleStore?** It is a "Ferrari" of a database. The native pipeline / ingestion is ultra-fast. I have worked with Oracle RDB, MySQL, IBM DB2.0, and PostGRES; nothing comes close to SingleStore for throughput for data ingestion. Writing vanilla / brute force queries also exceeded my expectations. With any distributed data you can ruin performance with cross-node joins, so with well planned partitioning and key design I expect performance would be lightning fast. That said, simplistic, brute-force query performance was very impressive highlighting the power of the SQL Engine. The horizontal scaling / Cluster Management is very nice, by far the easiest cluster management I've experienced. **What do you dislike about SingleStore?** I worry about the cost of intermittent work-loads. It seems like the cluster is always on, burning credits at full gas. So if work-loads are intermittent, the cost of idle time would be very high. Like any database, you'll get the best performance if you play to it's strengths, so in order to achieve that peak performance, you need to understand the impact a distributed (clustered) databases will have on your data architecture and data design. Which is not too difficult, just a reminder to avoid putting square pegs in round holes. **Recommendations to others considering SingleStore:** If you fall into the large-scale, data-intensive, always-on, managed service problem space, I don't think you can beat SingleStore. Like any database, you'll get the best performance if you play to it's strengths, so in order to achieve that peak performance, you need to understand the impact a distributed (clustered) databases will have on your data architecture and data design. Which is not too difficult, just a reminder to avoid putting square pegs in round holes. If you are dealing with huge volume and need a highly available database with superb performance, pick SingleStore - It is excellent at what it does. **What problems is SingleStore solving and how is that benefiting you?** If you are dealing with huge volume and need a highly available database with superb performance, pick SingleStore - It is excellent at what it does -- Ingestion throughput, overall speed of database, and the ease of horizontal scaling. I am freelance solution architect so I wanted to experiment to have some first-hand knowledge of the platform. ### 21. Streamlined cloud storage integration and user friendly query based software **Rating:** 5.0/5.0 stars **Reviewed by:** Samvida P. | Software Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** March 28, 2022 **What do you like best about SingleStore?** 1. Pipeline that directly fetched data from cloud store 2. Syntax for the pipeline was very concise and straightforward 3. Each output tab remains open with query output so that can be revisited easily as required 4. Very user friendly interface 5. Sign up and cluster creation process was smooth and streamlined 6. Tutorial for the process was adequately descriptive with the right amount of engagement in terms of the tone and language of the content provided **What do you dislike about SingleStore?** 1. Cancel button to terminate query during execution was hard to find 2. Output tabs like 'database created successfully' and 'table created successfully' will not need to be viewed again, hence these tabs need not be kept open once viewed. Right now we can manually close but if for selective outputs we can have one time view output tabs, that will be great **Recommendations to others considering SingleStore:** SingleStore revolutionizes how we imagine relational databases. Their multi-cloud support is unparalleled and user interface is friendly and incisive. **What problems is SingleStore solving and how is that benefiting you?** 1. To handshake with cloud store programmatically is tedious and requires a lot of code. Once configured successfully, SingleStore was able to retrieve data with ease 2. Cluster was provisioned with incisive parameters to be entered by me without adding any extra layer of complexity, which enhanced my user experience 3. SingleStore seems to be a one stop tool that offers compatibility with an extended range of cloud stores, thus diversifying scope of one's project without the need for store endpoint specific programming 4. The user interface is very friendly, which makes it easier to educate people with semi technical roles(client reporting team, etc) on using SingleStore to better understand and report the use case of a project. ### 22. Blazing fast SingleStore for data intensive work **Rating:** 4.5/5.0 stars **Reviewed by:** BHAVIN J. | Data Consultant and Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** May 16, 2022 **What do you like best about SingleStore?** Overall I had swift experience with the platform, starting from configuration to data ingestion, which was so straightforward with minimal efforts for the entire operation and that scaled up so fast. The real-time process for the nodes was really helped in the estimation n required instances for computing the huge data I believe the most amazing thing is it does not require high technical expertise to work with the SingleStore platform it does all complex tasks for us. Based on past work experiences of investing in an intense amount of configuring the infrastructure for massive compute resources, would recommend the single store platform to sure give a shot in the future use cases. SingleStore has a pay as you use. this is quite a great feature for the customers who need to perform data-intensive tas for one time or are required to process huge data, mostly preferred to utilize for peak hours. The supporting team is Proactive, and that's so astonished when serving the customers. in nutshell, the SingleStore is really great platform for any fast pace business requirements and awesome customer support. **What do you dislike about SingleStore?** So far I don't have a dislikeable point, but one thing that can be improved upon on Data Visualization for estimation, computing cost, forecasting, etc. Also Nice to have a BI product or integration in the same manner, simple, and created in a few clicks, imagine that real-time analytics for common business problems, etc **Recommendations to others considering SingleStore:** Fantastic platform to handle humongous data and setup in a minute, and a Proactive support team **What problems is SingleStore solving and how is that benefiting you?** To solve ad-hock business requirements to process huge data for analysis and decision making and a SingleStore makes life easy, with its platform to handle such a task, it is also easy and fast to configure, and spin up at any scale ### 23. Exciting and Easy to Use Product **Rating:** 5.0/5.0 stars **Reviewed by:** Scott C. | Owner / Software Consultant, Small-Business (50 or fewer emp.) **Reviewed Date:** June 03, 2022 **What do you like best about SingleStore?** The user interface was intuitive and very easy to use. I found it very easy to get up and running quickly. This product takes a lot of the complexity out of the system setup. Much easy to work with than a similar product like Hadoop with Hive. **What do you dislike about SingleStore?** I had issues getting the cluster up and running. I was getting API errors during setup and also had the cluster creation hang a couple times. I had to delete and retry creating the cluster until it worked. Just need to work the bugs out. All minor issues that I was able to work around. **What problems is SingleStore solving and how is that benefiting you?** SingleStore is a good solution for your Data Warehouses. It is fast when importing data and querying. No indexes required! You can choose how much processing power to setup for your cluster which is very helpful. ### 24. Outstanding Data Platform **Rating:** 5.0/5.0 stars **Reviewed by:** Cris R. | Co-Founder & CTO, Small-Business (50 or fewer emp.) **Reviewed Date:** April 08, 2022 **What do you like best about SingleStore?** - Extremely easy to set up and there are no issues with local dev. environments since it is in the cloud. - It is highly responsive with connecting to data and queries. - When I ran into a problem the live chat was very quick to assist me in moving forward. **What do you dislike about SingleStore?** There were a few UX issues I had around the queries and the output of results into numerous tabs, but it seems like those are being addressed by their development team so I hope to see those changes reflected in future releases. **What problems is SingleStore solving and how is that benefiting you?** For our organization, we are really just assessing what makes the most sense for our distributed software solutions and the storage behind them. SingleStore so far seems like a viable solution in the storage area. ### 25. A high performance tool **Rating:** 4.5/5.0 stars **Reviewed by:** Bryan G. | Senior Full-Stack Software Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** May 18, 2022 **What do you like best about SingleStore?** The load performance! I have used other tools in my projects and the delay that was caused due to the data load had a huge impact on the data migration and the project itself. **What do you dislike about SingleStore?** Some documentation (videos_ are not up to date, there are still references to the former tool MemSQL which may confuse, but this is compensated with the great customer service. **What problems is SingleStore solving and how is that benefiting you?** Data migrations in general, we can use this tool as the end solution or as a middle stage in the ETL. Since the data can be loaded fast, it helps us to find data issues quicker ### 26. Works great! It is incredibly speedy for data migration tasks, and incredibly user-friendly :) **Rating:** 5.0/5.0 stars **Reviewed by:** Rex E. | Product Manager, Small-Business (50 or fewer emp.) **Reviewed Date:** April 22, 2022 **What do you like best about SingleStore?** The speed of the queries/ the ease of use! The SQL query editor works perfectly and has great error logs **What do you dislike about SingleStore?** I was confused about the profiling feature, why it could not show me in real-time the resources being used ” which I’ve shared with our team to add to our Roadmap / checklist of planned upgrades **Recommendations to others considering SingleStore:** If you need to collect large amounts of data in a fast and efficient manner, then SingleStore does a great job! **What problems is SingleStore solving and how is that benefiting you?** It helped me with data migration and simple data extraction in record time. I can now complete large queries much faster than before, and free up my time this way! ### 27. Review regarding the UI and functionality **Rating:** 5.0/5.0 stars **Reviewed by:** Muhammmad A. | Database Administrator, Mid-Market (51-1000 emp.) **Reviewed Date:** March 24, 2022 **What do you like best about SingleStore?** The simplest and easy way to create pipeline. **What do you dislike about SingleStore?** I would like you to have more UI friendly and whenever I execute query it should have an option to appear in bottom window area. Also I would like to know how many rows got inserted, updated and deleted when I execute DML. I would like to have info about indices on the tables. I would also have a way of creating a pipeline in the opposite direction or export data to S3 bucket to have two ways experience in different format. **Recommendations to others considering SingleStore:** SingleStore is easy to setup, easy to create data pipeline, easy to administer and efficient to retrieve data from even if you are using complex aggregation **What problems is SingleStore solving and how is that benefiting you?** I would say the ingestion and searching and the easiness of creating pipeline is the beauty of this product. This product I would say more solving analytical problems but still I experience some slowness with complex aggregate ### 28. Exceptionally fast system with minimal changes to existing workflow or development staff training **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Financial Services | Small-Business (50 or fewer emp.) **Reviewed Date:** June 03, 2022 **What do you like best about SingleStore?** 1) Blazing fast speed performance .Improvements in query times, between 30 to 100 times considering almost zero changes in workflow, or training new developer skills. Rather than managing the cluster ourself, it helps us offload the work of keeping the cluster optimum. 2)Easy to Deploy anywhere with minimal workflow changes or developer upskilling 3) Easy of Integrate with Standard APIs/tools/ Kafka for direct streaming to table setup 4) Efficient Row storage and column storage features **What do you dislike about SingleStore?** No dislikes as such really at this point of time and amount of usage. Guess it might need some time to figure out how to most effectively use all the features and the system design to its best. **What problems is SingleStore solving and how is that benefiting you?** Improvements in query times, between 30 to 100 times considering almost zero changes in workflow, or training new developer skills. Rather than managing the cluster ourself, it helps us offload the work of keeping the cluster optimum. Its a suitable option for replacement of our existing db system. ### 29. Fast Analytics Database **Rating:** 4.5/5.0 stars **Reviewed by:** Udit S. | Software Engineer - SQL, Small-Business (50 or fewer emp.) **Reviewed Date:** March 16, 2022 **What do you like best about SingleStore?** I very much liked the overall experience right from the cluster setup to executing queries and getting results. It is very smooth and user-friendly. I liked the performance of ingesting data from s3 bucket using the pipeline concept which is very interesting. Queries with only where conditions are working very fast without any indexing which is impressive. Monitoring tools are also very helpful to DBAs/Developers who need to manage multiple instances of databases. **What do you dislike about SingleStore?** The performance of the aggregation queries can be improved. I have tested this with the default cluster as mentioned in the documents. One query that took a very long time is: "find out which holiday has the most activity" which is around 1.12 mins. **What problems is SingleStore solving and how is that benefiting you?** This product can be very helpful to people who have large amounts of data and needs to generate insights out of it quickly. It can be very helpful in the Finance, Taxation domain for analysis. It is very easy to setup and get going which means lesser administrative overhead. The product has a good IDE for SQL development. ### 30. SingleStore is a great solution to help build data-intensive, cloud-based applications. **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Real Estate | Mid-Market (51-1000 emp.) **Reviewed Date:** May 24, 2022 **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. **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. **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. ### 31. SingleStore is easy to use and works faster **Rating:** 5.0/5.0 stars **Reviewed by:** Mama P. | Independent Data/Cloud Consultant, Small-Business (50 or fewer emp.) **Reviewed Date:** June 16, 2022 **What do you like best about SingleStore?** SingleStore is easy to set up and use. Processes data quickly. Tutorial/Demo links are easy to follow.Used into load data from s3 to database tables. **What do you dislike about SingleStore?** Detailed pipeline log in UI itself is not available. But it is available in the database. **What problems is SingleStore solving and how is that benefiting you?** It will be helpful if a large amount of data needs to be loaded into a database for analysis or reporting purposes. ### 32. Amazing solution **Rating:** 4.0/5.0 stars **Reviewed by:** Carlos A. | Lead Data Developer, Enterprise (> 1000 emp.) **Reviewed Date:** July 10, 2022 **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. **What do you dislike about SingleStore?** The GUI is not so clear, sometimes is difficult to find some obvious thing like create a database **Recommendations to others considering SingleStore:** I really recommend for companies that it is starting to think in big data world. **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. ### 33. Fast and easy to use! **Rating:** 5.0/5.0 stars **Reviewed by:** Jason S. | Manager, Enterprise Implementations, Small-Business (50 or fewer emp.) **Reviewed Date:** April 27, 2022 **What do you like best about SingleStore?** Overall it was really simple to use and very fast. Obviously, it's a different use case but I tried the same tutorial in Snowflake and the data pipeline took ~2 minutes compared to just a few seconds in SingleStore. **What do you dislike about SingleStore?** Nothing at this time to note, the company definitely seems to b e going in the right direction! **What problems is SingleStore solving and how is that benefiting you?** Managing large volumes of data migrations without sacrificing speed and quality. SingleStore avoids clunky scripts and is also very easy to test and validate data accuracy. ### 34. Meet the fast processing data platform. **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Marketing and Advertising | Small-Business (50 or fewer emp.) **Reviewed Date:** March 21, 2022 **What do you like best about SingleStore?** I have tried SingleStore for data processing. The speed at which data gets processed from different pipelines is amazing. Millions of data were being transferred within seconds. And it is easy to get familiar with platform, it is friendly and accessible. **What do you dislike about SingleStore?** What the platform is missing is its own GUI to connect to their environment. Sometimes relying only in browser may be not the best way to use the product. Another disadvantage is that each query run opens a new tab of results which leads to browser memory utilization. **Recommendations to others considering SingleStore:** If you wish for fast data processing SingleStore should be your first choice on your selection. **What problems is SingleStore solving and how is that benefiting you?** I am new in SingleStore, now I am trying to get myself educated with its capabilities. We try to get insights from our data, and derive conclusion which might help our customers. ### 35. Great product for streaming data! **Rating:** 5.0/5.0 stars **Reviewed by:** Tom M. | Tech Lead, Small-Business (50 or fewer emp.) **Reviewed Date:** July 26, 2022 **What do you like best about SingleStore?** I really liked the concurrent read/write (faster) compared to the likes of MySQL/Postgres. The architecture, setup and usage remind me more of Snowflake which is something I am working on at the moment. I really like the autocomplete feature; something that Snowflake doesn't support at the moment. **What do you dislike about SingleStore?** Only the pricing seemed a bit too much, however, there are use cases where the need for data speed overweighs the cost factor. **What problems is SingleStore solving and how is that benefiting you?** Excellent concurrent read/write speed. ### 36. Amazon RDS Cluster is managed efficiently thanks to SingleStore DB **Rating:** 4.0/5.0 stars **Reviewed by:** Varshini S. | Database Engineer, Information Technology and Services, Enterprise (> 1000 emp.) **Reviewed Date:** December 07, 2021 **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. **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. **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. ### 37. SingleStore and Advantages **Rating:** 5.0/5.0 stars **Reviewed by:** Thelma O. | Data Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** April 27, 2022 **What do you like best about SingleStore?** SingleStore is a high performance system that works well with high volume of data. I used the system to process 100 billion rows of data in less than 30mins. I am really impressed by it **What do you dislike about SingleStore?** There is no downside that I have experienced **What problems is SingleStore solving and how is that benefiting you?** The problem I was trying to solve with SingleStore was processing a large volume of data in a very short time. I was able to achieve this in a good time ### 38. Awesome and Economical **Rating:** 5.0/5.0 stars **Reviewed by:** Hassan U. | Data Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** May 31, 2022 **What do you like best about SingleStore?** Its awesome to see GCP, AWS and Azure together and setting up the chosen Cloud service to singlestore. however, the singlestore has made it more easier and compact to choose service of your choice, Frontend of the (Daas) is also very catchy and professional. Over all the product is perfect. **What do you dislike about SingleStore?** Nothing identifiedby me, all i saw was a very productive solution to the big data problem. **What problems is SingleStore solving and how is that benefiting you?** I don't have knowledge about it, but my experience with single store wasmore than great, there smooth and catchy front-end and various data solutions at one place. ### 39. Managed Database Service With Quick Setup For Processing Large Volumes Of Data Easily **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Retail | Small-Business (50 or fewer emp.) **Reviewed Date:** April 18, 2022 **What do you like best about SingleStore?** 1. Good database service with quick setup and a good range of cloud providers and compute resource sizes to choose from. 2. Data import is easy from cloud storage layers like S3 using pipelines 3. Data load and query performance is quick. 4. The UI is clean and intuitive. 5. Data migration is made simple. For example, it is possible to offload data from RDS MySQL to S3 and then create new pipelines in SingleStore to automatically ingest the data. Data ingestion is done in seconds. In addition, it is possibility to easily load data from on-premise instances too using mysqldump. It even takes care of the table ddl generation. Since SS is compatible with MySQL data types, the table replication is very simple. **What do you dislike about SingleStore?** The UI only allows one SQL Editor tab at a time. It would be a great feature to be able to edit multiple sql scripts in the same time but in separate tabs. **What problems is SingleStore solving and how is that benefiting you?** Processing and analyzing large volumes of clickstream data ### 40. Efficient and Scalable Data Solution **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Food Production | Small-Business (50 or fewer emp.) **Reviewed Date:** May 05, 2022 **What do you like best about SingleStore?** I quite like the seemless integration with AWS. In just a couple of commands, I was able to pull in data from S3 into SQL and create a pipeline. The scalable parallel ingestion and live de-dupe mechanism is quite awesome. **What do you dislike about SingleStore?** I guess it would be pricing. I used S-16 cluster and exhausted $500 credit after finishing with 1billion rows load. But I think price vs performance compromise would exist in every solution. **Recommendations to others considering SingleStore:** If you have a scalable business or expect your business to have lots of data in the near future, it would be a very good idea to explore SingleStore's solution. As name suggests, its a single store database providing a consolidated solution for all the data at a super-fast speed. **What problems is SingleStore solving and how is that benefiting you?** Making real-time transactional data available for analytics without any lag. Improving data ingestion pipeline for large amount of data. ### 41. SingleStore is very fast! **Rating:** 5.0/5.0 stars **Reviewed by:** Khvicha M. | Database Developer, Enterprise (> 1000 emp.) **Reviewed Date:** April 30, 2022 **What do you like best about SingleStore?** Recommend trying the 100B Rows tutorial on #SingleStore database... portal is very very fast, works quickly with big data **What do you dislike about SingleStore?** Here is all good! singlestore Fast!! singlestore Easy!!! singlestore Comfortable!!! **Recommendations to others considering SingleStore:** I Recommended SingleStore! **What problems is SingleStore solving and how is that benefiting you?** here we can work with big data without any problems! ### 42. Amazing Capabilities with this Product **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Airlines/Aviation | Mid-Market (51-1000 emp.) **Reviewed Date:** July 21, 2022 **What do you like best about SingleStore?** What stood out for me was the speed in loading very large files within a short amount of minutes and also the usability of the platform; it is very easy and requires minimal learning curve to use. **What do you dislike about SingleStore?** For now it has to be the fact that it opens a new query result tab each time I perform a new query **What problems is SingleStore solving and how is that benefiting you?** That has to be development of databases that require a lot of data that has to be queried with the need of these results in a short time ### 43. SingleStore Review **Rating:** 5.0/5.0 stars **Reviewed by:** Ömer Z. | Founder, Small-Business (50 or fewer emp.) **Reviewed Date:** May 12, 2022 **What do you like best about SingleStore?** Easy to use, well documented. Easily I can create my workspace without any research or course. Great monitorin tool,you can observe all processes with details. Fast download, upload reate **What do you dislike about SingleStore?** I am used to "create new" buttons but in some processes, i couldn't find. Query Editor always opens new result window. Periodically it is better to close some windows. **What problems is SingleStore solving and how is that benefiting you?** I uploaded 1M rows to test rates. It is really fast and run some select queries. deployment is easy and also fast. ### 44. SingleStore Fastest Database **Rating:** 4.5/5.0 stars **Reviewed by:** Sunil S. | Associate Director, Small-Business (50 or fewer emp.) **Reviewed Date:** February 23, 2022 **What do you like best about SingleStore?** Creating a pipeline is easy, and getting data from AWS. Data was coming fast. For 20 mil records, data came fast in DB, like in 5 min that is great. The speed of the query is fast. **What do you dislike about SingleStore?** I like everything about DB. It is excellent for future DB. **What problems is SingleStore solving and how is that benefiting you?** A pipeline is the best I can see it. That will resolve the problem from Azure ADF where you need pipelines. It will benefit to everyone as it will because fast process. ### 45. User Review - SingleStore **Rating:** 5.0/5.0 stars **Reviewed by:** Syed Muneeb H. | Lead Big Data Engineering & Governance, Mid-Market (51-1000 emp.) **Reviewed Date:** March 23, 2022 **What do you like best about SingleStore?** The fast and efficient query engine of SingleStore. It can process a big dataset very quickly. **What do you dislike about SingleStore?** Nothing as such. I was having some trouble finding out the execution plan of the query but found that as well. **What problems is SingleStore solving and how is that benefiting you?** I have a huge data volume and I am trying to join multiple tables with millions of rows. This can be done very quickly using SingleStore. ### 46. Super fast for real-time big data analytics **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Small-Business (50 or fewer emp.) **Reviewed Date:** July 21, 2022 **What do you like best about SingleStore?** Super fast in loading massive amounts of data automatically in such short period of time. The real time streaming feature can be used in many cases involving real time analytics. Easy to configure pipeline and to connect to front-end BI tool. **What do you dislike about SingleStore?** Limited sources from which data can be integrated. Takes lot of time deploying the cluster. **What problems is SingleStore solving and how is that benefiting you?** Analyzing real time logs saved in cloud data storage services; real time analysis of data present in this storage layers ### 47. Loads a billion rows a minute! **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Financial Services | Enterprise (> 1000 emp.) **Reviewed Date:** April 28, 2022 **What do you like best about SingleStore?** Calculating analytics on ever-larger datasets has been slowing us down and making us look outside SQL Server for answers. Options on AWS require massive re-engineering efforts. This solution seems very promising with it's lightning fast table loads and query execution times **What do you dislike about SingleStore?** Has a learning curve like any other product. Query tool is quite basic and at least on the surface lacked ability to script out tables, administration etc. Some guidance on choosing the correct cluster instance size might also help? **What problems is SingleStore solving and how is that benefiting you?** Calculate analytics as fast as possible... on data increasing by a TB every year...using SQL so we don't have to undertake a massive re-engineering effort. We have been looking into multiple options, this one looks promising. ### 48. Looks like a great product! **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Financial Services | Small-Business (50 or fewer emp.) **Reviewed Date:** April 14, 2022 **What do you like best about SingleStore?** The different connection offerings for loading data from multiple data sources including the easy to use built in connector. The speed out of the box without even adding sharding keys. The UI is clean and easy to work with. **What do you dislike about SingleStore?** Nothing so far. Would be interested to test more how the connector handles custom types during its automatic table creation. **What problems is SingleStore solving and how is that benefiting you?** Very easy to ingest data from multiple sources quickly. Increased performance on queries. Very flexible in terms of different cloud platform options. ### 49. Lightening fast Database with elegant UI **Rating:** 5.0/5.0 stars **Reviewed by:** Samiran M. | Senior Data Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** April 17, 2022 **What do you like best about SingleStore?** The mere speed of data load is what appealed the most i.e 2800000000 rows were loaded in less than a minute with what test case i had **What do you dislike about SingleStore?** As of now i did not find any downsides because the system has been well thought during design **Recommendations to others considering SingleStore:** Just explore it yourself to see the great product **What problems is SingleStore solving and how is that benefiting you?** The biggest problem is to loaded inter system data witn different formats. The most used place would be different ETL stages for Datawarehousing ### 50. The UI is awesome, so does the speed. **Rating:** 4.5/5.0 stars **Reviewed by:** Saif A. | QA Consultant, Small-Business (50 or fewer emp.) **Reviewed Date:** February 23, 2022 **What do you like best about SingleStore?** The UI is awesome, so does the speed. Another thing I am assuming is that it will be great for analytical scenarios and looks like it will have a great execution time for complex queries which have complex joins. **What do you dislike about SingleStore?** Well, I didn’t saw any dashboard for Deadlocks, debugging issues and performance monitoring etc. Just like how pgAdmin have. That’s why I will rate 4.8. **Recommendations to others considering SingleStore:** Awesome UI and fast execution time. **What problems is SingleStore solving and how is that benefiting you?** I’m currently developing my own E-Commerce platform, I’m currently using Amazon RDS free-tier on staging environment. Singlestore/MemSQL looks like a good option. ## 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?section=pricing&secure%5Bexpires_at%5D=2026-05-13+17%3A13%3A16+-0500&secure%5Bsession_id%5D=31580617-eda4-42a2-b96d-e6ade70ce0c3&secure%5Btoken%5D=ad088b46a7cf9f4703e33df3eb3b9e93bc10a66514abb44b0b170b0c21b12f23&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 (643 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,574 reviews)