Database Software
...
SingleStore
spotlight

SingleStore

TOP FEATURES
Top Features
SingleStore
by SingleStore
  • 5.0
    Backup and Recovery
  • 5.0
    Database Conversion
  • 4.5
    Access Controls/Permissions
  • 4.5
    Data Replication
  • 4.3
    Data Migration
OTHER USERS CHOSE
Caspio
4.6 (194)
  • 4.7
    Backup and Recovery
  • 4.5
    Database Conversion
  • 4.4
    Access Controls/Permissions
  • 4.6
    Data Replication
  • 5.0
    Data Migration
visit website

SingleStore Reviews

Showing 5 of 38 reviews
Overall
4.5
Ease of Use
4.5
Customer Service
4.3
  • "Good product with good core competencies - scalable SQL database designed for transactional and analytical workloads, consistency durability etc."
  • "The performance of this db its is amazing. The team assigned to our project did a great work by migrating a huge system in a short period of time."
  • "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."
  • "Lack of recoverable snapshots. All these are near term upcoming features in MemSQL though)."
  • "Problem of streaming analytics on high-velocity high volume data sets with sub-second API responses can be a handful."
  • "I reported my disappointment towards SingleStore, and after all they are working on improving this mow."

Pros

  • "Good product with good core competencies - scalable SQL database designed for transactional and analytical workloads, consistency durability etc."
  • "The performance of this db its is amazing. The team assigned to our project did a great work by migrating a huge system in a short period of time."
  • "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."

Cons

  • "Lack of recoverable snapshots. All these are near term upcoming features in MemSQL though)."
  • "Problem of streaming analytics on high-velocity high volume data sets with sub-second API responses can be a handful."
  • "I reported my disappointment towards SingleStore, and after all they are working on improving this mow."
Write a Review
Read All 38 Reviews
Avatar Image
Sujay K.
Sr Manager, Data Engineering - Data & AI
Computer & Network Security, 501-1000 employees
Used the software for: 1-2 years
Overall Rating
Ease of Use
Customer Service
Features
Value for Money
Likelihood to Recommend
Reviewer Source
Source: Capterra
December 26, 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.
Reasons 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.
Reviewer Source
Source: Capterra
December 26, 2019
Brandon V.
Data Modeler
Utilities, 10,001+ employees
Used the software for: 1-2 years
Overall Rating
Ease of Use
Customer Service
Features
Likelihood to Recommend
Reviewer Source
Source: Capterra
October 18, 2019
"Thoughts on MemSQL"
Overall: 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.
Reasons for Choosing SingleStore: We considered NoSQL products such as Hadoop, but we wanted to leverage our existing SQL skillset.
Switched From: Vantage
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

By SingleStore on October 28, 2019
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.
Reviewer Source
Source: Capterra
October 18, 2019
Verified Reviewer
Financial Services, 10,001+ employees
Used the software for: 2+ years
Overall Rating
Ease of Use
Customer Service
Features
Value for Money
Likelihood to Recommend
Reviewer Source
Source: Capterra
September 10, 2019
"MemSQL : Needs Time to Mature"
Overall: 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: Cost & future roadmap
Reasons for Switching to SingleStore: Scalability & Growing Cost
Reviewer Source
Source: Capterra
September 10, 2019
MOHAMMAD SUFIYAN A.
Senior Architect
Information Technology and Services, 10,001+ employees
Used the software for: 6-12 months
Overall Rating
Ease of Use
Customer Service
Features
Value for Money
Likelihood to Recommend
Reviewer Source
Source: Capterra
October 10, 2019
"SUPERSONIC DB - SUPERB"
Overall: 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.
Switched From: Vantage
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

By SingleStore on October 16, 2019
Supersonic is a great description. Thank you. Have you tried MemSQL Studio, the web-based SQL editor and cluster monitor?
Reviewer Source
Source: Capterra
October 10, 2019
Manisha S.
Tech Lead
Retail, 10,001+ employees
Used the software for: 2+ years
Overall Rating
Ease of Use
Customer Service
Features
Value for Money
Likelihood to Recommend
Reviewer Source
Source: Capterra
September 5, 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.
Switched From: Elastic Stack
Reasons for Switching to SingleStore: Faster reads and aggs and ability to query on rolling index
Reviewer Source
Source: Capterra
September 5, 2019
Read All 38 Reviews
Compare Alternatives
SingleStore
View Profile
Aiven for Postg...
Visit Website
Rubrik
Visit Website
Starting from:
Not provided by vendor
Starting from:
$19.00/Per-Month
Pricing Model:
Flat Rate
Starting from:
Not provided by vendor
Overall Rating:
4.5 (38)
  • Ease of Use
    4.5
  • Customer Service
    4.3
  • Features
    4.5
  • Value for Money
    4.2
Overall Rating:
4.7 (69)
  • Ease of Use
    4.7
  • Customer Service
    4.6
  • Features
    4.4
  • Value for Money
    4.2
Overall Rating:
4.7 (42)
  • Ease of Use
    4.7
  • Customer Service
    4.8
  • Features
    4.5
  • Value for Money
    4.4
Core Features
9/11
VIEW ALL COMPETITORS
Core Features
8/11
Core Features
5/11
VIEW FULL COMPARISON

SingleStore Pricing

Starting From:
Not provided by vendor
  • Yes, has free trial
  • Yes, has free version
Pricing Details (Provided by Vendor):
Contact SingleStore for pricing details.
Pricing Resources:
  • Be an Informed Buyer: Understanding the True Cost of Business Software
  • Database Software Pricing Guide

    • What is SingleStore?

    SingleStore delivers the world's fastest distributed SQL database for data-intensive applications: SingleStoreDB. By combining transactional + analytical workloads, SingleStore eliminates performance bottlenecks and unnecessary data movement to support constantly growing, demanding workloads. Customers spanning every vertical choose SingleStore to unleash the power of their data and supercharge real-time data experiences for their customers.

    Featured In

    Best For

    The world's leading brands rely on SingleStore to make the right business decisions, to deliver exceptional customer experiences, and to stay ahead of the competition.

    SingleStore Video and Images

    Deployment & Support

    Deployment
    • Cloud, SaaS, Web-Based
    • Desktop - Mac
    • Desktop - Windows
    • Desktop - Linux
    • Desktop - Chromebook
    • On-Premise - Windows
    • On-Premise - Linux
    • Mobile - Android
    • Mobile - iPhone
    • Mobile - iPad
    Support
    • 24/7 (Live Rep)
    • Chat
    Training
    • In Person
    • Live Online
    • Webinars
    • Documentation
    • Videos
    Contact Details
    • SingleStore
    • Located in United States
    • Founded in 2011
    • http://www.singlestore.com

    SingleStore Video