DB-EnginesExtremeDB: the first and only COTS deterministic embedded database management system for mission- and safety-critical hard real-time applicationsEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > CockroachDB vs. EJDB vs. InfluxDB vs. Lovefield vs. SAP SQL Anywhere

System Properties Comparison CockroachDB vs. EJDB vs. InfluxDB vs. Lovefield vs. SAP SQL Anywhere

Editorial information provided by DB-Engines
NameCockroachDB  Xexclude from comparisonEJDB  Xexclude from comparisonInfluxDB  Xexclude from comparisonLovefield  Xexclude from comparisonSAP SQL Anywhere infoformerly called Adaptive Server Anywhere  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.Embeddable document-store database library with JSON representation of queries (in MongoDB style)DBMS for storing time series, events and metricsEmbeddable relational database for web apps written in pure JavaScriptRDBMS database and synchronization technologies for server, desktop, remote office, and mobile environments
Primary database modelRelational DBMSDocument storeTime Series DBMSRelational DBMSRelational DBMS
Secondary database modelsSpatial DBMS infowith GEO package
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score6.93
Rank#58  Overall
#32  Relational DBMS
Score0.24
Rank#277  Overall
#39  Document stores
Score28.38
Rank#29  Overall
#1  Time Series DBMS
Score0.30
Rank#269  Overall
#124  Relational DBMS
Score5.53
Rank#70  Overall
#38  Relational DBMS
Websitewww.cockroachlabs.comejdb.orgwww.influxdata.com/­products/­influxdb-overviewgoogle.github.io/­lovefieldwww.sap.com/­products/­sql-anywhere.html
Technical documentationwww.cockroachlabs.com/­docsgithub.com/­Softmotions/­ejdb/­blob/­master/­README.mddocs.influxdata.com/­influxdbgithub.com/­google/­lovefield/­blob/­master/­docs/­spec_index.mdhelp.sap.com/­sql-anywhere
DeveloperCockroach LabsSoftmotionsGoogleSAP infoformerly Sybase
Initial release20152012201320141992
Current release21.1.2, June 20212.0.8, August 20212.1.12, February 201717, July 2015
License infoCommercial or Open SourceOpen Source infoApache 2.0, commercial license availableOpen Source infoGPLv2Open Source infoMIT-License; commercial enterprise version availableOpen Source infoApache 2.0commercial
Cloud-based only infoOnly available as a cloud servicenonononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
CockroachCloud: Get your applications to market faster with a fully managed CockroachDB instance. Leave the daily maintenance, security, and operations of your database to us, and spend more time building apps and running your business.
Implementation languageGoCGoJavaScript
Server operating systemsLinux
macOS
Windows
server-lessLinux
OS X infothrough Homebrew
server-less, requires a JavaScript environment (browser, Node.js) infotested with Chrome, Firefox, IE, SafariAIX
HP-UX
Linux
OS X
Solaris
Windows
Data schemedynamic schemaschema-freeschema-freeyesyes
Typing infopredefined data types such as float or dateyesyes infostring, integer, double, bool, date, object_idNumeric data and Stringsyesyes
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 indexesyesnonoyesyes
SQL infoSupport of SQLyes, wire compatible with PostgreSQLnoSQL-like query languageSQL-like query language infovia JavaScript builder patternyes
APIs and other access methodsJDBCin-process shared libraryHTTP API
JSON over UDP
ADO.NET
HTTP API
JDBC
ODBC
Supported programming languagesC#
C++
Clojure
Go
Java
JavaScript (Node.js)
PHP
Python
Ruby
Rust
Actionscript
C
C#
C++
Go
Java
JavaScript (Node.js)
Lua
Objective-C
Pike
Python
Ruby
.Net
Clojure
Erlang
Go
Haskell
Java
JavaScript
JavaScript (Node.js)
Lisp
Perl
PHP
Python
R
Ruby
Rust
Scala
JavaScriptC
C#
C++
Delphi
Java
JavaScript (Node.js)
Perl
PHP
Python
Ruby
Server-side scripts infoStored proceduresnonononoyes, in C/C++, Java, .Net or Perl
TriggersnononoUsing read-only observersyes
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 RAFTnoneSharding infoin enterprise version onlynonenone
Replication methods infoMethods for redundantly storing data on multiple nodesMulti-source replication using RAFTnoneselectable replication factor infoin enterprise version onlynoneSource-replica replication infoDatabase mirroring
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonononono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integrityyesno infotypically not needed, however similar functionality with collection joins possiblenoyesyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDnonoACIDACID
Concurrency infoSupport for concurrent manipulation of datayesyes infoRead/Write Lockingyesyesyes
Durability infoSupport for making data persistentyesyesyesyes, by using IndexedDB or the cloud service Firebase Realtime Databaseyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.noyes infoDepending on used storage engineyes infousing MemoryDByes
User concepts infoAccess controlRole-based access controlnosimple rights management via user accountsnofine grained access rights according to SQL-standard
More information provided by the system vendor
CockroachDBEJDBInfluxDBLovefieldSAP SQL Anywhere infoformerly called Adaptive Server Anywhere
Specific characteristicsCockroachDB is a cloud-native, distributed SQL database architected for modern applications....
» more
InfluxData is the creator of InfluxDB , the open source time series database. It...
» more
Competitive advantages- EFFORTLESS SCALE: Scale your applications, not operational complexity. CockroachDB...
» more
Time to Value An end-to-end platform, InfluxData is ready to go on the cloud or via...
» more
Typical application scenariosSystem of record (financial ledger, inventory management, transaction record), identity...
» more
IoT & Sensor Monitoring Instrumentation of every available surface in the material...
» more
Key customersComcast, eBay, DoorDash, Mythical Games, Norfolk Southern, LUSH, Bose, Shipt, MyDoc,...
» more
InfluxData has over 630 paying customers, including IBM, PayPal, Siemens Tesla and...
» more
Market metrics6.5K+ long-running clusters 1.5K+ CockroachDB Self-Hosted clusters 6.5K+ CockroachDB...
» more
Fastest growing database to garnish 17,000 github stars Over 260,000 daily active...
» more
Licensing and pricing models- Apache 2.0 for core features released up to and including the 19.1 release - Time-limited...
» more
Open source core with closed source clustering available either on-premise or on...
» more
News

