The issue we encountered was the inability to efficiently extract and evaluate our data from existing databases, causing limitations with Tableau, which struggled to handle datasets exceeding a hundred million records. Consequently, we explored alternative systems and initially attempted to access all data from target systems. In pursuit of faster and more effective data management, we considered Exasol as an alternative OLAP system. Ultimately, we opted for SingleStore.
SingleStore Helios
SingleStoreExternal reviews
121 reviews
from
and
External reviews are not included in the AWS star rating for the product.
High-speed data processing, seamless scalability, and excellent high availability making it an optimal choice for those prioritizing performance and efficiency in a database solution
What is our primary use case?
What is most valuable?
The paramount advantage is the exceptional speed. Another noteworthy aspect of our experience is that, upon its setup, there aren't any issues that necessitate the intervention of a DBA. In terms of performance, it has proven impressive, particularly in handling complex joins without the need for data shortening. It excels in executing complex SQL operations swiftly.
What needs improvement?
There's a noteworthy consideration when it comes to collecting massive amounts of data. It is not the optimal choice for direct data collection through queries, and it's more suited for aggregation tasks. Attempting to use it for direct extraction, for instance, might lead to memory-related challenges. While MySQL version five might lack extensive SQL capabilities, SingleStore also has its constraints, requiring simpler SQL writing. This becomes evident when seeking advanced functionalities like window functions or JSON functions, where SingleStore doesn't offer an extensive toolkit, necessitating a more straightforward approach to SQL.
For how long have I used the solution?
We have used it for two years.
What do I think about the stability of the solution?
I would rate its stability capabilities ten out of ten.
What do I think about the scalability of the solution?
Regarding scalability, we did encounter occasional challenges as our data grew larger, resulting in potential out-of-memory issues. The resolution to this depends on the budget allocated. If budget constraints are not a concern, opting for a SaaS system is a viable solution, albeit with associated costs. Scaling the system incurs expenses for each additional node. I would rate it seven out of ten.
Which solution did I use previously and why did I switch?
I use Exasol, and it has proven to be highly effective. However, when considering factors such as cost, financial aspects, SQL version capabilities, and insertion times, there are certain drawbacks. Specifically, the performance in terms of insertion times is notably subpar.
How was the initial setup?
The initial setup was straightforward.
What about the implementation team?
The deployment process was remarkably swift, taking only one or two days, and we encountered no issues throughout the entire setup.
What other advice do I have?
If simplicity, quick data insertion, minimal complexity, and high availability are your primary concerns, and budget constraints aren't a major issue, then SingleStore is an excellent choice. I would rate it eight out of ten.
Can automatically reinstall and reconfigure in case of a shutdown
What is most valuable?
The product can automatically reinstall and reconfigure in case of a shutdown.
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.
showing 11 - 20