Excellent product !
February 04, 2025

Excellent product !

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

Overall Satisfaction with SingleStore

We use SingleStore for real time analytics (primarily for dynamic and transactional data). We have row store used for fast compute and streaming data and column store for more historic data fetch. Use case is to stage data from different domains within enterprise in real time streaming (kafka) and compute/apply algorithm on the dynamic data across enterprise for quick decisions.

Pros

  • Real time computations on large sets of data
  • Persisting streaming data
  • Data distributions and fast fetch

Cons

  • Semantic layer can be better, currently requires significant dev experience to fine tune queries
  • Query performance dashboard and self optimization methods instead of relying on keys
  • Bootstrap AI models to help provide recommendations as the user gets into UI (back to semantic)
  • Primarily it was not client, it was used for large enterprise with significant amount of data generation real time
  • Real time compute and reduces hassle of fine tuning (required but minimal compared to Oracle or other ERDBs)
  • Objective was to scale as data loads with high performing query(model) response
Excellent. To what have practically seen, product is really good. we hand initial challenges in setting up infra (especially with memsql) due to early adopters and limited support/documentations. Later product once setup, it out performed many on prem databases. It has initial infra cost involved (earlier it was licensed by data size but it is now on nodes) but otherwise, product can scale based on large enterprise needs
It was quite effective, infact we use native kafka to SingleStore connector and it is seamless in collecting data in split seconds. We haven't come accross challenges in persisting data for millions of transactions per day. It might need some maintenance especially switching between column store to row store but i believe this could be great opportunity to auto switch data based on some logic/need dynamically within SingleStore
SingleStore (memsql) out performs based on our analysis with sample data sets within org. We could see limitations with other products which SingleStore can overcall like scaling with data while performing with similar SLA. It also has the advantage of row store and column store which lacks in other products, though oracle has announced we can switch a column store to row store in an Oracle Database but that is again manual.

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

It is extremely good for scenarios where large sets of data is generated in a day and data is streamed. Especially if you would like to run queries, analytics on such data it would really scale and outperform Times DB or Oracle In memory options. But choosing this tech for right use case is key, should avoid using SingleStore like a ER DB and for that there are so many options in the market like postgres or Oracle lite etc.

Comments

More Reviews of SingleStore

  1. Home
  2. Relational Databases
  3. SingleStore Reviews
  4. User Review of SingleStore