TrustRadius
Overview
ProductRatingMost Used ByProduct SummaryStarting Price
CockroachDB
Score 6.7 out of 10
N/A
CockroachDB is a distributed SQL database from Cockroach Labs in New York. It is designed to give users resilient, horizontal scale across multiple clouds with always-on availability and data partitioned by location. CockroachDB scales horizontally without reconfiguration or need for a massive architectural overhaul. CockroachDB Core is open-source, while the Enterprise edition is not but includes additional features (e.g. distributed backup and restore, geo-partitioning, etc.). Finally,…N/A
SingleStore
Score 7.5 out of 10
N/A
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.
$0.69
per hour
Pricing
CockroachDBSingleStore
Editions & Modules
No answers on this topic
OnDemand
$0.69
per hour
Offerings
Pricing Offerings
CockroachDBSingleStore
Free Trial
NoYes
Free/Freemium Version
YesYes
Premium Consulting/Integration Services
NoNo
Entry-level Setup FeeNo setup feeOptional
Additional Details——
More Pricing Information
Community Pulse
CockroachDBSingleStore
Considered Both Products
CockroachDB

No answer on this topic

SingleStore
Victor Cáceres | TrustRadius Reviewer
Victor Cáceres
Database Administrator (DBA)
Chose SingleStore
I can only compare it with Exasol, which I have used a similar base, which manages the Hadoop scheme and is very similar to SingleStore. SingleStore has many advantages: being in the cloud, with just a couple of clicks I can increase the capacity, the configuration is super …
Verified User
Anonymous
Chose SingleStore
first of all SingleStoreis a cluster with high availability and easy to use.
you need to design you tables / procedures such in a way that your SingleStore perform well and with handle heavy load
Verified User
Anonymous
Chose SingleStore
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 …
Verified User
Anonymous
Chose SingleStore
SingleStore (memsql) out performs based on our analysis with sample data sets within org. We could see limitations with other products which SingleStore can overcall like scaling with data while performing with similar SLA. It also has the advantage of row store and column …
Verified User
Anonymous
Chose SingleStore
Efficient and faster data ingestion was primary criteria.
Verified User
Anonymous
Chose SingleStore
SingleStore outperforms Snowflake in real-time analytics and transactional workloads but lags in large-scale batch processing. Compared to MongoDB Atlas, SingleStore excels in complex SQL queries and joins, while MongoDB handles unstructured, document-based data better. Its …
Verified User
Anonymous
Chose SingleStore
Greenplum is good in handling very large amount of data. Concurrency in Greenplum was a major problem. Features available in SingleStore like Pipelines and in memory features are not available in Greenplum.

Gemfire was not scaling well like SingleStore. Support of both …
Verified User
Anonymous
Chose SingleStore
We previously used Bigquery for our application, and a single store gave us very good performance over Bigquery. But the comparison is not apples to apples, as Bigquery is more of a data warehousing solution.
Verified User
Anonymous
Chose SingleStore
SingleStore is just a bigger engine with more capability. Its ability to handle larger data sets with ease is its biggest advantage. These other database solutions are great for smaller scale projects that don't include large data sets but Singlestore greatly out performs in …
Verified User
Anonymous
Chose SingleStore
DynamoDB was fast but no ability to do OLAP queries

