The future is HTAP
Updated February 08, 2023

The future is HTAP

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

Overall Satisfaction with SingleStore

We use SingleStore as the primary database for our Digital Marketing OS. It allows us to process transactions and answer complex analytical queries within the same database.


  • HTAP workloads
  • query profiling and explanations
  • customer support


  • visibility over memory management
  • the code source is closed, so we can't audit it for backdoors
  • would help to manage cluster settings via the UI without SQL
  • SingleStore simplified our tech stack
  • It improved the capabilities of our software with real-time analytics
SingleStore is very powerful for analytical queries, however it can struggle under heavy write transactions, as the column store is not as fast as the row store for such workload.
Yes SingleStore is very good for handling OLTP and OLAP workloads within the same database, and avoids managing multiple databases. It simplifies the tech stack.
SingleStore outperformed both MongoDB and PostgreSQL for OLAP workloads. Its ability to shard data and handle parallel processing of SQL "JOIN" queries across shards is a game changer.

Do you think SingleStore delivers good value for the price?

Not sure

Are you happy with SingleStore's feature set?


Did SingleStore live up to sales and marketing promises?


Did implementation of SingleStore go as expected?


Would you buy SingleStore again?


SingleStore shines where you want to execute complex analytical queries over your datasets in real-time, and still want to handle transactions. It prevents you from having a transaction database and a separate async analytical database. However, running SingleStore is expensive, it requires a powerful cluster with a lot of RAM. If you don't need to process real-time analytics, you won't benefit much from SingleStore.


More Reviews of SingleStore