How to Use AWS Lambda Serverless Functions with InfluxDB
7 December 2021

PTC Kepware and InfluxDB: Collecting and Storing Your Automation Data
7 December 2021

Getting Started with the InfluxDB 2.0 API and Postman
6 December 2021

Expand Kubernetes Monitoring with Telegraf Operator
3 December 2021

TL;DR InfluxDB Tech Tips – Visualizing Uptime with Flux deadman() Function in InfluxDB Dashboards
2 December 2021

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
CockroachDBEJDBInfluxDBLovefieldSAP SQL Anywhere infoformerly called Adaptive Server Anywhere
DB-Engines blog posts

Why Build a Time Series Data Platform?
20 July 2017, Paul Dix (guest author)

Time Series DBMS are the database category with the fastest increase in popularity
4 July 2016, Matthias Gelbmann

Time Series DBMS as a new trend?
1 June 2015, Paul Andlinger

show all

Recent citations in the news

CockroachDB update scales distributed SQL database
16 November 2021, TechTarget

Cockroach Labs Delivers an Improved Developer Experience with CockroachDB 21.2
24 November 2021, Database Trends and Applications

Break point: XCRemote Cache, PagerDuty, Prometheus, CockroachDB, and Spring Data • DEVCLASS
19 November 2021, DevClass

The CockroachDB EC-1
15 July 2021, TechCrunch

Cockroach Labs Introduces CockroachDB Serverless: Build What You Dream and Never Worry about the Database
19 October 2021, PRNewswire

provided by Google News

InfluxData Brings Time Series Expertise to AWS re:Invent 2021
17 November 2021, Business Wire

InfluxData Announces New Features Aimed at App Development
27 October 2021, Datanami

InfluxData releases InfluxDB Notebooks to enhance collaboration for teams working with time series data
14 April 2021, Business Wire

Monitoring PLC and SCADA Systems Using MQTT and InfluxDB -- ADTmag
30 September 2021, ADT Magazine

How To Install InfluxDB on AlmaLinux or Rocky 8 to create database
9 June 2021, H2S Media

provided by Google News

SAP SQL Anywhere
3 April 2018, TechTarget

SAP gives SQL Anywhere a new IoT injection
16 July 2015, Computerworld

Rimini Streets adds support for open source databases -
3 September 2021, Enterprise Times

Top Data Management Platforms & Systems 2021 | ESF
22 July 2021, Enterprise Storage Forum

Rimini Street to offer database, security services
7 June 2017, ZDNet

provided by Google News

Job opportunities

Financial Analyst
Cockroach Labs, United States

Software Engineer (Payments)
Panasonic Corporation of North America, Palo Alto, CA

Salesforce Administrator, Remote, US
Cockroach Labs, Remote

Senior Software Engineer
Netflix, Remote

Salesforce Administrator, Remote, US
Cockroach Labs, New York State

Sales Retention Call Center Representative
Etech, Dallas, TX

Exciting & Friendly Call Center | Onsite Agents
Etech, Dallas, TX

Software Engineer (Hybrid Mobile and Web Apps)
Universal Avionics Systems Corporation, Duluth, GA

Senior Software Engineer (Hybrid Mobile and Web Apps)
Universal Avionics Systems Corporation, Duluth, GA

Junior Server and Network Technician
Association For Energy Affordability, Inc., Bronx, NY

jobs by Indeed



Share this page

Featured Products

Couchbase logo

The modern database for enterprise applications. Build fast. Scale Big. Save more.
Get started today.

Neo4j logo

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

Datastax Astra logo

Build cloud-native apps fast with Astra, the open-source, multi-cloud stack for
modern data apps.
Get started with 80GB free.

AllegroGraph logo

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

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Present your product here