DBMS > 4D vs. Apache Druid vs. Cloudflare Workers KV vs. Couchbase vs. EJDB

System Properties Comparison 4D vs. Apache Druid vs. Cloudflare Workers KV vs. Couchbase vs. EJDB

Editorial information provided by DB-Engines

Name

Description

Application development environment with integrated database management system

Open-source analytics data store designed for sub-second OLAP queries on high dimensionality and high cardinality data

A global, low-latency, key-value store for applications on Cloudflare with exceptionally high read volumes and low-latency.

A distributed document store with integrated cache, a powerful search engine, in-built operational and analytical capabilities, and an embedded mobile database

Embeddable document-store database library with JSON representation of queries (in MongoDB style)

Primary database model

Relational DBMS

Relational DBMS
Time Series DBMS

Key-value store

Document store

Secondary database models

Key-value store

originating from the former Membase product and supporting the Memcached protocol
Spatial DBMS

using the Geocouch extension
Search engine
Time Series DBMS
Vector DBMS

DB-Engines Ranking measures the popularity of database management systems
Trend Chart

Score	2.58
Rank	#108	Overall
	#54	Relational DBMS

Score	3.34
Rank	#88	Overall
	#48	Relational DBMS
	#7	Time Series DBMS

Score	0.32
Rank	#283	Overall
	#40	Key-value stores

Score	17.30
Rank	#36	Overall
	#5	Document stores

Score	0.27
Rank	#297	Overall
	#44	Document stores

Website

www.4d.com

druid.apache.org

www.cloudflare.com/developer-platform/workers-kv

www.couchbase.com

github.com/Softmotions/ejdb

Technical documentation

developer.4d.com

druid.apache.org/docs/latest/design

developers.cloudflare.com/kv/api

docs.couchbase.com

github.com/Softmotions/ejdb/blob/master/README.md

Developer

4D, Inc

Apache Software Foundation and contributors

Cloudflare

Couchbase, Inc.

Softmotions

Initial release

1984

2012

2018

2011

2012

Current release

v20, April 2023

29.0.1, April 2024

Server: 7.2, June 2023; Mobile: 3.1, March 2022; Couchbase Capella (DBaaS), June 2023

License

Commercial or Open Source

commercial

Open Source

Apache license v2

commercial

Open Source

Business Source License (BSL 1.1); Commercial licenses also available

Open Source

GPLv2

Cloud-based only

Only available as a cloud service

yes

DBaaS offerings (sponsored links)

Database as a Service

Providers of DBaaS offerings, please contact us to be listed.

Implementation language

Java

C, C++, Go and Erlang

Server operating systems

OS X
Windows

Linux
OS X
Unix

hosted

Linux
OS X
Windows

server-less

Data scheme

yes

schema-less columns are supported

schema-free

Typing

predefined data types such as float or date

yes

string, integer, double, bool, date, object_id

XML support

Some form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.

yes

Secondary indexes

yes

SQL

Support of SQL

yes

close to SQL 92

SQL for querying

SQL++, extends ANSI SQL to JSON for operational, transactional, and analytic use cases

APIs and other access methods

ODBC
RESTful HTTP API

by using 4D Mobile
SOAP webservices

JDBC
RESTful HTTP/JSON API

HTTP REST
Proprietary protocol

CLI Client
HTTP REST
Kafka Connector
Native language bindings for CRUD, Query, Search and Analytics APIs
Spark Connector
Spring Data

in-process shared library

Supported programming languages

4D proprietary IDE
PHP

Clojure
JavaScript
PHP
Python
R
Ruby
Scala

C
C++
Dart
JavaScript
Kotlin
Python
Rust
Scala

.Net
C
Go
Java
JavaScript

Node.js
Kotlin
PHP
Python
Ruby
Scala

Actionscript
C
C#
C++
Go
Java
JavaScript (Node.js)
Lua
Objective-C
Pike
Python
Ruby

Server-side scripts

Stored procedures

yes

Functions and timers in JavaScript and UDFs in Java, Python, SQL++

Triggers

yes

via the TAP protocol

Partitioning methods

Methods for storing different data on different nodes

none

Sharding

manual/auto, time-based

Automatic Sharding

none

Replication methods

Methods for redundantly storing data on multiple nodes

Multi-source replication

yes, via HDFS, S3 or other storage engines

yes

Multi-source replication

including cross data center replication
Source-replica replication

none

MapReduce

Offers an API for user-defined Map/Reduce methods

yes

Consistency concepts

Methods to ensure consistency in a distributed system

Immediate Consistency

Eventual Consistency

Eventual Consistency
Immediate Consistency

selectable on a per-operation basis

Foreign keys

Referential integrity

yes

typically not needed, however similar functionality with collection joins possible

Transaction concepts

Support to ensure data integrity after non-atomic manipulations of data

ACID

Concurrency

Support for concurrent manipulation of data

yes

Read/Write Locking

Durability

Support for making data persistent

yes

In-memory capabilities

Is there an option to define some or all structures to be held in-memory only.

yes

Ephemeral buckets

User concepts

Access control

Users and groups

RBAC using LDAP or Druid internals for users and groups for read/write by datasource and system

User and Administrator separation with password-based and LDAP integrated Authentication. Role-base access control.

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.