SingleStore

Score8.2 out of 10

120 Reviews and Ratings

What is SingleStore?

SingleStore aims to enable organizations to scale from one to one million customers, handling SQL, JSON, full text and vector workloads in one unified platform.

Categories & Use Cases

Videos

Flexible deployment
The database can be deployed in a variety of environments and operating systems.
Category average: 8.4
Database monitoring
Teams can monitor database usage and performance metrics.
Category average: 9
Encryption
Data is encrypted in-motion and at rest, preventing unauthorized access and security breaches.
Category average: 8.6

Database locking
Locking mechanisms prevent users from accessing data while it is being updated.
Category average: 9
ACID compliance
The database complies with ACID (atomicity, consistency, isolation, durability), ensuring transactions are processed reliably.
Category average: 8.9
Disaster recovery
Data can be recovered in the event of a disaster.
Category average: 8.6

Most Frequent Users

Top 3 industries using SingleStore.

Based on HG Insights installation data

View all Reviews

#1 most frequent

Professional, Scientific, and Technical Services

25.6%

162 installations of 634

“We use SingleStore for a super fast client experience, running real time analytics on billions of events arriving every day from various publishers channels.”
— Dev Enablement Director, Skai

#2 most frequent

Information

22.4%

142 installations of 634

“It's very effective as we have a single source of truth which is our ORM, which maps to tables in SingleStore, like it would with MySQL but also gives us the power of analytical queries without having to manage an external service.”
— Founder, Personizely

#3 most frequent

Finance and Insurance

10.3%

65 installations of 634

Pros

Delivers fast query performance, often sub-second, for complex analytical queries and joined tables.
Provides horizontal scalability and a distributed architecture for managing large data volumes.
Efficiently ingests large volumes of data from diverse sources like Kafka and S3.

Cons

Limitations in data integration pipeline parameterization and monitoring capabilities.
Maturity gaps in core database features such as column mutations, foreign keys, and unique constraints for columnstore tables.
Difficulties in diagnosing root causes of issues like slow queries or memory failures.

Verified User

Team Lead in Engineering (51-200 employees)

Use Cases and Deployment Scope

We use it as our analytical database. It is more reliable and faster than our previous vendor. It also allowed us to replace another service that frees up $1500/month. We retrieve thousands of records at a time quickly.

Pros

Delivering thousands of records at blazing fast speeds
full text search
scaling

Cons

Improved UI for their portal
Better ticket system
More workers on workspace

Return on Investment

costs half of previous vendor
faster data speeds
easier to scale

Alternatives Considered

Snowflake

Other Software Used

AWS Cloud9, MariaDB Platform, Snowflake

Usability

Sergiu Cazac

Founder in Information Technology at Personizely (1-10 employees)

Use Cases and Deployment Scope

We are using SingleStore to power our whole app database layer.
We use it both for our basic tables and also for the analytical ones.

The magic is that we don't need to have multiple types of databases, it's just a single database which is a drop-in replacement for MySQL and it works almost exactly the same at the API level with some differences, which we can live with but hope they can improve upon (like column adjustments on the fly, foreign keys, etc.)

Pros

Analytical queries
Basic SQL usage similar to how you would use MySQL

Cons

Column mutations (from null to not null, or type changes)
Foreign keys
Unique columns (for columnstore)

Return on Investment

No engineering overhead for maintaining the db so no makes up for the price in a way
We are able to provide better analytics to our customers - providing more value

Alternatives Considered

ClickHouse and Elasticsearch

Other Software Used

Hetzner IaaS, Symfony, Vue.js

Usability

Satwik Loka View profile

Backend developer in Engineering at Retilo (1-10 employees)

Use Cases and Deployment Scope

SingleStore resolved my latency issues with vector database usage by taking heavy lifting on their.

I have created an application to chat with POS orders done for e-commerce website.
Lot of insights & Analysis of order data is correct and precise.

Retail data is messy but vector database of SingleStore given me wings to play with retail & e-commerce data

Pros

SQL query fastness
Vector database
Contextual & Real time application

Cons

It should give more tutorials
Documentation is little fussy & confusing
Not defined use cases

Return on Investment

Efficient
Good developer experience
Impact measurable

Alternatives Considered

YES-POS, Weaviate and Quadrant Platform

Other Software Used

Azure AI Search, AWS Chatbot, GitHub

Verified User

Engineer in Engineering (1001-5000 employees)

Use Cases and Deployment Scope

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.

Return on Investment

Reduced Costs.
Improved User experience due to faster queries.

Alternatives Considered

Google BigQuery

Usability

Verified User

Engineer in Engineering (11-50 employees)

Use Cases and Deployment Scope

SingleStore is our only database solution we currently use. It is used at the application level to serve and store user information. We are a data company and serve up millions and millions of datapoints to customers and all that data is stored in SingleStore. SingleStore enables us to do quick analytical queries on millions of rows of data in seconds allowing us to be a market leader in the data space.

Pros

Efficiency
Reliability
Speed

Cons

Customer Service

Return on Investment

Faster application
Less database management

Alternatives Considered

Amazon DynamoDB and Amazon Elasticsearch Service

Other Software Used

AWS Batch, AWS Lambda

SingleStore

What is SingleStore?

Categories & Use Cases

Videos

SingleStore Key Features

Top Performing Features

Flexible deployment

Database monitoring

Encryption

Areas for Improvement

Database locking

ACID compliance

Disaster recovery

Who Buys & Uses SingleStore

Most Frequent Users

Professional, Scientific, and Technical Services

Information

Finance and Insurance

Most Frequent Users

Small Businesses

Mid-sized Companies

Enterprises

Most Frequent Users

United States of America

United Kingdom of Great Britain and Northern Ireland

India

Most Frequent Users

Engineering

IT

Product Management

SingleStore Reviews

Pros

Cons

Use Cases and Deployment Scope

Pros

Cons

Return on Investment

Alternatives Considered

Other Software Used

Usability

Use Cases and Deployment Scope

Pros

Cons

Return on Investment

Alternatives Considered

Other Software Used

Usability

Use Cases and Deployment Scope

Pros

Cons

Return on Investment

Alternatives Considered

Other Software Used

Use Cases and Deployment Scope

Pros

Cons

Return on Investment

Alternatives Considered

Usability

Use Cases and Deployment Scope

Pros

Cons

Return on Investment

Alternatives Considered

Other Software Used

SingleStore Alternatives