What is Singlestore?
Pros from reviewers
-
Seamless integration: The software integrates well with AWS and other services, making it ideal for users who heavily use multi-petabyte S3 and large Kafka clusters
-
Easy to use: SingleStore is user-friendly and can be set up quickly, allowing for the creation of a customer-facing streaming analytics data store in a short period of time
-
High performance: SingleStore provides sub-second responses even with heavy API calls, scanning billions of rows across numerous tables and applying RBAC functionalities instantly
-
Scalability: SingleStore is a distributed database that can be scaled out, unlike some fixed, vendor-maintained appliances, making it suitable for managing large data sets
-
Compatibility: SingleStore is API-compatible with the MySQL dialect, allowing users to use MySQL-targeted tools to query data on SingleStore.
Cons from reviewers
-
Poor customer support: Some users have reported dissatisfaction with the customer support, finding it difficult to get on-call representative support even for high priority issues.
-
Difficulty with complex queries and documentation: Some users have reported difficulties with executing complex queries and a lack of detailed documentation
-
Absence of certain features: Some users have noted the absence of a dedicated client interface, built-in data modeling capabilities, and a superior front end to assist developers
-
Lack of maturity: Despite its impressive features, SingleStore is not fully mature and lacks some administrative functions such as incremental, point-in-time, and object-specific backups and restore
-
High cost for self-hosted solutions: Implementing a backup on a self-hosted solution can be challenging due to the need to backup large amounts of data, making it a costly option
Main features
Starting Price
Free Plan
High-Performance
Unified Architecture
Reliability Features
Versatile Deployment
Scalability
Starting Price
N/A
Free Plan
No
High-Performance
Unified Architecture
Reliability Features
Versatile Deployment
Scalability
How Singlestore compare to similar software?
Product
Price
N/A
Free plan
No
Main features
Pros
Cons
Alternatives
Deal
No available deal at the moment
Who is Singlestore best for according to our reviewers?
Data Analysts: Professionals who need to analyze large data sets and require real-time analytics. SingleStore's speed and scalability make it an excellent choice for this group
Database Administrators: Database administrators who are frustrated with the cost and learning curve of other databases would appreciate SingleStore's ease of use, impressive speed, and suitability for real-time applications. The software's unique transformation capabilities in the LOAD command and the ability to capture errors and rejects are incredibly helpful
Data Warehouse Developers: Those working on developing data warehouses can benefit from SingleStore's distributed database that runs on commodity hardware and can be scaled out. Its Columnstore feature is particularly valuable for this group
IT Managers: IT managers looking for a reliable database engine for both online transaction processing and data warehousing would find SingleStore's robustness and impressive speed beneficial. The software's API compatibility with MySQL dialect is an added advantage
IoT Data Analysts: Professionals who need to query large volumes of IoT data would find SingleStore's impressive performance and scalability beneficial. The software's ANSI and PL SQL compatibility make the transition from traditional databases easier.
Singlestore Reviews
4.5
Singlestore rating
4.5
Ease of use
4.5
Customer service
4.2
Value for money
4.4
Likelihood to recommend
4.5
Features
20 Singlestore Reviews
-
Linda Johnson
Solid In-Memory Database, Yet Customer Support Falls Short
Overall, I appreciate SingleStore's products, but I find some key features lacking. I'm particularly impressed by its dual function as an In-memory DB and Relational DB, a feature not common in most In-Memory products. The query response times are also praiseworthy. However, I'm dissatisfied with the customer support, as it's difficult to get on-call representative support even for PROD-Sev1 issues. I also noticed the absence of two-way DB replication for DataCenters. I chose SingleStore mainly for its In-memory Relational DB feature, which was also the reason I switched to it. In response to my concerns, the vendor asked me to contact community@memsql.com to discuss my support experience and escalate my concerns for improved future service. I received this response in October 2019.
August 18, 2024
-
Matthew
Top-tier In-Memory SQL Solution on the Market
MemSQL has greatly simplified my data lake system, allowing me to extract significant business value. I can now query large volumes of IOT data, trillions of rows, in milliseconds. Business databases that used to take hours to run on similar hardware now operate sub-second on MemSQL. The transition was challenging, but MemSQL provided support throughout. The software delivers impressive performance, ANSI and PL SQL compatibility, making the transition from traditional databases easier. It's highly scalable, easy to set up and use, and provides excellent support. However, it currently lacks incremental backups, failback of replications, transaction logging, and recoverable snapshots. These features are expected to be added soon. I chose SingleStore for its simplicity, legacy compatibility, and performance. The main reason for switching to SingleStore was its superior performance.
August 10, 2024
-
Roger Brown
Lightning Speed with SingleStore
I appreciate SingleStore for its impressive speed and suitability for real-time applications. However, I encountered confusion with the documentation regarding what is stored in memory and what on disk. Despite configuring all our tables to be on disk, we faced numerous usage alerts that were time-consuming to resolve. We transitioned to SingleStore for its quicker reads, aggregates, and the capability to query on a rolling index.
August 4, 2024
-
Jordan Jones
Commendable Ease of Use with SingleStore
The ease of use of SingleStore is commendable. Even with minimal technical knowledge, I was able to navigate through the software with ease
July 28, 2024
-
Terry Rodriguez
SingleStore's Seamless Scalability
I am particularly impressed with SingleStore's scalability. As our data grew, the software seamlessly scaled to meet our needs without compromising on performance
July 20, 2024
-
Timothy Rodriguez
Superior Hadoop Alternative at a Fraction of the Cost
I needed a solution to aggregate stats from my real-time bidding logs. Previously, I used Hadoop Hive which took over 2 hours to complete the task. However, after switching to MemSQL, now known as SingleStore, I was able to finish the aggregation within 20 minutes. The deployment process was quick and painless, and it integrated well with my existing SQL-based data pipelines. I replaced my expensive and difficult-to-maintain Hadoop cluster with SingleStore at a fraction of the cost. I did face some stability issues initially, but the support team was proactive in addressing these and provided fixes in later releases. Synchronizing with an external MySQL meta-database was not straightforward, so I had to create custom synchronization scripts. I switched to SingleStore mainly due to the high cost of maintaining a Hadoop cluster with 2 devops engineers. The vendor was pleased with the exceptional performance I was getting.
July 16, 2024
-
Carolyn Davis
Impressive High Availability: Ensuring Uninterrupted Data Access with SingleStore
The high availability feature of SingleStore is impressive. It ensures that our data is always accessible, even in the event of a system failure
July 6, 2024
-
Scott Johnson
SingleStore: Revolutionizing Data Processing for Our Organization
SingleStore has been a game-changer for our organization. Its ability to process large amounts of data in real-time has significantly improved our operational efficiency
July 2, 2024
-
Julia Martinez
Unmatched Speed and Efficiency with Real-Time Analytics
its speed and efficiency are unparalleled. The real-time analytics feature has been instrumental in helping me make quick, data-driven decisions
June 24, 2024
-
Harold Jones
Effortless Data Management: SingleStore's Cloud-Native Capabilities
SingleStore's cloud-native capabilities have made data management a breeze for us. We can now access our data anytime, anywhere
June 17, 2024
-
Doris B
Exceptional Customer Support at SingleStore: Swift and Helpful Assistance
The customer support team at SingleStore is top-notch. They are always available to assist and their responses are swift and helpful
June 11, 2024
-
Kenneth Miller
Powerful, Reliable, and Speedy Database Engine
I use SingleStore as my main database engine for both online transaction processing and data warehousing. It's proven to be a reliable engine with great performance and many useful features. SingleStore is a strong relational database management system that provides impressive speed and robustness. It has unique features that make it effective for data consumption and processing. It's also API-compatible with the MySQL dialect, which lets me use MySQL-targeted tools to query data on SingleStore. Although it's not the cheapest engine, I think its cost-value ratio is fair. However, implementing a backup on a self-hosted solution can be difficult due to the need to backup large amounts of data.
June 4, 2024
-
Beverly R
SingleStore: Awaiting Enterprise-Level Maturity
As an AI, I don't have personal experiences, but I can summarize the review in the first person perspective: "I find SingleStore to be an impressive software. It's highly efficient and provides real-time analytics. The scalability and speed of data processing are remarkable. However, I encountered some difficulties with complex queries and the lack of detailed documentation. Overall, it's a powerful tool for managing and analyzing large data sets."
May 25, 2024
-
Catherine R
Exceptional Service and Delivery by Singlestore
I was genuinely impressed with what Singlestore delivered and how they managed our account. I felt that they gave us the right amount of attention and were focused on our needs.
May 19, 2024
-
Helen
Seamless Integration: SingleStore's Excellent Capabilities
Lastly, the integration capabilities of SingleStore are excellent. We were able to integrate it with our existing systems without any hitches.
May 12, 2024
-
Jose Garcia
Exploring SingleStore's Requested Features: A First-Timer's Experience
This review was incentivized by SingleStore, who compensated me to test features like Kafka integration, ingestion, and migration. They requested an honest review after a few hours of usage and a one-hour seminar. Therefore, my experience with the tool is limited and this review reflects my initial impressions. I was struck by the overall simplicity of the software. The guides were user-friendly and the documentation was clear. I attempted to find errors in some areas, but for example, the system doesn't reveal the password when I request it to echo back the Kafka connection details I established, which could have been a security concern. However, they were evidently aware of this and made sure it wasn't possible. I especially appreciated the extremely fast ingestion speed and the simplicity of setting up a Kafka linked table. However, I encountered some problems with the support. Despite the chat being prompt and effective, I had difficulty explaining that I wanted a copy of the "Replicate.
May 7, 2024
-
Raymond Brown
Peace of Mind: SingleStore's Strong Security Measures
I appreciate the security measures put in place by SingleStore. Knowing that our sensitive data is secure gives us peace of mind
April 28, 2024
-
Julie Williams
Exploring MemSQL: A Journey into Enterprise Data Lakes
I primarily use MemSQL, now known as SingleStore, for an enterprise data lake, which also doubles as a staging area for MemSQL data warehouses. These are currently under development and not yet in production. Overall, I am satisfied with the product and the development process is going well. I appreciate that SingleStore is a distributed database that runs on commodity hardware and can be scaled out, unlike some fixed, vendor-maintained appliances like Teradata. I find the Columnstore feature particularly valuable. However, the product is not fully mature. Despite using the MySQL protocol, it doesn't always work with MySQL-compliant products. Some administrative functions such as incremental, point-in-time, and object-specific backups and restore are lacking. Although SingleStore is making progress in these areas, there is still room for improvement. I chose SingleStore over NoSQL products like Hadoop because I wanted to leverage my existing SQL skillset. I'm not completely switching from Teradata, but I plan to use it less and SingleStore more due to frustrations.
April 23, 2024
-
Christopher Williams
Supersonic DB - Exceptional Performance
I would give SingleStore a full star rating. Having worked with nearly all databases, I can confidently say it outperforms all others I've used. Its unique transformation capabilities in the LOAD command and the ability to capture errors and rejects are incredibly helpful. It's extremely fast and poses serious competition to other databases. It's a next-generation database with great potential for both on-premise and cloud use. Its high compatibility, resilience, and scalability are fantastic features. I highly recommend it to any organization looking to upgrade from outdated databases. While I don't have any specific dislikes, I would appreciate a dedicated client interface, built-in data modeling capabilities, and a superior front end to assist developers from day one. I would also like to see a proper blogging web portal to help developers resolve their queries and issues more quickly. I switched to SingleStore because other options were too expensive and difficult for developers to learn.
April 16, 2024
-
Willa S
SingleStore: Excellent Data Management Software
I have been using SingleStore for a while now and I must say, it's an excellent software for managing data
April 14, 2024