Aurora couldn't handle our data scale at all
Verified User
Anonymous
Chose SingleStore
It has more APIs and other access methods. It has a multi-version concurrency control (MVCC) Distributed RDBMS that combines an in-memory row-oriented and a disc-based column-oriented storage with patented universal storage to handle transactional and analytical workloads in …
Verified User
Anonymous
Chose SingleStore
Its easier to query and faster. Ingestion is for the most part easier to understand and monitor and directly integrated with other storage solution products we use such as AWS S3. Singlestore overall is a better database to serve up an application large amounts of data very …
Chose SingleStore
ClickHouse - would still require us to have a separate db.
ElasticSearch - seemed too complex for us.
Verified User
Anonymous
Chose SingleStore
SingleStore provided the best performance for our need to slice and dice for a large columnar dataset.
Verified User
Anonymous
Chose SingleStore
SingleStore is built for fast data ingestion and fast queries against large tables (> billions of rows). This is possible because of the column store engine that SingleStore uses. SingleStore also support a memory engine. Pipelines is also another big advantage. Being able to …
Verified User
Anonymous
Chose SingleStore
SingleStore has outperformed these in speed and performance. However it is more expensive but has been worth the cost so far.
Jon Milsom | TrustRadius Reviewer
Jon Milsom
Co-Founder & CTO
Chose SingleStore
We knew early on that MySQL (Amazon Aurora) would not be suitable for this workload as it cannot query our time series data as fast as SingleStore. We also use MongoDB Atlas for another application but we could not achieve the raw speed we saw from SingleStore. Our technical …
Verified User
Anonymous
Chose SingleStore
We were initially using AWS Aurora which worked well at the time but as we grew it just felt like a lumbering beast - even with tier upgrades. We started looking at caching & search options to help make searches faster - we were already using redis. We looked at and even …
Charlie Joseph | TrustRadius Reviewer
Charlie Joseph
Head of Analytics
Chose SingleStore
Timescale was the biggest alternative option we looked at for SingleStore, however the requirement to learn a new syntax (due to not being SQL compatible) was our biggest pain point.

Supporting a new language would require alterations to the Laravel framework, as this only …
Verified User
Anonymous
Chose SingleStore
SingleStore provides an abstraction layer in managing a sharded database solution reducing complexity for the FLOWD team. Coupled with the SingleStore Managed Service, we are partnering with SingleStore to provide FLOWD services to various utilities & councils.
Verified User
Anonymous
Chose SingleStore
SingleStore is eons faster than other database providers, and it absolutely crushes calculations & aggregations. While other providers may have a few quality of life enhancements over SingleStore, the speed benefits of SS far outweigh the cons. At the end of the day, speed …
Verified User
Anonymous
Chose SingleStore
SingleStore provides performance for real-time data analytics application where as Snowflake is more for data engineers and not fast enough for real-time data analytics apps.
Verified User
Anonymous
Chose SingleStore
As I said before, we felt that running queries on BigQuery for every query is really slow, especially from an user point of view. After seeing the drastically improved latency of SingleStore we decided to use to solve this issue. We currently use it to run low volume queries …
Verified User
Anonymous
Chose SingleStore
SingleStore was the fastest sql database we have tried, allowing for analytical queries on TBs of data.
Best Alternatives
CockroachDBSingleStore
Small Businesses
InterSystems IRIS
InterSystems IRIS
Score 7.7 out of 10
InterSystems IRIS
InterSystems IRIS
Score 7.7 out of 10
Medium-sized Companies
InterSystems IRIS
InterSystems IRIS
Score 7.7 out of 10
InterSystems IRIS
InterSystems IRIS
Score 7.7 out of 10
Enterprises
SAP IQ
SAP IQ
Score 10.0 out of 10
SAP IQ
SAP IQ
Score 10.0 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
CockroachDBSingleStore
Likelihood to Recommend
-
(0 ratings)
7.6
(0 ratings)
Likelihood to Renew
-
(0 ratings)
8.2
(0 ratings)
Usability
-
(0 ratings)
8.2
(0 ratings)
Availability
-
(0 ratings)
9.1
(0 ratings)
Performance
-
(0 ratings)
8.2
(0 ratings)
Support Rating
-
(0 ratings)
8.3
(0 ratings)
Online Training
-
(0 ratings)
7.3
(0 ratings)
Implementation Rating
-
(0 ratings)
7.3
(0 ratings)
Ease of integration
-
(0 ratings)
9.1
(0 ratings)
Product Scalability
-
(0 ratings)
8.2
(0 ratings)
Vendor post-sale
-
(0 ratings)
8.2
(0 ratings)
Vendor pre-sale
-
(0 ratings)
8.2
(0 ratings)
User Testimonials
CockroachDBSingleStore
Likelihood to Recommend
No answers on this topic
Well-Suited Scenarios: Real-Time Analytics: Financial trading platforms requiring instant insights. Operational Dashboards: Retail businesses monitoring live sales. IoT Data Processing: Smart device monitoring with high data ingestion. Fraud Detection: Banks detect suspicious transactions instantly. Less Appropriate Scenarios: Archival Storage: Cold data storage with infrequent access. Low-Volume Workloads: Small-scale apps with minimal data processing needs. Complex ETL Pipelines: Heavy data transformations without real-time demands.
Verified User
Anonymous
Read full review
Pros
No answers on this topic
  • Return results of complex queries scanning TBs of data in sub-seconds.
  • Customer support team answer tickets quickly and provide guidance.
  • MySQL engine which allows to query using simple MySQL drivers from different clients.
  • Queries profiling is easy to use and helps investigating performance.
