SingleStore: An excellent compute engine
February 23, 2024

SingleStore: An excellent compute engine

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

Overall Satisfaction with SingleStore

SingleStore is used as source of truth for our data. It is one of our main database providers. Singlestore acts as a 1) historical ledger for granular log level data, as well as 2) a compute engine for deriving new metrics. Our use-cases for SingleStore span various environments including production, test, UAT, & development.
  • Computation
  • Sharded infrastructure
  • Query optimization tools/AI Assistants
  • Granular user-permissioning in the online UI
  • More robust server-level telemetry data
  • Easier to access/use database log information
  • Faster query speeds
  • Easier database administration
  • Better developer efficiency/experience
Singlestore is a great solution for many workflows: it can ingest/write data very fast. It can also compute data/run calculations very fast. I also appreciate the level of accessibility SingleStore provides for retrieving data. They offer their own custom API for read/write operations, which has its own protections/synergies outside of traditional database connections

In almost all cases SingleStore is fast enough to run the workflows we need, which is better than some of the other database providers we've used in the past.

Singlestore has done a decent job at collecting our data into one platform (as far as I can tell-- other parts of the org might use different database providers).

I would be cautious to say that SingleStore can replace multiple databases though. Singlestore is certainly an excellent compute engine and as a source of truth, but I do see possible use cases for wanting multiple databases.
SingleStore is eons faster than other database providers, and it absolutely crushes calculations & aggregations. While other providers may have a few quality of life enhancements over SingleStore, the speed benefits of SS far outweigh the cons. At the end of the day, speed matters a lot in our workflows, and Singlestore allows us to run things in the desired timeframes.

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?

I wasn't involved with the selection/purchase process

Did implementation of SingleStore go as expected?

Yes

Would you buy SingleStore again?

Yes

Amazon Elastic Compute Cloud (EC2), Google BigQuery, Linear App
SingleStore is excellent at computing heavy workflows. The column-store table design combined with efficient sharding strategies make for a beast of a database that lets you compute large queries at ease. Singlestore also offers a variety of developer tools such as SQrL (their AI assistant) and their Query Profiler, which are massively helpful for figuring out what bottlenecks exist in a given query.