The product can automatically reinstall and reconfigure in case of a shutdown.
External reviews
121 reviews
from
and
External reviews are not included in the AWS star rating for the product.
Can automatically reinstall and reconfigure in case of a shutdown
What is most valuable?
What needs improvement?
We don't get good discounts in Pakistan.
For how long have I used the solution?
I have been working with the product for three months.
What do I think about the stability of the solution?
I would rate the product's stability a nine out of ten.
What do I think about the scalability of the solution?
I would rate the solution's scalability a ten out of ten.
How was the initial setup?
SingleStore's setup is difficult.
What's my experience with pricing, setup cost, and licensing?
The product's licensing is not expensive. It is comparable.
What other advice do I have?
I would rate SingleStore a ten out of ten.
Wicked fast and easy to use database
What do you like best about the product?
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 the product?
Backups do not work well- we have had several issues with these.
What problems is the product 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.
The Best All-in-One Database Solution
What do you like best about the product?
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..
Every other solution I looked at required me to maintain 2 seperate databases, certainly not ideal in any means..
What do you dislike about the product?
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 the product 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.
Singlestore Power of Analytics
What do you like best about the product?
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 the product?
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 the product 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 !
Great product for streaming data!
What do you like best about the product?
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 the product?
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 the product solving and how is that benefiting you?
Excellent concurrent read/write speed.
10X faster than MySQL, Postgres, Oracle and 1/4 the cost
What do you like best about the product?
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
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 the product?
Nothing as of now to be very honest but would share if I find any in coming days.
What problems is the product 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 .
Amazing Capabilities with this Product
What do you like best about the product?
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 the product?
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 the product 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
Super fast for real-time big data analytics
What do you like best about the product?
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 the product?
Limited sources from which data can be integrated. Takes lot of time deploying the cluster.
What problems is the product 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
High performance database ingestion for OLTP and OLAP
What do you like best about the product?
- 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.
- 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 the product?
- 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.
- 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 the product 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.
Excellent platform for the data storage.
What do you like best about the product?
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 the product?
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 the product 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.
showing 11 - 20