SingleStore

RATING:

4.5

(39)

About SingleStore

SingleStore is a database management solution that helps government organizations and enterprises in the financial, media, energy, technology and retail industries leverage artificial intelligence (AI) and machine learning capabilities to handle operational analytics, internet of things (IoT), data ingestion and more. Professionals can handle workloads, back up data to Amazon S3 and utilize various business intelligence tools to perform ad-hoc analysis. MemSQL allows organizations to analyze data in JavaScript Object Notation (JSON), Structured Query Language (SQL) and other formats. Administrators can configure users' access permissions, maintain an audit trail of internal logs and protect data via TLS encryption. Additionally, it lets managers store and index geograp...

Awards and Recognition

FrontRunner 2021
Software Advice's FrontRunners report ranks top products based on user reviews, which helps businesses find the right software.

SingleStore Pricing

Contact SingleStore for pricing details.

Free trial: 

Available

Free version: 

Available

MemSQL create database cluster

SingleStore Reviews

Overall Rating

4.5

Ratings Breakdown

Secondary Ratings

Ease-of-use

4.5

Customer Support

4.5

Value for money

4

Functionality

4.5

Most Helpful Reviews for SingleStore

1 - 5 of 39 Reviews

User Profile

Sujay

Verified reviewer

Computer & Network Security, 501-1,000 employees

Used daily for less than 2 years

Review Source: Capterra
This review was submitted organically. No incentive was offered

OVERALL RATING:

5

EASE OF USE

5

VALUE FOR MONEY

5

CUSTOMER SUPPORT

5

FUNCTIONALITY

5

Reviewed December 2019

Checked - One solution for Streaming Analytics on Big Data

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.

Reason for choosing SingleStore

All the previous solutions we tried solved either one or few of the challenges in this use-case for us. Memsql covered almost all the focus areas without having to compromise on any architectural or data principles.

Reasons for switching to SingleStore

All the previous solutions we tried solved either one or few of the challenges in this use-case for us. Memsql covered almost all the focus areas without having to compromise on any architectural or data principles.

Brandon

Utilities, 10,000+ employees

Used daily for less than 2 years

Review Source: Capterra
This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you.

OVERALL RATING:

4

EASE OF USE

4

CUSTOMER SUPPORT

5

FUNCTIONALITY

4

Reviewed October 2019

Thoughts on MemSQL

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.

Reason for choosing SingleStore

We considered NoSQL products such as Hadoop, but we wanted to leverage our existing SQL skillset.

Reasons for switching to SingleStore

We're not making a full switch and retiring Teradata immediately, but we're going to use it less and MemSQL more. We've had frustrations with developing and supporting Teradata. We prefer MemSQL's DR replication and included columnstore functionality, for example.

Vendor Response

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.

Replied October 2019

Anonymous

10,000+ employees

Used daily for more than 2 years

Review Source: Capterra
This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you.

OVERALL RATING:

3

EASE OF USE

4

VALUE FOR MONEY

1

CUSTOMER SUPPORT

2

FUNCTIONALITY

3

Reviewed September 2019

MemSQL : Needs Time to Mature

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

Reason for choosing SingleStore

Cost & future roadmap

Reasons for switching to SingleStore

Scalability & Growing Cost

MOHAMMAD SUFIYAN

Information Technology and Services, 10,000+ employees

Used daily for less than 12 months

Review Source: Capterra
This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you.

OVERALL RATING:

5

EASE OF USE

5

VALUE FOR MONEY

5

CUSTOMER SUPPORT

5

FUNCTIONALITY

5

Reviewed October 2019

SUPERSONIC DB - SUPERB

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.

Reasons for switching to SingleStore

Very expensive, developers find it hard to learn and also the scalability is not at par which I have see it with MEMSQL.

Vendor Response

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

Replied October 2019

Manisha

Retail, 10,000+ employees

Used daily for more than 2 years

Review Source: Capterra
This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you.

OVERALL RATING:

5

EASE OF USE

5

VALUE FOR MONEY

4

CUSTOMER SUPPORT

4

FUNCTIONALITY

4

Reviewed September 2019

Very fast

PROS

fast response, perfect for real time apps

CONS

documentation isnot too clear about what sits in memory and what on disk. even though all our tables were made to reside on disk, we were getting lots of usage alerts, took for ever to resolve.

Reasons for switching to SingleStore

Faster reads and aggs and ability to query on rolling index