About SingleStore
SingleStore is a database management solution that helps businesses ingest, analyze, store, deploy, manage, secure, and integrate data across systems. It allows administrators to manage data in various formats including relational SQL, geospatial, full-text search, and JSON.
It provides a variety of features including data lake pipelines, workload management, multi-statement transactions, deployment management, performance monitoring, and more. It provides cluster management capabilities, which lets users automate start, stop, restore and back up processes related to clusters. SingleStore provides security tools, which allow businesses to implement role-based access control based on roles and groups and authenticate account access using PAM (Pluggable Authentication Module) and SAML.
Pricing starting from:
N/A
- Free Version
- Free Trial
- Subscription
Top 5 alternatives to SingleStore
Devices
Business size
Markets
United States
Supported Languages
English
Pricing starting from:
N/A
- Free Version
- Free Trial
- Subscription
Top 5 alternatives to SingleStore
Images
No images available
Features
Total features of SingleStore: 19
Alternatives
Apache Cassandra
MongoDB
Couchbase Server
PostgreSQL
Reviews
Already have SingleStore?
Software buyers need your help! Product reviews help the rest of us make great decisions.
Write a Review!
- Industry: Computer & Network Security
- Company size: 501-1,000 Employees
- Used Daily for 1+ year
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 10.0 /10
Checked - One solution for Streaming Analytics on Big Data
Reviewed on 27/12/2019
Pros
- Super simple, we implemented the whole of our customer-facing streaming analytics data store in a 2-day hackathon
- Natively integrates with AWS & other services (we are a multi-petabyte S3 shop with huge Kafka clusters)
- Since most of it is SQL, anyone can hit the ground running in no-time, an ultra-low barrier to entry
- We saw a sub-second response on a test case with 1000 concurrent heavy API calls (scanning billions of rows across many tables + window functions etc) along with applying RBAC functionalities on the fly
- Incredibly fast out of the box, basic performance tuning will suffice 95% of use cases
- Fantastic partners to work with, super helpful, we have access to their core engineering team, +100 on Customer engagement!
Cons
In my humble opinion, it solved a very unique hard problem for us elegantly (without having to compromise on any architectural or data principles). Problem of streaming analytics on high-velocity high volume data sets with sub-second API responses can be a handful. For me, this along with other use-cases they mention is their core strength. So anything beyond these capabilities is a "Nice to have" for me. Their roadmap covers most of what the community is asking - hot back-up's, better UI, modelling etc.
- Industry: Utilities
- Company size: 10,000+ Employees
- Used Daily for 1+ year
-
Review Source
Overall rating
- Ease of Use
- Customer Support
- Likelihood to recommend 9.0 /10
Thoughts on MemSQL
Reviewed on 18/10/2019
Our primary use case for MemSQL is an enterprise data lake, which will also serve as a staging area...
Our primary use case for MemSQL is an enterprise data lake, which will also serve as a staging area for MemSQL data warehouses. They are currently being developed and are not in production yet. We're learning things as we go, but in general, development is going well and we're satisfied with the product.
Pros
I appreciate that MemSQL is a distributed database that runs on commodity hardware and can be scaled out as opposed to some fixed, vendor-maintained appliances like Teradata. Columnstore is a valuable feature.
Cons
The product is not fully mature. Although it uses the MySQL protocol, it does not always work with MySQL-compliant products. Some administrative functions such as incremental, point-in-time, and object-specific backups and restore are lacking. MemSQL is making progress in these areas, but it still has room to grow.
Response from MemSQL
Thanks for your feedback. We work hard every day to close any feature gaps between MemSQL and the older, legacy databases. Incremental Backup lands in version 7.0, and point-in-time restore is being actively developed, and is slated to land next year.
- Industry: Information Technology & Services
- Company size: Self Employed
- Used Monthly for Free Trial
-
Review Source
Overall rating
- Ease of Use
- Customer Support
- Likelihood to recommend 7.0 /10
A review of few features requested by SingleStore
Reviewed on 26/04/2022
Note: This review was incentivized by SingleStore. I was paid to test few features, such as: Kafka...
Note: This review was incentivized by SingleStore. I was paid to test few features, such as: Kafka integration, Ingestion and migration features. I was requested to write an honest review here after few hours and a 1 hour seminar. Therefore I do not have any significant experience with the tool, and this is like a newcomer's first experience review.
Pros
I loved the simplicity in general. It was easy to use the guides, and to follow the documentations I encountered. In some cases I dug a bit deeper just to try to find some mistakes, but for example the password is not displayed if I request the system to echo back the Kafka connection details I set up. It could have been a security issue, but they were obviously aware of this and they made sure it is not possible.
The specific things I liked is the ingestion speed is lightning fast. And to set up a Kafka linked table (real time message data in a table!) is as easy as it can possibly be.
Cons
The support. The chat is although quick and efficient, I had no issue to explain that I want a copy of the "Replicate" tool, to do similar actions that was shown on a video. The agent confirmed he understood correctly what I said, and that he needs to escalate this as I was a trial user. But of course given I was hired by them they will probably make an exception.
But I was shocked that a week later I got a very generic reply and a link to an unrelated page. Like only the higher topic was understood, and all my request to have a copy of the Replicate tool was lost.
I reported my disappointment towards SingleStore, and after all they are working on improving this mow. It is uncomfortable to leave this story here but necessary to understand I believe that with Support you can have hiccups and you might need to repeat yourself.
- Industry: Financial Services
- Company size: 10,000+ Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 3.0 /10
MemSQL : Needs Time to Mature
Reviewed on 10/09/2019
This is a good software but needs to mature more for an enterprise level
This is a good software but needs to mature more for an enterprise level
Pros
Similar to existing RDBMS
Supports join
In Box implementation with Spark
Salable & manageable with memSQL ops
Cons
Security Features
Consistency
Overflow on Disk
Alternatives Considered
Apache CassandraReasons for Choosing SingleStore
Scalability & Growing CostReasons for Switching to SingleStore
Cost & future roadmap- Industry: Telecommunications
- Company size: 11-50 Employees
- Used Daily for Free Trial
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 10.0 /10
SingleStore Data Performance
Reviewed on 26/04/2022
SingleStore is much useful for Real-Time data Analytic and Reporting feature and that is the key...
SingleStore is much useful for Real-Time data Analytic and Reporting feature and that is the key feature we looking towards Relational Database For local testing it is considerable that it consume too much memory consumption and that area is need to be improved to bring best out of it towards developer point of view.
Pros
It has faster query result in RDBMS platform along with high availability with the possibilities of loading data from different sources with real time data support. It has unique ingest capability to do parallel ingest of data from different sources with distributed and partition feature with M-S architecture. This standout SingleStore from others.
Cons
I believe it should have better User interface to support dynamic query creation along with that if it provide powerful Data virtualization options that would be nice.
SingleStore FAQs
Below are some frequently asked questions for SingleStore.Q. What type of pricing plans does SingleStore offer?
SingleStore offers the following pricing plans:
- Pricing model: Free Version
- Free Trial: Available
Contact SingleStore for pricing details.
Q. Who are the typical users of SingleStore?
SingleStore has the following typical customers:
51-200, 201-500, 501-1,000, 1,001-5,000
Q. What languages does SingleStore support?
SingleStore supports the following languages:
English
Q. Does SingleStore support mobile devices?
SingleStore supports the following devices:
Q. What other apps does SingleStore integrate with?
We do not have any information about what integrations SingleStore has
Q. What level of support does SingleStore offer?
SingleStore offers the following support options:
24/7 (Live rep), Chat
Related categories
See all software categories found for SingleStore.
