DB-EnginesextremeDB - solve IoT connectivity disruptionsEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by Redgate Software

DBMS > CockroachDB vs. CrateDB vs. HarperDB

System Properties Comparison CockroachDB vs. CrateDB vs. HarperDB

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameCockroachDB  Xexclude from comparisonCrateDB  Xexclude from comparisonHarperDB  Xexclude from comparison
DescriptionCockroachDB 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.Distributed Database based on LuceneHarperDB takes the "stack" out of "tech stack" by combining an ultra-fast document-style data store, in-memory cache, real-time message broker, and your application components into a single distributed technology.
Primary database modelRelational DBMSDocument store
Spatial DBMS
Search engine
Time Series DBMS
Vector DBMS
Document store
Secondary database modelsRelational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score4.45
Rank#66  Overall
#36  Relational DBMS
Score0.72
Rank#222  Overall
#37  Document stores
#5  Spatial DBMS
#15  Search engines
#18  Time Series DBMS
#10  Vector DBMS
Score0.56
Rank#242  Overall
#38  Document stores
Websitewww.cockroachlabs.comcratedb.comwww.harperdb.io
Technical documentationwww.cockroachlabs.com/­docscratedb.com/­docsdocs.harperdb.io/­docs
DeveloperCockroach LabsCrateHarperDB
Initial release201520132017
Current release24.1.0, May 20243.1, August 2021
License infoCommercial or Open SourceOpen Source infoApache 2.0, commercial license availableOpen Sourcecommercial infofree community edition available
Cloud-based only infoOnly available as a cloud servicenonono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageGoJavaNode.js
Server operating systemsLinux
macOS
Windows
All Operating Systems, including Kubernetes with CrateDB Kubernetes Operator supportLinux
OS X
Data schemedynamic schemaFlexible Schema (defined schema, partial schema, schema free)dynamic schema
Typing infopredefined data types such as float or dateyesyesyes infoJSON data types
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.nonono
Secondary indexesyesyesyes
SQL infoSupport of SQLyes, wire compatible with PostgreSQLyes, but no triggers and constraints, and PostgreSQL compatibilitySQL-like data manipulation statements
APIs and other access methodsJDBCADO.NET
JDBC
ODBC
PostgreSQL wire protocol
Prometheus Remote Read/Write
RESTful HTTP API
JDBC
ODBC
React Hooks
RESTful HTTP/JSON API
WebSocket
Supported programming languagesC#
C++
Clojure
Go
Java
JavaScript (Node.js)
PHP
Python
Ruby
Rust
.NET
Erlang
Go infocommunity maintained client
Java
JavaScript (Node.js) infocommunity maintained client
Perl infocommunity maintained client
PHP
Python
R
Ruby infocommunity maintained client
Scala infocommunity maintained client
.Net
C
C#
C++
ColdFusion
D
Dart
Delphi
Erlang
Go
Haskell
Java
JavaScript (Node.js)
Lisp
MatLab
Objective C
Perl
PHP
PowerShell
Prolog
Python
R
Ruby
Rust
Scala
Swift
Server-side scripts infoStored proceduresnouser defined functions (Javascript)Custom Functions infosince release 3.1
Triggersnonono
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 RAFTShardingA table resides as a whole on one (or more) nodes in a cluster
Replication methods infoMethods for redundantly storing data on multiple nodesMulti-source replication using RAFTConfigurable replication on table/partition-levelyes infothe nodes on which a table resides can be defined
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyEventual Consistency
Read-after-write consistency on record level
Immediate Consistency
Foreign keys infoReferential integrityyesnono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDno infounique row identifiers can be used for implementing an optimistic concurrency control strategyAtomic execution of specific operations
Concurrency infoSupport for concurrent manipulation of datayesyesyes
Durability infoSupport for making data persistentyesyesyes, using LMDB
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.nonoyes
User concepts infoAccess controlRole-based access controlrights management via user accountsAccess rights for users and roles

More information provided by the system vendor

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
CockroachDBCrateDBHarperDB
Recent citations in the news

Cockroach Labs Deepens Partnership with Google Cloud, CockroachDB Selected to Join Google Distributed Cloud
9 April 2024, PR Newswire

DoorDash Uses CockroachDB to Create Config Management Platform for Microservices
14 February 2024, InfoQ.com

CockroachDB tempts legacy databases to crawl into the cloud age
29 January 2024, The Register

How to Unlock Real-Time Data Streams with CockroachDB and Amazon MSK | Amazon Web Services
6 November 2023, AWS Blog

How DoorDash Migrated from Aurora Postgres to CockroachDB
5 December 2023, The New Stack

provided by Google News

CrateDB Appoints Jeff Olson as New CRO
9 July 2024, PR Newswire

CrateDB Announces Availability of CrateDB on Google Cloud Marketplace
8 April 2024, Datanami

Real-Time SQL Is What’s Making CrateDB Such A Hit In The IoT Market
16 July 2024, AIM

CrateDB Appoints Sergey Gerasimenko as New CTO
19 February 2024, PR Newswire

How We Designed CrateDB as a Realtime SQL DBMS for the Internet of Things
29 August 2017, The New Stack

provided by Google News

HarperDB Attracts Significant Growth Investment from Serent Capital
12 June 2024, Business Wire

Serent Capital invests in software firm HarperDB
12 June 2024, PE Hub

HarperDB Receives Growth Investment from Serent Capital
12 June 2024, FinSMEs

Startups of the Year 2023: Meet HarperDB - A Database and Application Development Platform
22 June 2023, hackernoon.com

Unlocking immersive golfing experiences with AWS Wavelength
29 November 2022, AWS Blog

provided by Google News



Share this page

Featured Products

Neo4j logo

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

Datastax Astra logo

Bring all your data to Generative AI applications with vector search enabled by the most scalable
vector database available.
Try for Free

Milvus logo

Vector database designed for GenAI, fully equipped for enterprise implementation.
Try Managed Milvus for Free

SingleStore logo

The database to transact, analyze and contextualize your data in real time.
Try it today.

RaimaDB logo

RaimaDB, embedded database for mission-critical applications. When performance, footprint and reliability matters.
Try RaimaDB for free.

Present your product here