SingleStore Reviews & Product Details

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. Review collected by and hosted on G2.com.

Backups do not work well- we have had several issues with these. Review collected by and hosted on G2.com.

- 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. Review collected by and hosted on G2.com.

- 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. Review collected by and hosted on G2.com.

We can handle large dataset analysis. Singlestore provides us with the capability to do so at incredible speed. I can confidently say that organizations should move to SingleStore database. Also provides the facility for heterogeneous databases connectivity. Review collected by and hosted on G2.com.

I had some issues with configuration and docker that took too much time to create an environment, but customer support helped me through it. But it's really great after that. Review collected by and hosted on G2.com.

The onboarding experience and how easy it is to get started. As someone who works with many clients, I particularly liked the ability (and ease) to quickly spin up a temporary database and ingest a large amount of data to run queries against. This is extremely useful for short-term (several days to 2 weeks) analytics projects. The logistics of setting up a new database are night & day in comparison to using RDS. Review collected by and hosted on G2.com.

"Dislike" is a strong term. After my initial experience with the product, there wasn't anything I particularly disliked, but here are some notes on how I think the user experience could be made better:

- It would be good to get the real time status of a pipeline; when I was running the test data import, the row count of the table kept changing every few seconds as more data was loaded. There was no real way to know when the entire set finished importing.

On this note, it would be great to have a general view of all the queries that are currently running in the database, and their progress. This would come in particularly useful when building applications that run analytics workloads and debugging those applications.

- (UX improvement) support for multiple SQL editor tabs in the web front end would be great, especially considering that the web interface appears to be designed to be the primary method for humans to interact with the database. Review collected by and hosted on G2.com.

SingleStore is a really awesome and fast technology. Its fast-loading and fast data retrieval won my heart.

It supports multiple sources just like CSV, JSON, and so on. Review collected by and hosted on G2.com.

As a new user, it was a bit difficult to understand, but it became more and more logical over time.

it took me almost an hour to understand all the functionality. But upon grasping the SingleStore UI, I realized how powerful it is! Also, I recommend checking out this Getting Started on SingleStore tutorial video: https://www.youtube.com/watch?v=bIFrJJkUftA Review collected by and hosted on G2.com.

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 Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

I would have loved SingleStore to logically group tables, views, and similar objects in a schema adopting the Database >> Schema >> Table logical structure. Review collected by and hosted on G2.com.

"I think the success of SingleStore will align with the adoption of HTAP. The detailed processing of large volumes of data with real-time Analytics will magnify the benefits of SingleStore." Review collected by and hosted on G2.com.

SingleStore's success is based on the widespread adoption of HTAP, which does not have a large following at this time. Review collected by and hosted on G2.com.

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 Review collected by and hosted on G2.com.

Nothing as of now to be very honest but would share if I find any in coming days. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.