SingleStore

About SingleStore

SingleStore is a database management solution that helps businesses ingest, analyze, store, deploy, manage, secure, and integrate data across systems. It allows administrators to manage data in various formats including relational SQL, geospatial, full-text search, and JSON.

It provides a variety of features including data lake pipelines, workload management, multi-statement transactions, deployment management, performance monitoring, and more. It provides cluster management capabilities, which lets users automate start, stop, restore and back up processes related to clusters. SingleStore provides security tools, which allow businesses to implement role-based access control based on roles and groups and authenticate account access using PAM (Pluggable Authentication Module) and SAML.


Images

No images available

Not sure about SingleStore? Compare with a popular alternative

SingleStore

4.5 (39)
VS.

Starting Price

No pricing found
No pricing found

Pricing Options

Free version
Free trial
Free version
Free trial

Features

19
4

Integrations

No integrations found
No integrations found

Ease of Use

4.5 (39)
4.2 (25)

Value for Money

4.2 (39)
3.9 (25)

Customer Service

4.3 (39)
4.1 (25)

Alternatives

Vantage

4.3
#1 Alternative to SingleStore
Teradata Database allows individuals to break down and distribute complex analytics workloads to improve performance....

MongoDB

4.7
#2 Alternative to SingleStore
MongoDB is a database management software that is designed for organizations in several industry segments, including...

PostgreSQL

4.6
#3 Alternative to SingleStore
PostgreSQL is an open-source relational database management system (RDBMS), which helps businesses store, manage, and...

Oracle Database

4.6
#4 Alternative to SingleStore
Oracle Database is a data warehouse software designed to help businesses of all sizes manage data and automate...

Reviews

Overall rating

4.5 /5
(39)
Value for Money
4.2/5
Features
4.5/5
Ease of Use
4.5/5
Customer Support
4.3/5

Already have SingleStore?

Software buyers need your help! Product reviews help the rest of us make great decisions.

Showing 5 reviews of 39
Sujay
Overall rating
  • Industry: Computer & Network Security
  • Company size: 501–1,000 Employees
  • Used Daily for 1+ year
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 10.0 /10

Checked - One solution for Streaming Analytics on Big Data

Reviewed on 27/12/2019

Pros

- Super simple, we implemented the whole of our customer-facing streaming analytics data store in a 2-day hackathon
- Natively integrates with AWS & other services (we are a multi-petabyte S3 shop with huge Kafka clusters)
- Since most of it is SQL, anyone can hit the ground running in no-time, an ultra-low barrier to entry
- We saw a sub-second response on a test case with 1000 concurrent heavy API calls (scanning billions of rows across many tables + window functions etc) along with applying RBAC functionalities on the fly
- Incredibly fast out of the box, basic performance tuning will suffice 95% of use cases
- Fantastic partners to work with, super helpful, we have access to their core engineering team, +100 on Customer engagement!

Cons

In my humble opinion, it solved a very unique hard problem for us elegantly (without having to compromise on any architectural or data principles). Problem of streaming analytics on high-velocity high volume data sets with sub-second API responses can be a handful. For me, this along with other use-cases they mention is their core strength. So anything beyond these capabilities is a "Nice to have" for me. Their roadmap covers most of what the community is asking - hot back-up's, better UI, modelling etc.

Brandon
Overall rating
  • Industry: Utilities
  • Company size: 10,000+ Employees
  • Used Daily for 1+ year
  • Review Source

Overall rating

  • Ease of Use
  • Customer Support
  • Likelihood to recommend 9.0 /10

Thoughts on MemSQL

Reviewed on 18/10/2019

Our primary use case for MemSQL is an enterprise data lake, which will also serve as a staging area...

Our primary use case for MemSQL is an enterprise data lake, which will also serve as a staging area for MemSQL data warehouses. They are currently being developed and are not in production yet. We're learning things as we go, but in general, development is going well and we're satisfied with the product.

Pros

I appreciate that MemSQL is a distributed database that runs on commodity hardware and can be scaled out as opposed to some fixed, vendor-maintained appliances like Teradata. Columnstore is a valuable feature.