Verified User
Anonymous
Read full review
Cons
No answers on this topic
  • It does not release a patch to have back porting; it just releases a new version and stops support; it's difficult to keep up to that pace.
  • Support engineers lack expertise, but they seem to be improving organically.
  • Lacks enterprise CDC capability: Change data capture (CDC) is a process that tracks and records changes made to data in a database and then delivers those changes to other systems in real time.
  • For enterprise-level backup & restore capability, we had to implement our model via Velero snapshot backup.
Verified User
Anonymous
Read full review
Likelihood to Renew
No answers on this topic
We haven't seen a faster relation database. Period. Which is why we are super happy customers and will for sure renew our license.
Verified User
Anonymous
Read full review
Usability
No answers on this topic
[Until it is] supported on AWS ECS containers, I will reserve a higher rating for SingleStore. Right now it works well on EC2 and serves our current purpose, [but] would look forward to seeing SingleStore respond to our urge of feature in a shorter time period with high quality and security.
Verified User
Anonymous
Read full review
Reliability and Availability
No answers on this topic
I really can't remember a time when it was not available
Verified User
Anonymous
Read full review
Performance
No answers on this topic
When it comes to ingestion speed, SingleStore is probably at the top. Being able to create pipelines using SQL to ingest data from S3, Kafka, and other sources, is a great advantages. This means you can dynamically ingest data by customizing your SQL queries. SingleStore pipelines are pretty sophisticated, yet very simple. Few lines of codes and you are ingesting data, while still able to perform analytical queries on your billions of row tables.
Verified User
Anonymous
Read full review
Support Rating
No answers on this topic
The support deep dives into our most complexed queries and bizarre issues that sometimes only we get comparing to other clients. Our special workload (thousands of Kafka pipelines + high concurrency of queries). The response match to the priority of the request, P1 gets immediate return call. Missing features are treated, they become a client request and being added to the roadmap after internal consideration on all client needs and priority. Bugs are patched quite fast, depends on the impact and feasible temporary workarounds. There is no issue that we haven't got a proper answer, resolution or reasoning
Ziv Fridfertig | TrustRadius Reviewer
Ziv Fridfertig
Dev Enablement Director
Read full review
Online Training
No answers on this topic
Would prefer in person training but for online training, it's almost as good as in person
Verified User
Anonymous
Read full review
Implementation Rating
No answers on this topic
We allowed 2-3 months for a thorough evaluation. We saw pretty quickly that we were likely to pick SingleStore, so we ported some of our stored procedures to SingleStore in order to take a deeper look. Two SingleStore people worked closely with us to ensure that we did not have any blocking problems. It all went remarkably smoothly.
Verified User
Anonymous
Read full review
Alternatives Considered
No answers on this topic
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.
Verified User
Anonymous
Read full review
Scalability
No answers on this topic
Very reliable. Coming from mariadb, singlestore has made our application more reliable and faster!
Verified User
Anonymous
Read full review
Return on Investment
No answers on this topic
  • Lower operational complexity - Installation and maintenance is pretty easy
  • Object scale when used can compete with Traditional Warehouse Systems like Teradata, Netezza, Greenplum
  • Adds lot of value to the business like couple of operations which never worked in traditional DBMS including HANA, Oracle In Memory, SQL Server In Memory just flew in SingleStore
Verified User
Anonymous
Read full review
ScreenShots