Good Analytics Database.
January 09, 2025

Good Analytics Database.

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

Overall Satisfaction with SingleStore

We use a single store for an analytics use case in our organization. The previous database was not distributed, and scaling issues were occurring, so a single store with a distributed nature helped us solve this issue. We mainly use the columnar tables in a single store for analytics.

Pros

  • Sharding/Distributed Database.
  • Analytics Queries.
  • Good Observability.

Cons

  • Row tables.
  • Query Profiler.
  • Reduced Costs.
  • Improved User experience due to faster queries.
Single-store analytical queries are faster, and they can update the records, unlike many analytical databases, which have limitations regarding record updates.
We use it only for analytical use cases, so I cannot comment much on the hybrid workload.
We previously used Bigquery for our application, and a single store gave us very good performance over Bigquery. But the comparison is not apples to apples, as Bigquery is more of a data warehousing solution.

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

In my opinion, it is well suited for analytics use cases. However, it is less appropriate for transactional data as row tables are saved in memory, and single nodes are more costly than traditional databases.

Comments

More Reviews of SingleStore

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