1. Home
  2. Relational Databases
  3. SingleStore Reviews
  4. User Review of SingleStore
SingleStore: A "Swiss Army Knife" for data storage and analytical needs
March 05, 2024

SingleStore: A "Swiss Army Knife" for data storage and analytical needs

Anonymous | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Overall Satisfaction with SingleStore

We recommend SingleStore to our customers who face scalability issues with their OLTP or OLAP systems. Many companies use database engines that are inappropriate for specific data computing tasks. For example, MySQL is not meant for analytics or real-time analytics. SingleStore is.
SingleStore compresses data, which lowers your disk footprint, thus saving storage costs.
Most of the time, we'll do a discovery about our customer pain points and determine if SingleStore is the right fit. We'll then work with SingleStore to do a POC to ensure we meet all customer requirements.
  • Data Ingestion
  • Scaling Writes and Reads
  • Compressing Data
  • Support
  • Short learning curve
  • MySQL to SingleStore replication
  • Digital Asset Research: Lowers TCO 50%
  • Improved Customer experience by providing faster queries
  • Automated the load of datasets from S3
When it comes to ingestion speed, SingleStore is probably at the top. Being able to create pipelines using SQL to ingest data from S3, Kafka, and other sources, is a great advantages. This means you can dynamically ingest data by customizing your SQL queries. SingleStore pipelines are pretty sophisticated, yet very simple. Few lines of codes and you are ingesting data, while still able to perform analytical queries on your billions of row tables.
We performed 2 MySQL to SingleStore migrations. In both cases, the customer was very happy with the results. For one customer, they were able to reduce the TCO by 50%. For the other customer, they were able to provide better performance for their application. We are also working on another project to reduce the data storage cost and improve the performance for an IOT company.
SingleStore is built for fast data ingestion and fast queries against large tables (> billions of rows). This is possible because of the column store engine that SingleStore uses. SingleStore also support a memory engine. Pipelines is also another big advantage. Being able to ingest data from S3 (and loading new data) without adding any additional services (with just 1 SQL query) is pretty cool. SingleStore is also pushing hard with vector engine. It is becoming a single storage solution.

Do you think SingleStore delivers good value for the price?

Yes

Are you happy with SingleStore's feature set?

Yes

Did SingleStore live up to sales and marketing promises?

Yes

Did implementation of SingleStore go as expected?

Yes

Would you buy SingleStore again?

Yes

SingleStore HTAP engine is well suited for real-time analytics, fast ingestion, scaling OLTP system like MySQL.
When you need to run reports or perform aggregates on billions of rows and you get result in seconds, you cannot get this experience with other OLTP engines.
I wish DBtLab was a little more developer and supported for SingleStore. This would allow to perform better data transformation.
You can use stored procedures, but DBTLabs has become a standard for dimensional modeling in data warehousing projects. This is probably why SingleStore has trouble piercing in the data warehouse world. It is definately capable to compete with Snowflake when it comes to scalability, query performance, data compression, but Snowflake has ravaged the data warehouse market in few years and large corporations have already invested lots of money in migrating into Snowflake.
The SingleStore community needs to grow. Everyone who uses SingleStore loves it.