SingleStore The Ultimate HTAP Database for Real-Time Performance.
February 26, 2025

SingleStore The Ultimate HTAP Database for Real-Time Performance.

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

Overall Satisfaction with SingleStore

IOT data processing and log analysis. The power of unified management is evident out of the box. Quick deployment, comprehensive troubleshooting, and customizable periodic reports increase productivity with fewer resources. Streamline, optimize, and elevate the network management experience through a single pane of glass with organization hierarchy, access controls, alerts from security threats, and usage thresholds - solutions that simplify network fabric and prioritize results to improve efficiency.

Pros

  • Can scale horizontally on cloud instances.
  • Can analyze large volumes of time-series data in real time.
  • Can perform queries in milliseconds.
  • Can process large amounts of data in parallel.

Cons

  • Can be expensive for small startups.
  • Migrating from traditional databases e.g., MySQL, PostgreSQL is complex.
  • Switching to another database might require significant re-engineering.
  • We used it for Sensor data analytics for industrial IoT.
  • Used it for Real-time dashboards for business intelligence.
  • Predictive analytics.
Column store tables optimize analytical queries with compression and vectorized execution. Rowstore tables for fast transactional (OLTP) performance. Processes real-time transactions and analytics in the same database. Sub-millisecond query response times for many workloads. Supports vectorized execution for analytics (SIMD optimizations). Query execution is optimized to balance read and write operations.
Eliminates the need for separate databases for transactions and analytics. Ingests data from multiple sources (Kafka, Spark, MySQL, etc.) into a single system. Scales horizontally, allowing high-speed data ingestion without bottlenecks. Supports structured (SQL), semi-structured (JSON), and unstructured data in one place. Works across cloud, hybrid, and on-premises environments.
Reduces database sprawl, ETL costs, infrastructure expenses, etc. Supports horizontal scaling, unlike PostgreSQL & Aurora, and real-time analytics and fast transactions (HTAP), unlike Snowflake & ClickHouse.Handles high-volume workloads with thousands of concurrent queries. No need for ETL processes, unlike BigQuery & Snowflake. Works with JSON, relational, and key-value data, unlike ClickHouse.

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

Good for Applications needing instant insights on large, streaming datasets. Applications processing continuous data streams with low latency. When a multi-cloud, high-availability database is required When NOT to Use Small-scale applications with limited budgets Projects that do not require real-time analytics or distributed scaling Teams without experience in distributed databases and HTAP architectures.

Comments

More Reviews of SingleStore

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