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.

Pros

  • HTAP workloads
  • query profiling and explanations
  • customer support

Cons

  • 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?

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 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.

Comments

More Reviews of SingleStore