The product can automatically reinstall and reconfigure in case of a shutdown.
SingleStore Helios
SingleStoreExternal reviews
121 reviews
from
and
External reviews are not included in the AWS star rating for the product.
Singlestore is best in market compared to Google's Bigquery
What do you like best about the product?
I like the scalability, versatililty in the product with architecture itself which can be used for multi models.
What do you dislike about the product?
I feel singlestore is not beginner friendly as early stage developer in AI era.
What problems is the product 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.
Successfull Co-Innovation Partnership
What do you like best about the product?
Query and Ingestion Speed at Scale over Multi-Model Storage w/ Simplicity .
What do you dislike about the product?
Medium UX for Self-Hosted versions and medium materialization features
What problems is the product solving and how is that benefiting you?
Chatbot, Customer Mobile Banking RT Analytics , Customer Intelligence for RT decision (multiple scenarios)
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.
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 .
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.
SingleStore is easy to use and works faster
What do you like best about the product?
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 the product?
Detailed pipeline log in UI itself is not available. But it is available in the database.
What problems is the product 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.
Credible Performance - OLTP and OLAP Database in One Shot
What do you like best about the product?
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 the product?
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 the product 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.
showing 1 - 10