Sign in
Categories
Your Saved List Become a Channel Partner Sell in AWS Marketplace Amazon Web Services Home Help

SingleStore Helios

SingleStore | 1

Reviews from AWS Marketplace

0 AWS reviews
  • 5 star
    0
  • 4 star
    0
  • 3 star
    0
  • 2 star
    0
  • 1 star
    0

External reviews

118 reviews
from G2

External reviews are not included in the AWS star rating for the product.


    Tom M.

Great product for streaming data!

  • July 26, 2022
  • Review provided by G2

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.


    Sumit D.

10X faster than MySQL, Postgres, Oracle and 1/4 the cost

  • July 22, 2022
  • Review provided by G2

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
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 .


    Airlines/Aviation

Amazing Capabilities with this Product

  • July 21, 2022
  • Review provided by G2

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


    Information Technology and Services

Super fast for real-time big data analytics

  • July 21, 2022
  • Review provided by G2

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


    Banking

High performance database ingestion for OLTP and OLAP

  • July 14, 2022
  • Review verified by G2

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.
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.
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.


    f158095 M.

Excellent platform for the data storage.

  • July 12, 2022
  • Review verified by G2

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.


    Carlos A.

Amazing solution

  • July 11, 2022
  • Review provided by G2

What do you like best about the product?
I liked the speed to upload data and the potential to load big volumes so it is solution that thinks out of box.
What do you dislike about the product?
The GUI is not so clear, sometimes is difficult to find some obvious thing like create a database
What problems is the product solving and how is that benefiting you?
I have seen the potential to load big volumes of files so I am interesting to see how it works to query and aggregate big volumes as well with multiples joins.
Recommendations to others considering the product:
I really recommend for companies that it is starting to think in big data world.


    Mama P.

SingleStore is easy to use and works faster

  • June 16, 2022
  • Review verified by G2

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.


    Tyler M.

For large-scale, data-intensive, always-on, data problems, I don't think you can beat SingleStore.

  • June 13, 2022
  • Review provided by G2

What do you like best about the product?
It is a "Ferrari" of a database. The native pipeline / ingestion is ultra-fast. I have worked with Oracle RDB, MySQL, IBM DB2.0, and PostGRES; nothing comes close to SingleStore for throughput for data ingestion.

Writing vanilla / brute force queries also exceeded my expectations. With any distributed data you can ruin performance with cross-node joins, so with well planned partitioning and key design I expect performance would be lightning fast. That said, simplistic, brute-force query performance was very impressive highlighting the power of the SQL Engine.

The horizontal scaling / Cluster Management is very nice, by far the easiest cluster management I've experienced.
What do you dislike about the product?
I worry about the cost of intermittent work-loads. It seems like the cluster is always on, burning credits at full gas. So if work-loads are intermittent, the cost of idle time would be very high.

Like any database, you'll get the best performance if you play to it's strengths, so in order to achieve that peak performance, you need to understand the impact a distributed (clustered) databases will have on your data architecture and data design. Which is not too difficult, just a reminder to avoid putting square pegs in round holes.
What problems is the product solving and how is that benefiting you?
If you are dealing with huge volume and need a highly available database with superb performance, pick SingleStore - It is excellent at what it does -- Ingestion throughput, overall speed of database, and the ease of horizontal scaling.


I am freelance solution architect so I wanted to experiment to have some first-hand knowledge of the platform.
Recommendations to others considering the product:
If you fall into the large-scale, data-intensive, always-on, managed service problem space, I don't think you can beat SingleStore. Like any database, you'll get the best performance if you play to it's strengths, so in order to achieve that peak performance, you need to understand the impact a distributed (clustered) databases will have on your data architecture and data design. Which is not too difficult, just a reminder to avoid putting square pegs in round holes. If you are dealing with huge volume and need a highly available database with superb performance, pick SingleStore - It is excellent at what it does.


    Jerry O.

Credible Performance - OLTP and OLAP Database in One Shot

  • June 12, 2022
  • Review verified by G2

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.