ClickHouse

ClickHouse

5.0 out of 5 stars
CockroachDB

CockroachDB

Cockroach Labs
4.0 out of 5 stars
ClickHouse CockroachDB

Related Products

  • Google Cloud BigQuery
    4.5 out of 5 stars 2,037 Ratings
    Visit Website for Google Cloud BigQuery
  • DbVisualizer
    4.8 out of 5 stars 593 Ratings
    Visit Website for DbVisualizer
  • Google Cloud SQL
    4.5 out of 5 stars 554 Ratings
    Visit Website for Google Cloud SQL
  • RaimaDB
    4.8 out of 5 stars 12 Ratings
    Visit Website for RaimaDB
  • Couchbase
    4.4 out of 5 stars 418 Ratings
    Visit Website for Couchbase
  • BidJS
    4.5 out of 5 stars 37 Ratings
    Visit Website for BidJS
  • Crelate
    4.5 out of 5 stars 699 Ratings
    Visit Website for Crelate
  • Muzaic
    5.0 out of 5 stars 2 Ratings
    Visit Website for Muzaic
  • 10Duke
    4.8 out of 5 stars 8 Ratings
    Visit Website for 10Duke
  • ClickLearn
    4.4 out of 5 stars 67 Ratings
    Visit Website for ClickLearn
ClickHouse:

About

ClickHouse is a fast open-source OLAP database management system. It is column-oriented and allows to generate analytical reports using SQL queries in real-time. ClickHouse's performance exceeds comparable column-oriented database management systems currently available on the market. It processes hundreds of millions to more than a billion rows and tens of gigabytes of data per single server per second. ClickHouse uses all available hardware to its full potential to process each query as fast as possible. Peak processing performance for a single query stands at more than 2 terabytes per second (after decompression, only used columns). In distributed setup reads are automatically balanced among healthy replicas to avoid increasing latency. ClickHouse supports multi-master asynchronous replication and can be deployed across multiple datacenters. All nodes are equal, which allows avoiding having single points of failure.
CockroachDB:

About

CockroachDB: Cloud-native, distributed SQL. Your cloud applications deserve a cloud-native database. Cloud-based apps and services deserve a database that scales across clouds, eases operational complexity, and improves reliability. CockroachDB delivers resilient, distributed SQL with ACID transactions and data partitioned by location. Automate operations for mission-critical applications by pairing CockroachDB with orchestration tools like Kubernetes and Mesosphere DC/OS. Every node can service both reads and writes so that you can scale query throughput and database capacity by simply adding more endpoints. Just add new nodes to CockroachDB, and it automatically rebalances data, completely removing the pain of manual sharding. As demand shifts, CockroachDB detects hotspots and intelligently distributes data to maintain performance. Tune your database at the row level so that data lives close to your users and you can minimize query latency.
ClickHouse:

Platforms Supported

Windows Not Supported
Mac Not Supported
Linux Not Supported
Cloud Supported
On-Premises Supported
iPhone Not Supported
iPad Not Supported
Android Not Supported
Chromebook Not Supported
CockroachDB:

Platforms Supported

Windows Not Supported
Mac Not Supported
Linux Not Supported
Cloud Supported
On-Premises Not Supported
iPhone Not Supported
iPad Not Supported
Android Not Supported
Chromebook Not Supported
ClickHouse:

Audience

Companies of all sizes
CockroachDB:

Audience

IT teams and anyone seeking a solution to manage their applications
ClickHouse:

Support

Phone Support Not Supported
24/7 Live Support Not Supported
Online Not Supported
CockroachDB:

Support

Phone Support Supported
24/7 Live Support Not Supported
Online Supported
ClickHouse:

API

Offers API Not Supported
CockroachDB:

API

Offers API Not Supported
ClickHouse:

Screenshots and Videos

CockroachDB:

Screenshots and Videos

ClickHouse:

Pricing

No information available.
Free Version Supported
Free Trial Not Supported
CockroachDB:

Pricing

No information available.
Free Version Not Supported
Free Trial Not Supported
ClickHouse:

Reviews/Ratings

