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

DBMS > Amazon DynamoDB vs. Citus vs. CockroachDB vs. CrateDB vs. Galaxybase

System Properties Comparison Amazon DynamoDB vs. Citus vs. CockroachDB vs. CrateDB vs. Galaxybase

Editorial information provided by DB-Engines
NameAmazon DynamoDB  Xexclude from comparisonCitus  Xexclude from comparisonCockroachDB  Xexclude from comparisonCrateDB  Xexclude from comparisonGalaxybase  Xexclude from comparison
DescriptionHosted, scalable database service by Amazon with the data stored in Amazons cloudScalable hybrid operational and analytics RDBMS for big data use cases based on PostgreSQLCockroachDB 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 Date Store based on LuceneScalable, ACID-compliant native distributed parallel graph platform
Primary database modelDocument store
Key-value store
Relational DBMSRelational DBMSRelational DBMS
Search engine
Graph DBMS
Secondary database modelsDocument storeDocument store
Time Series DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score87.26
Rank#15  Overall
#2  Document stores
#2  Key-value stores
Score1.71
Rank#134  Overall
#67  Relational DBMS
Score7.53
Rank#59  Overall
#33  Relational DBMS
Score0.94
Rank#183  Overall
#88  Relational DBMS
#13  Search engines
Score0.04
Rank#337  Overall
#35  Graph DBMS
Websiteaws.amazon.com/­dynamodbwww.citusdata.comwww.cockroachlabs.comcrate.iogalaxybase.com
Technical documentationdocs.aws.amazon.com/­dynamodbdocs.citusdata.comwww.cockroachlabs.com/­docscrate.io/­docs
DeveloperAmazonCockroach LabsCrateChuanglin(Createlink) Technology Co., Ltd 浙江创邻科技有限公司
Initial release20122010201520132017
Current release8.1, December 201821.1.2, June 2021Nov 20, November 2021
License infoCommercial or Open Sourcecommercial infofree tier for a limited amount of database operationsOpen Source infoAGPL, commercial license also availableOpen Source infoApache 2.0, commercial license availableOpen Sourcecommercial
Cloud-based only infoOnly available as a cloud serviceyesnononono
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 languageCGoJavaC and Java
Server operating systemshostedLinuxLinux
macOS
Windows
All OS with a Java 7 (and higher) VMLinux
Data schemeschema-freeyesdynamic schemaFlexible Schema (defined schema, partial schema, schema free)Strong typed schema
Typing infopredefined data types such as float or dateyesyesyesyesyes
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.yes infospecific XML type available, but no XML query functionalitynonono
Secondary indexesyesyesyesyesyes
SQL infoSupport of SQLnoyes infostandard, with numerous extensionsyes, wire compatible with PostgreSQLyes, but no triggers and constraintsno
APIs and other access methodsRESTful HTTP APIADO.NET
JDBC
native C library
ODBC
streaming API for large objects
JDBCADO.NET infocommunity maintained client
JDBC
MQTT (Message Queue Telemetry Transport)
PostgreSQL wire protocol
Prometheus Remote Read/Write
RESTful HTTP API
Browser interface
console (shell)
Graph API (Gremlin)
OpenCypher
Proprietary native API
Supported programming languages.Net
ColdFusion
Erlang
Groovy
Java
JavaScript
Perl
PHP
Python
Ruby
.Net
C
C++
Delphi
Java
JavaScript (Node.js)
Perl
PHP
Python
Tcl
C#
C++
Clojure
Go
Java
JavaScript (Node.js)
PHP
Python
Ruby
Rust
Erlang
Go infocommunity maintained client
Java
JavaScript (Node.js) infocommunity maintained client
Perl infocommunity maintained client
PHP
Python
Ruby infocommunity maintained client
Scala infocommunity maintained client
Go
Java
Python
Server-side scripts infoStored proceduresnouser defined functions inforealized in proprietary language PL/pgSQL or with common languages like Perl, Python, Tcl etc.nouser defined functionsuser defined procedures and functions
Triggersyes infoby integration with AWS Lambdayesnono
Partitioning methods infoMethods for storing different data on different nodesShardingShardinghorizontal 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 RAFTShardingSharding
Replication methods infoMethods for redundantly storing data on multiple nodesyesSource-replica replication infoother methods possible by using 3rd party extensionsMulti-source replication using RAFTselectable replication factor
MapReduce infoOffers an API for user-defined Map/Reduce methodsno infomay be implemented via Amazon Elastic MapReduce (Amazon EMR)nononono
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual Consistency
Immediate Consistency infocan be specified for read operations
Immediate ConsistencyImmediate ConsistencyEventual Consistency
Read Your Own Writes Consistency infofor primary key lookups
Immediate Consistency
Foreign keys infoReferential integritynoyesyesnoyes infoRelationships in graphs
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACID infoACID across one or more tables within a single AWS account and regionACIDACIDno infounique row identifiers can be used for implementing an optimistic concurrency control strategyACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyesyes
Durability infoSupport for making data persistentyesyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.nononoyes
User concepts infoAccess controlAccess rights for users and roles can be defined via the AWS Identity and Access Management (IAM)fine grained access rights according to SQL-standardRole-based access controlrights management via user accountsRole-based access control
More information provided by the system vendor
Amazon DynamoDBCitusCockroachDBCrateDBGalaxybase
Specific characteristicsCockroachDB is a cloud-native, distributed SQL database architected for modern applications....
» more
CrateDB is an open source distributed SQL database that spreads data and processing...
» more
Competitive advantages- EFFORTLESS SCALE: Scale your applications, not operational complexity. CockroachDB...
» more
CrateDB is typically used in operational analytics applications, particularly those...
» more
Typical application scenariosSystem of record (financial ledger, inventory management, transaction record), identity...
» more
CrateDB is ideal for integrating and analyzing streams of data--often machine-generated--in...
» more
Key customersComcast, DoorDash, Mythical Games, Norfolk Southern, LUSH, Bose, Shipt, MyDoc, Bitski,...
» more
CrateDB customers include McAfee, Qualtrics , Nokia, NBC Golfnow , Digital Domain...
» more
Market metrics8K+ long-running clusters 2.5K+ CockroachDB Self-Hosted clusters 15K+ CockroachDB...
» more
The CrateDB open source project was started in 2014. CrateDB was the winner of TechCrunch...
» more
Licensing and pricing models- Apache 2.0 for core features released up to and including the 19.1 release - Time-limited...
» more
CrateDB pricing CrateDB Community Edition is open source and free to use under the...
» more

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
3rd partiesCData: Connect to Big Data & NoSQL through standard Drivers.
» more

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

