DB-EnginesExtremeDB: mitigate connectivity issues in a DBMSEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Amazon SimpleDB vs. CockroachDB vs. Dgraph vs. HarperDB vs. TimescaleDB

System Properties Comparison Amazon SimpleDB vs. CockroachDB vs. Dgraph vs. HarperDB vs. TimescaleDB

Editorial information provided by DB-Engines
NameAmazon SimpleDB  Xexclude from comparisonCockroachDB  Xexclude from comparisonDgraph  Xexclude from comparisonHarperDB  Xexclude from comparisonTimescaleDB  Xexclude from comparison
DescriptionHosted simple database service by Amazon, with the data stored in the Amazon Cloud. infoThere is an unrelated product called SimpleDB developed by Edward ScioreCockroachDB 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 and scalable native Graph DBMSUltra-low latency distributed database with an intuitive REST API supporting NoSQL and SQL (including joins). Deployment of functions and databases simultaneously with a consolidated node-level architecture.A time series DBMS optimized for fast ingest and complex queries, based on PostgreSQL
Primary database modelKey-value storeRelational DBMSGraph DBMSDocument storeTime Series DBMS
Secondary database modelsRelational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score1.88
Rank#133  Overall
#23  Key-value stores
Score5.73
Rank#58  Overall
#34  Relational DBMS
Score1.53
Rank#152  Overall
#15  Graph DBMS
Score0.60
Rank#244  Overall
#38  Document stores
Score4.46
Rank#71  Overall
#5  Time Series DBMS
Websiteaws.amazon.com/­simpledbwww.cockroachlabs.comdgraph.iowww.harperdb.iowww.timescale.com
Technical documentationdocs.aws.amazon.com/­simpledbwww.cockroachlabs.com/­docsdgraph.io/­docsdocs.harperdb.io/­docsdocs.timescale.com
DeveloperAmazonCockroach LabsDgraph Labs, Inc.HarperDBTimescale
Initial release20072015201620172017
Current release24.1.0, May 20243.1, August 20212.15.0, May 2024
License infoCommercial or Open SourcecommercialOpen Source infoApache 2.0, commercial license availableOpen Source infoApache 2.0commercial infofree community edition availableOpen Source infoApache 2.0
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.
Implementation languageGoGoNode.jsC
Server operating systemshostedLinux
macOS
Windows
Linux
OS X
Windows
Linux
OS X
Linux
OS X
Windows
Data schemeschema-freedynamic schemaschema-freedynamic schemayes
Typing infopredefined data types such as float or datenoyesyesyes infoJSON data typesnumerics, strings, booleans, arrays, JSON blobs, geospatial dimensions, currencies, binary data, other complex 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.nononoyes
Secondary indexesyes infoAll columns are indexed automaticallyyesyesyesyes
SQL infoSupport of SQLnoyes, wire compatible with PostgreSQLnoSQL-like data manipulation statementsyes infofull PostgreSQL SQL syntax
APIs and other access methodsRESTful HTTP APIJDBCGraphQL query language
gRPC (using protocol buffers) API
HTTP API
JDBC
ODBC
React Hooks
RESTful HTTP/JSON API
WebSocket
ADO.NET
JDBC
native C library
ODBC
streaming API for large objects
Supported programming languages.Net
C
C++
Erlang
Java
PHP
Python
Ruby
Scala
C#
C++
Clojure
Go
Java
JavaScript (Node.js)
PHP
Python
Ruby
Rust
C#
C++
Go
Java
JavaScript (Node.js)
PHP
Python
Ruby
.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
.Net
C
C++
Delphi
Java infoJDBC
JavaScript
Perl
PHP
Python
R
Ruby
Scheme
Tcl
Server-side scripts infoStored proceduresnononoCustom Functions infosince release 3.1user defined functions, PL/pgSQL, PL/Tcl, PL/Perl, PL/Python, PL/Java, PL/PHP, PL/R, PL/Ruby, PL/Scheme, PL/Unix shell
Triggersnonononoyes
Partitioning methods infoMethods for storing different data on different nodesnone infoSharding must be implemented in the applicationhorizontal 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 RAFTyesA table resides as a whole on one (or more) nodes in a clusteryes, across time and space (hash partitioning) attributes
Replication methods infoMethods for redundantly storing data on multiple nodesyesMulti-source replication using RAFTSynchronous replication via Raftyes infothe nodes on which a table resides can be definedSource-replica replication with hot standby and reads on replicas info
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonononono
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual Consistency
Immediate Consistency infocan be specified for read operations
Immediate ConsistencyImmediate ConsistencyImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynoyesnonoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datano infoConcurrent data updates can be detected by the applicationACIDACIDAtomic execution of specific operationsACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyesyes
Durability infoSupport for making data persistentyesyesyesyes, using LMDByes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.noyesno
User concepts infoAccess controlAccess rights for users and roles can be defined via the AWS Identity and Access Management (IAM)Role-based access controlno infoPlanned for future releasesAccess rights for users and rolesfine grained access rights according to SQL-standard

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
Amazon SimpleDBCockroachDBDgraphHarperDBTimescaleDB
DB-Engines blog posts

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

Amazon - the rising star in the DBMS market
3 August 2015, Matthias Gelbmann

show all

Recent citations in the news

A Place for Everything – Amazon SimpleDB | AWS News Blog
14 December 2007, AWS Blog

Amazon DynamoDB Serves Trillions Of Requests Per Month While Counterpart SimpleDB Is No Longer A Listed ...
12 November 2013, TechCrunch

An Overview of Amazon Web Services - Cloud Application Architectures [Book]
22 September 2018, oreilly.com

Amazon SimpleDB Management in Eclipse | AWS News Blog
22 July 2009, AWS Blog

Good Advice on Keeping Your Database Simple and Fast.
25 March 2009, All Things Distributed

provided by Google News

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

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

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

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

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

provided by Google News

Dgraph on AWS: Setting up a horizontally scalable graph database | Amazon Web Services
1 September 2020, AWS Blog

Popular Open Source GraphQL Company Dgraph Secures $6M in Seed Round with New Leadership
20 July 2022, PR Newswire

Dgraph Raises $6M in Seed Funding
20 July 2022, FinSMEs

Dgraph Rises to the Top Graph Database on GitHub With 11 G2 Badges and 11M Downloads
26 May 2021, Business Wire

Dgraph raises $11.5 million for scalable graph database solutions
31 July 2019, VentureBeat

provided by Google News

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

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

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

Jaxon Repp on HarperDB Distributed Database Platform
23 March 2022, InfoQ.com

provided by Google News

TimescaleDB Is a Vector Database Now, Too
25 September 2023, Datanami

Timescale Acquires PopSQL to Bring a Modern, Collaborative SQL GUI to PostgreSQL Developers
4 April 2024, PR Newswire

Power IoT and time-series workloads with TimescaleDB for Azure Database for PostgreSQL
18 March 2019, azure.microsoft.com

Timescale Valuation Rockets to Over $1B with $110M Round, Marking the Explosive Rise of Time-Series Data
22 February 2022, Business Wire

Timescale announces $15M investment and new enterprise version of TimescaleDB
29 January 2019, TechCrunch

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

Present your product here