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.
-
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
-
Difficulty with complex queries and documentation: Some users have reported difficulties with executing complex queries and a lack of detailed documentation
-
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
