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

DBMS > Badger vs. CockroachDB vs. EJDB vs. Microsoft SQL Server

System Properties Comparison Badger vs. CockroachDB vs. EJDB vs. Microsoft SQL Server

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameBadger  Xexclude from comparisonCockroachDB  Xexclude from comparisonEJDB  Xexclude from comparisonMicrosoft SQL Server  Xexclude from comparison
DescriptionAn embeddable, persistent, simple and fast Key-Value Store, written purely in Go.CockroachDB 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)Microsofts flagship relational DBMS
Primary database modelKey-value storeRelational DBMSDocument storeRelational DBMS
Secondary database modelsDocument store
Graph DBMS
Spatial DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.12
Rank#318  Overall
#47  Key-value stores
Score7.58
Rank#59  Overall
#33  Relational DBMS
Score0.14
Rank#307  Overall
#42  Document stores
Score926.30
Rank#3  Overall
#3  Relational DBMS
Websitegithub.com/­dgraph-io/­badgerwww.cockroachlabs.comejdb.orgwww.microsoft.com/­en-us/­sql-server
Technical documentationgodoc.org/­github.com/­dgraph-io/­badgerwww.cockroachlabs.com/­docsgithub.com/­Softmotions/­ejdb/­blob/­master/­README.mddocs.microsoft.com/­en-US/­sql/­sql-server
DeveloperDGraph LabsCockroach LabsSoftmotionsMicrosoft
Initial release2017201520121989
Current release21.1.2, June 2021SQL Server 2019, November 2019
License infoCommercial or Open SourceOpen Source infoApache 2.0Open Source infoApache 2.0, commercial license availableOpen Source infoGPLv2commercial inforestricted free version is available
Cloud-based only infoOnly available as a cloud servicenononono
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 languageGoGoCC++
Server operating systemsBSD
Linux
OS X
Solaris
Windows
Linux
macOS
Windows
server-lessLinux
Windows
Data schemeschema-freedynamic schemaschema-freeyes
Typing infopredefined data types such as float or datenoyesyes infostring, integer, double, bool, date, object_idyes
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.nonoyes
Secondary indexesnoyesnoyes
SQL infoSupport of SQLnoyes, wire compatible with PostgreSQLnoyes
APIs and other access methodsJDBCin-process shared libraryADO.NET
JDBC
ODBC
OLE DB
Tabular Data Stream (TDS)
Supported programming languagesGoC#
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
C#
C++
Delphi
Go
Java
JavaScript (Node.js)
PHP
Python
R
Ruby
Visual Basic
Server-side scripts infoStored proceduresnononoTransact SQL, .NET languages, R, Python and (with SQL Server 2019) Java
Triggersnononoyes
Partitioning methods infoMethods for storing different data on different nodesnonehorizontal 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 RAFTnonetables can be distributed across several files (horizontal partitioning); sharding through federation
Replication methods infoMethods for redundantly storing data on multiple nodesnoneMulti-source replication using RAFTnoneyes, but depending on the SQL-Server Edition
MapReduce infoOffers an API for user-defined Map/Reduce methodsnononono
Consistency concepts infoMethods to ensure consistency in a distributed systemnoneImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynoyesno infotypically not needed, however similar functionality with collection joins possibleyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanoACIDnoACID
Concurrency infoSupport for concurrent manipulation of datayesyesyes infoRead/Write Lockingyes
Durability infoSupport for making data persistentyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.nonoyes
User concepts infoAccess controlnoRole-based access controlnofine grained access rights according to SQL-standard
More information provided by the system vendor
BadgerCockroachDBEJDBMicrosoft SQL Server
Specific characteristicsCockroachDB is a cloud-native, distributed SQL database architected for modern applications....
» more
Competitive advantages- EFFORTLESS SCALE: Scale your applications, not operational complexity. CockroachDB...
» more
Typical application scenariosSystem of record (financial ledger, inventory management, transaction record), identity...
» more
Key customersComcast, DoorDash, Mythical Games, Norfolk Southern, LUSH, Bose, Shipt, Bitski, Five9,...
» more
Market metrics8K+ long-running clusters 2.5K+ CockroachDB Self-Hosted clusters 15K+ CockroachDB...
» more
Licensing and pricing models- Apache 2.0 for core features released up to and including the 19.1 release - Time-limited...
» 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 partiesSQLFlow: Provides a visual representation of the overall flow of data. Automated SQL data lineage analysis across Databases, ETL, Business Intelligence, Cloud and Hadoop environments by parsing SQL Script and stored procedure.
» more

SQL Complete: An advanced IntelliSense-style code completion add-in for SSMS and Visual Studio. Write, beautify, refactor your SQL code and give your productivity a dramatic boost.
» more

Navicat Monitor is a safe, simple and agentless remote server monitoring tool for SQL Server and many other database management systems.
» more

Navicat for SQL Server gives you a fully graphical approach to database management and development.
» more

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

More resources
BadgerCockroachDBEJDBMicrosoft SQL Server
DB-Engines blog posts

MySQL is the DBMS of the Year 2019
3 January 2020, Matthias Gelbmann, Paul Andlinger

The struggle for the hegemony in Oracle's database empire
2 May 2017, Paul Andlinger

Microsoft SQL Server is the DBMS of the Year
4 January 2017, Matthias Gelbmann, Paul Andlinger

show all

Recent citations in the news

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

Flexible protein database based on amino acid k-mers | Scientific Reports
1 June 2022, Nature.com

provided by Google News

CockroachDB gets database migration tool, as CockroachDB Serverless launches
21 September 2022, InfoWorld

CockroachDB adds command line tool as database hits version 22.1
24 May 2022, The Register

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

CockroachDB version 21.1 simplifies distributed SQL database
20 May 2021, TechTarget

O'Reilly Launches New Book: CockroachDB the Definitive Guide
10 May 2022, PR Newswire

provided by Google News

Microsoft SQL servers hacked in TargetCompany ransomware attacks
24 September 2022, BleepingComputer

Microsoft Readies SQL Server 2022 for Release
29 August 2022, Redmond Channel Partner

Microsoft offers SQL Server 2022 release candidate to Linux world
8 September 2022, The Register

SQL Server Query Tuning and Optimization (Packt)
20 September 2022, iProgrammer

Secure Data Recovery: Database Data Recovery Review
26 September 2022, Enterprise Storage Forum

provided by Google News

Job opportunities

Software Engineering
JPMorgan Chase Bank, N.A., Jersey City, NJ

Database Administrator (Postgres)
PLACE Corporate Careers, Denver, CO

Application Software Engineer, Data
SpaceX, Brownsville, TX

Software Engineer I
Lindsay, Olathe, KS

Java Software Engineer
JPMorgan Chase Bank, N.A., Chicago, IL

SQL Server Developer
SnappyHires, Remote

SQL Server Developer
Kani Solutions, Remote

SQL Server Developer
Talenti Qo Workforce and RPO Services PVT LTD., Remote

SQL Server Developer
Kani Solutions Inc., Remote

SQL Server Developer
Logix Group, Remote

jobs by Indeed



Share this page

Featured Products

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.

Vertica logo

Vertica Accelerator. The fastest analytics and machine learning, delivered as SaaS, with automated setup, administration, and management. Free trial.

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Redis logo

The world’s most loved real‑time data platform.
Try free

Neo4j logo

Neo4j NODES 2022
Free online conference for developers and data scientists.
November 16/17 2022.
Register now for free!

Present your product here