Cons

The product is not fully mature. Although it uses the MySQL protocol, it does not always work with MySQL-compliant products. Some administrative functions such as incremental, point-in-time, and object-specific backups and restore are lacking. MemSQL is making progress in these areas, but it still has room to grow.

Response from SingleStore

Thanks for your feedback. We work hard every day to close any feature gaps between MemSQL and the older, legacy databases. Incremental Backup lands in version 7.0, and point-in-time restore is being actively developed, and is slated to land next year.

Verified Reviewer
Overall rating
  • Industry: Financial Services
  • Company size: 10,000+ Employees
  • Used Daily for 2+ years
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 3.0 /10

MemSQL : Needs Time to Mature

Reviewed on 10/09/2019

This is a good software but needs to mature more for an enterprise level

This is a good software but needs to mature more for an enterprise level

Pros

Similar to existing RDBMS
Supports join
In Box implementation with Spark
Salable & manageable with memSQL ops

Cons

Security Features
Consistency
Overflow on Disk

Alternatives Considered

Apache Cassandra

Reasons for Choosing SingleStore

Scalability & Growing Cost

Reasons for Switching to SingleStore

Cost & future roadmap
Nir
Overall rating
  • Industry: Information Technology & Services
  • Company size: 51–200 Employees
  • Used Daily for 6-12 months
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 8.0 /10

Strong, robust and fast database engine

Reviewed on 20/09/2023

We are using SingleStore as our main database engine both for online transaction processing (OLTP)...

We are using SingleStore as our main database engine both for online transaction processing (OLTP) and for data warehousing. It has proved to be a robust database engine with great performance and many useful features.

Pros

Singlestore is a very strong relational database management system which produces very good results in terms of speed and robustness. It have many unique features that make it a good system for data consumption and processing. It is also API -compatible with MySQL dialect so you can use mysql-targeted tools to query data on SingleStore.

Cons

It's not the cheapest engine you could get but generally, in terms of cost-value ratio, I feel it's a good match. Also, backup on a self-hosted solution is not always easy to implement since it needs to backup large amounts of data.

MOHAMMAD SUFIYAN
Overall rating
  • Industry: Information Technology & Services
  • Company size: 10,000+ Employees
  • Used Daily for 6-12 months
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support
  • Likelihood to recommend 10.0 /10

SUPERSONIC DB - SUPERB

Reviewed on 10/10/2019

I'll rate it at a full star. Having worked with almost all the databases, I can simply say it aces...

I'll rate it at a full star. Having worked with almost all the databases, I can simply say it aces every database that I worked. The Transformation capabilities in LOAD command is something I have not seen anywhere which helps a lot along with capturing errors and rejects in the LOAD command.

Pros

Super fast and would have give a fair bit of competition to CONCORD Aircraft:). But seriously it is the Database of the new generation with huge potential for both On Premise and Cloud. High compatibility, resilience, scalability are some superb features to work on with it. Highly recommended to any Organization wanting to get rid of the Old fashioned drag on DBs.

Cons

I don't have any particular dislikes, but would love to see its own Client interface, inbuilt Data Modelling capabilities and a superb front end which can help potentially any Developers or Programmers to start the development from Day 1.
Secondly I would also like to see a proper Blogging web portal to help developers resolve their queries, issues faster.

Response from SingleStore

Supersonic is a great description. Thank you. Have you tried MemSQL Studio, the web-based SQL editor and cluster monitor?

Showing 5 reviews of 39 Read all reviews

SingleStore FAQs

Below are some frequently asked questions for SingleStore.

SingleStore offers the following pricing plans:

  • Pricing model: Free Version
  • Free Trial: Available

Contact SingleStore for pricing details.

SingleStore has the following typical customers:

51–200, 201–500, 501–1,000, 1,001–5,000

SingleStore supports the following languages:

English

SingleStore supports the following devices:

We do not have any information about what integrations SingleStore has

SingleStore offers the following support options:

24/7 (Live rep), Chat

Related categories

See all software categories found for SingleStore.