DB-EnginesExtremeDB: the mission critical dbmsEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > ClickHouse vs. CockroachDB vs. HEAVY.AI vs. QuestDB

System Properties Comparison ClickHouse vs. CockroachDB vs. HEAVY.AI vs. QuestDB

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameClickHouse  Xexclude from comparisonCockroachDB  Xexclude from comparisonHEAVY.AI infoFormerly named 'OmniSci', rebranded to 'HEAVY.AI' in March 2022  Xexclude from comparisonQuestDB  Xexclude from comparison
DescriptionColumn-oriented Relational DBMS powering YandexCockroachDB is a distributed database architected for modern cloud applications. It is wire compatible with PostgreSQL and backed by a Key-Value Store, which is either RocksDB or a purpose-built derivative, called Pebble.A high performance, column-oriented RDBMS, specifically developed to harness the massive parallelism of modern CPU and GPU hardwareA high performance open source SQL database for time series data
Primary database modelRelational DBMSRelational DBMSRelational DBMSTime Series DBMS
Secondary database modelsTime Series DBMSSpatial DBMSRelational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score13.67
Rank#44  Overall
#28  Relational DBMS
Score7.40
Rank#58  Overall
#34  Relational DBMS
Score2.26
Rank#126  Overall
#62  Relational DBMS
Score1.74
Rank#147  Overall
#13  Time Series DBMS
Websiteclickhouse.techwww.cockroachlabs.comgithub.com/­heavyai/­heavydb
www.heavy.ai
questdb.io
Technical documentationclickhouse.tech/­docswww.cockroachlabs.com/­docsdocs.heavy.aiquestdb.io/­docs/­introduction
DeveloperClickhouse Inc.Cockroach LabsHEAVY.AI, Inc.QuestDB Limited
Initial release2016201520162014
Current releasev22.8.5.29-lts, September 202221.1.2, June 20215.10, January 2022
License infoCommercial or Open SourceOpen Source infoApache 2.0Open Source infoApache 2.0, commercial license availableOpen Source infoApache Version 2; enterprise edition availableOpen Source infoApache 2.0
Cloud-based only infoOnly available as a cloud servicenononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
CockroachDB: A cloud-native, distributed SQL database designed for speed, scale, and survival. Get started for free today with a fully-managed CockroachDB cluster -- leave operations behind and get your app to market faster.
Implementation languageC++GoC++ and CUDAJava
Server operating systemsFreeBSD
Linux
macOS
Linux
macOS
Windows
LinuxLinux
macOS
Windows
Data schemeyesdynamic schemayesyes infoschema-free via InfluxDB Line Protocol
Typing infopredefined data types such as float or dateyesyesyesyes
XML support infoSome form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.nononono
Secondary indexesyes, when using the MergeTree engineyesnono
SQL infoSupport of SQLClose to ANSI SQLyes, wire compatible with PostgreSQLyesSQL-like query language
APIs and other access methodsHTTP REST
JDBC
ODBC
Proprietary protocol
JDBCJDBC
ODBC
Thrift
Vega
HTTP REST
InfluxDB Line Protocol (TCP/UDP)
JDBC
Supported programming languagesC# info3rd party library
C++
Elixir info3rd party library
Go info3rd party library
Java info3rd party library
JavaScript (Node.js) info3rd party library
Kotlin info3rd party library
Nim info3rd party library
Perl info3rd party library
PHP info3rd party library
Python info3rd party library
R info3rd party library
Ruby info3rd party library
Scala info3rd party library
C#
C++
Clojure
Go
Java
JavaScript (Node.js)
PHP
Python
Ruby
Rust
All languages supporting JDBC/ODBC/Thrift
Python
C infoPostgreSQL driver
C++
Go
Java
JavaScript (Node.js)
Python
Rust infoover HTTP
Server-side scripts infoStored proceduresnononono
Triggersnononono
Partitioning methods infoMethods for storing different data on different nodeshorizontal partitioning (by key range) infoall tables are translated to an ordered KV store and then broken down into 64MB ranges, which are then used as replicas in RAFTSharding infoRound robinhorizontal partitioning (by timestamps)
Replication methods infoMethods for redundantly storing data on multiple nodesMulti-source replication using RAFTMulti-source replicationConfigurable consistency for N replicas
MapReduce infoOffers an API for user-defined Map/Reduce methodsnononono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynoyesnono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanoACIDnoACID for single-table writes
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes
Durability infoSupport for making data persistentyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesnoyesyes infothrough memory mapped files
User concepts infoAccess controlAccess rights for users and rolesRole-based access controlfine grained access rights according to SQL-standard
More information provided by the system vendor
ClickHouseCockroachDBHEAVY.AI infoFormerly named 'OmniSci', rebranded to 'HEAVY.AI' in March 2022QuestDB
Specific characteristicsCockroachDB is a cloud-native, distributed SQL database architected for modern applications....
» more
Relational model with native time series support Column based storage and time partitioned...
» more
Competitive advantages- EFFORTLESS SCALE: Scale your applications, not operational complexity. CockroachDB...
» more
Real-time data ingestion and istant SQL queries for time series High performance...
» more
Typical application scenariosSystem of record (financial ledger, inventory management, transaction record), identity...
» more
Application metrics Financial market data and algo trading DevOps monitoring Real-time...
» more
Key customersComcast, DoorDash, Mythical Games, Norfolk Southern, LUSH, Bose, Shipt, Bitski, Five9,...
» more
Market metrics8K+ long-running clusters 2.5K+ CockroachDB self-hosted clusters 20K+ CockroachDB...
» more
Licensing and pricing models- Apache 2.0 for core features released up to and including the 19.1 release - Time-limited...
» more
Apache 2.0.
» more
News

