1. Home
  2. Relational Databases
  3. SingleStore Reviews
  4. User Review of SingleStore
Robust, Fast, and Scalable Database Solution
Updated March 10, 2024

Robust, Fast, and Scalable Database Solution

Nir Levy | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Overall Satisfaction with SingleStore

We are using SingleStore database as our main database in both production and non-production workloads. We are using both memory-based tables and disc-based tables (AKA column-store) and can easily join and query all tables. Our use of SingleStore is for many diverse business use cases, ranging from online data streaming, OLTP, and big-data batch processing.
SingleStore proved to be an excellent business and technical partner, with a top-of-line technical product and good business and technical support. Support is provided either directly from the supplier or from SingleStore's trusted partners
  • Real-time data processing
  • Online transaction processing
  • Big-data batch handling
  • Integration with external services (Kafka, S3, etc.)
  • Super fast data queries
  • While improving, backup is still hard to configure
  • Pricing of self-hosted instances
  • Few external documentation resources
  • Reduced database overall costs compared to previous solutions
  • Increased data access performance
  • Reduced downtime
We were able to ingest and handle large amounts of data quickly and easily using many different methods. SingleStore's access to Kafka, AWS S3, etc. has proved to be very helpful in our data processing strategy.
SingleStore has proved to be very effective in allowing us to collect and consolidate data from multiple sources into a single platform. It has very positively impacted our ability to manage our data.
We found SingleStore to be significantly superior to bare-bones MySQL as it offers better performance and scalability. It is also richer in terms of the query language supported, stored procedures, and connectivity. We also found it to be more robust than MySQL and with better business support.

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

Apache Kafka, Amazon Elastic Kubernetes Service (EKS), Amazon S3 (Simple Storage Service)
I would recommend SingleStore for use cases where a relational database is needed for handling both online transaction processing (OLTP), online data streaming, and batch big-data processing. Since it supports both in-memory and disc-based tables, it is suitable for handling large tables as well as smaller, fast ones.
SingleStore is MySQL compatible in terms of connection so you could use it with any connector that supports MySQL, and is mostly TSQL compatible so if you come from Transact-SQL background the switch will be simple.
While supporting JSON and document datatypes, I would not use SingleStore as a main document database, as its strengths lay in the relational realm.