SingleStore DB (formerly MemSQL) never fails you
September 24, 2020

SingleStore DB (formerly MemSQL) never fails you

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

Overall Satisfaction with MemSQL

We use SingleStore DB (formerly MemSQL) to store a real-time feed of all kinds of open source data. The data get full-text indexed, stored in start schema, and instantly ready for analysis. Multiple departments have access to multiple dashboards backed up with SingleStore DB (formerly MemSQL).
  • Ingesting high volume of data in real-time.
  • Excellent query performance (response in milliseconds).
  • Feature rich, json support, full-text search.
  • Minimum administration is needed.
  • Cross-cluster queries
  • SingleStore DB (formerly MemSQL) procedural SQL syntax can be simplified
  • Materialized views
  • Implementing recursion in queries
  • Tag cloud generator from a full-text index
  • License cost is lower than many of its competitors.
  • Requires very little administration. We are getting by without even hiring an admin.
  • Integrating the pipelines and the DB engine simplifies the solution architecture, which means less infrastructure is needed, less license cost, and shorter development cycle.
The support team is very responsive and cooperative. Especially when it comes to urgent tickets or anything that might affect cluster availability. I've contacted the support many times during the past few years, and I never had a complaint about response time or an unresolved issue.
SingleStore DB (formerly MemSQL) covers a wide spectrum of use-cases and provides ANSI-SQL support, MySQL drop-in replacement.
It supports several deployment options--cloud, Helios, on-premise bare-metal or virtualized. Has drivers for many programming languages like Java and Python, for BI tools like Zoomdata and Tableau.

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 DB (formerly MemSQL) is good for a high-volume, real-time data feed, a high number of concurrent queries, and excellent for both OLAP and OLTP workloads. It's not good for unstructured data store.