Listen to Your CPU - Full-table Scans Are Fast
30 November 2022

QuestDB 6.6.1 - Dynamic Commits
25 November 2022

SQL Extensions for Time Series Data in QuestDB - Part II
23 November 2022

QuestDB 6.5.5 Release
14 November 2022

QuestDB at Devoxx Belgium 2022
8 November 2022

We invite representatives of system vendors to contact us for updating and extending the system information,
and for displaying vendor-provided information such as key customers, competitive advantages and market metrics.

Related products and services

We invite representatives of vendors of related products to contact us for presenting information about their offerings here.

More resources
ClickHouseCockroachDBHEAVY.AI infoFormerly named 'OmniSci', rebranded to 'HEAVY.AI' in March 2022QuestDB
Recent citations in the news

ClickHouse launches ClickHouse Cloud, extends its Series B
6 December 2022, TechCrunch

Seattle data analytics startup MotherDuck emerges from stealth, reveals $47.5M in funding
15 November 2022, GeekWire

Aiven improves access to open source data technologies with new ClickHouse offering
14 September 2022, VentureBeat

Storage news roundup – Blocks and Files
7 November 2022, Blocks and Files

Two Sizes Fit Most: PostgreSQL and ClickHouse
13 April 2022, thenewstack.io

provided by Google News

CockroachDB Introduces Functions to Increase Development Efficiency and Unlock Easier Migrations to the Cloud
6 December 2022, PR Newswire

Hasura Native Integrations with CockroachDB and AWS Athena Give Users Fast, Resilient, Secure GraphQL APIs Instantly
8 November 2022, Business Wire

In Conversation with Spencer Kimball, CEO, Cockroach Labs
17 November 2022, mattturck.com

Cockroach Labs debuts serverless edition of its popular CockroachDB database
21 September 2022, SiliconANGLE News

CockroachDB adds command line tool as database hits version 22.1
24 May 2022, The Register

provided by Google News

GPU Database Global Market Report 2022: Increasing Preference of Enterprises Toward AI and Machine Learning Facilitated Workloads Presents Opportunities - ResearchAndMarkets.com
9 November 2022, businesswire.com

HEAVY.AI Launches Industry's First Digital Twin for Telco Network Planning, Building and Operations
20 September 2022, Datanami

The Mobile Network » Accelerated analytics for telco? It's in the hardware
28 September 2022, The Mobile Network

The insideBIGDATA IMPACT 50 List for Q4 2022
12 October 2022, insideBIGDATA

$1000+ Mn GPU Database Market Size to Grow at 19.1% CAGR, Globally, by 2028 - Emergence of Advanced Technologies: Internet of Things, Internet of Behaviors, Artificial Intelligence, Machine Learning | The Insight Partners
4 October 2022, Yahoo Finance

provided by Google News

QuestDB Selected by Aquis Exchange to Power Its Financial Exchange Infrastructure
1 November 2022, GlobeNewswire

QuestDB snares $12M Series A with hosted version coming soon
3 November 2021, TechCrunch

QuestDB nabs $2.3M seed to build open source time series database
2 July 2020, TechCrunch

Read the Pitch Deck Database Startup QuestDB Used to Raise $12 Million
11 November 2021, Business Insider

InfluxDB Cloud overhauls time series database engine
26 October 2022, TechTarget

provided by Google News

Job opportunities

Database Engineer
Jump Trading, Chicago, IL

QA Engineer
Databento, Inc., Remote

ClickHouse Server (C++) Engineer
Altinity, Inc., United States

Golang Developer
Altinity, Inc., United States

Cloud Service Security Engineer
Altinity, Inc., North, SC

Sr Developer - Node JS
Photon, Bellevue, WA

.NET Developer
Skillspark AB, Remote

Distributed Systems Engineer (L4) - Data Platform
Netflix, Remote

Web Developer PHP/SQL
Round Sky, Las Vegas, NV

Software Engineer (L5) - Membership Engineering
Netflix, California

Senior Data Analyst (Remote)
Cambridge Technology Enterprises (CTE), Remote

Software Engineer III
Bank of America, Chicago, IL

Senior Full Stack Developer
Nomad GCS, Columbia Falls, MT

jobs by Indeed



Share this page

Featured Products

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Neo4j logo

See for yourself how a graph database can make your life easier.
Use Neo4j online for free.

AllegroGraph logo

Graph Database Leader for AI Knowledge Graph Applications - The Most Secure Graph Database Available.
Free Download

Redis logo

The world’s most loved real‑time data platform.
Try free

The definitive guide for Cassandra

Imagine What You Could Do if Scalability Wasn‘t a Problem!
Download the Cassandra e-book for free!

Present your product here