More resources
Amazon DynamoDBCitusCockroachDBCrateDBGalaxybase
DB-Engines blog posts

Cloud-based DBMS's popularity grows at high rates
12 December 2019, Paul Andlinger

The popularity of cloud-based DBMSs has increased tenfold in four years
7 February 2017, Matthias Gelbmann

Increased popularity for consuming DBMS services out of the cloud
2 October 2015, Paul Andlinger

show all

Recent citations in the news

Using a NestJS Application with DynamoDB and Serverless Framework on AWS
21 July 2022, hackernoon.com

AWS: Here's how our cloud-computing infrastructure dealt with Amazon Prime day
26 July 2022, ZDNet

AWS' new subscription-based training program aimed to develop cloud skills
15 August 2022, SC Media

How to Manage Your Asynchronous API With DynamoDB Streams
14 June 2022, Built In

DynamoDB’s co-creator reflects on the database’s birthday and how cloud is driving a machine learning future
15 February 2022, SiliconANGLE News

provided by Google News

Learn how to build a fast, scalable data system on Azure Hyperscale (Citus) and Cosmos DB
1 April 2022, YourStory

What is Azure Database for PostgreSQL Flexible Server?
24 June 2022, TechRepublic

Microsoft acquires Citus Data for its open source PostgreSQL tool
24 January 2019, VentureBeat

The Next Evolution of the Database Sharding Architecture
12 January 2022, InfoQ.com

Testing times: Microsoft gets PostgreSQL on Azure a day after GA
4 October 2021, The Register

provided by Google News

Cockroach Labs Releases Free "SQL for App Developers" Courses to Bridge Education Gap
20 July 2022, PR Newswire

Cockroach Labs Appoints Former Amazon General Counsel Michelle Wilson to Board of Directors
15 August 2022, PR Newswire

A Modern Database Meets a Modern DevOps Data Platform
12 August 2022, Security Boulevard

CockroachDB 22.1 Ramps up Automation, Scaling – The New Stack
25 May 2022, thenewstack.io

CockroachDB database creator Cockroach Labs raises $278M
16 December 2021, VentureBeat

provided by Google News

CrateDB 4.5 takes distributed SQL database open source
24 March 2021, TechTarget

Crate.io extends database service offering to Google Cloud
13 April 2022, VentureBeat

Crate.io raises $10M to grow its database platform
15 June 2021, VentureBeat

Crate.io Announces CrateDB Will Switch to an Elasticsearch Fork Following License Change
11 February 2021, GlobeNewswire

CrateDB 2.0 Enterprise stresses security and monitoring—and open source
16 May 2017, InfoWorld

provided by Google News

Job opportunities

Remote SIT Tester
Xpanxion, Remote

Full Stack Engineer
The Getch, Remote

Backend Developer
V-Soft Consulting Group, Remote

Full Stack Developer
The Getch, Remote

System Dev Engineer I, Amazon DynamoDB
Amazon Dev Center U.S., Inc., Remote

Database Solutions Engineer
CNH Industrial, United States

Systems Admin Postgres DBA
Retail Business Services, Quincy, MA

Systems Admin Postgres DBA
Retail Business Services, Chicago, IL

Systems Admin Postgres DBA
Retail Business Services, Scarborough, ME

Systems Admin Postgres DBA
Retail Business Services, Mauldin, SC

Database Administrator (MYSQL,100% Remote, EST Shifts)
ITGen Systems, Remote

Database Administrator
Techworkers, Remote

Senior Database Administrator
Surescripts, Minneapolis, MN

Platform Engineer (Database)
PLACE Corporate Careers, Denver, CO

Node.js Developer
Aspire Systems, Seattle, WA

Senior Cloud Operations Engineer
Aptos, Atlanta, GA

jobs by Indeed



Share this page

Featured Products

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

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Neo4j logo

The right graph database.
Not a graph add-on.
Free forever.
Start solving today

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