Overall 5.0 / 5
ease 3.0 / 5
features 4.0 / 5
design 5.0 / 5
support 5.0 / 5
CockroachDB:

Reviews/Ratings

Overall 4.0 / 5
ease 4.0 / 5
features 5.0 / 5
design 5.0 / 5
support 5.0 / 5
ClickHouse:

Pros & Cons from Real Users

Pros

  • ClickHouse is really really fast. I can say that it is THE fastest I've came across. It has lots of native integration options S3, Kafka, SQLite, PostgreSQL and so on. Its SQL capabilities are top notch. And it is 100% free!

Cons

  • - Updates and deletes are eventual. - Hard to setup a cluster. - Does not have ACID.
CockroachDB:

Pros & Cons from Real Users

Pros

  • - It is packed with features like Geo-partitioning, live cluster scaling, ACID properties and many more. - It works efficiently on heavy traffic projects. - It supports all modern languages like JavaScript and Python.

Cons

  • - There are some performance issues regarding transactional support with Java. - It gets pretty complex when used with the Geolocation feature.
ClickHouse:

Training

Documentation Not Supported
Webinars Not Supported
Live Online Not Supported
In Person Not Supported
CockroachDB:

Training

Documentation Supported
Webinars Not Supported
Live Online Not Supported
In Person Not Supported
ClickHouse:

Company Information

ClickHouse
Founded: 2021
United States
clickhouse.com
CockroachDB:

Company Information

Cockroach Labs
Founded: 2015
United States
www.cockroachlabs.com
ClickHouse:

Alternatives

CockroachDB:

Alternatives

ClickHouse:
CockroachDB:
Apache Cassandra

Apache Cassandra

Apache Software Foundation
5.0 out of 5 stars
ClickHouse:
CockroachDB:
Citus

Citus

Citus Data
ClickHouse:
CockroachDB:
SingleStore

SingleStore

5.0 out of 5 stars
ClickHouse:
CockroachDB:
ClickHouse:

Categories

CockroachDB:

Categories

CockroachDB:

Database Features

Backup and Recovery Supported
Creation / Development Supported
Data Migration Supported
Data Replication Supported
Data Search Supported
Data Security Supported
Database Conversion Supported
Mobile Access Supported
Monitoring Supported
NOSQL Supported
Performance Analysis Supported
Queries Supported
Relational Interface Supported
Virtualization Supported

Cloud Management Features

Access Control Supported
Billing & Provisioning Supported
Capacity Analytics Supported
Cost Management Supported
Demand Monitoring Supported
Multi-Cloud Management Supported
Performance Analytics Supported
SLA Management Supported
Supply Monitoring Supported
Workflow Approval Supported

Relational Database Features

ACID Compliance Supported
Data Failure Recovery Supported
Multi-Platform Supported
Referential Integrity Supported
SQL DDL Support Supported
SQL DML Support Supported
System Catalog Supported
Unicode Support Supported
ClickHouse:

Integrations

Airbyte Supported
AtomicJar Supported
BI Book Supported
Bytebase Supported
ChartDB Supported
Chat2DB Supported
DataGrip Supported
DbGate Supported
Draxlr Supported
ElevateHQ Supported
Endeavor Supported
Grok Bot Supported
Latitude Supported
Netdata Supported
OpenMetadata Supported
Peaka Supported
Streamkap Supported
VisuaLeaf Supported
Zenskar Supported
arcodash Supported
CockroachDB:

Integrations

Airbyte Supported
AtomicJar Supported
BI Book Supported
Bytebase Supported
ChartDB Supported
Chat2DB Supported
DataGrip Supported
DbGate Supported
Draxlr Supported
ElevateHQ Supported
Endeavor Supported
Grok Bot Supported
Latitude Supported
Netdata Supported
OpenMetadata Supported
Peaka Supported
Streamkap Supported
VisuaLeaf Supported
Zenskar Supported
arcodash Supported
ClickHouse:
Claim ClickHouse and update features and information
Claim ClickHouse and update features and information
CockroachDB:
Claim CockroachDB and update features and information
Claim CockroachDB and update features and information