DB-EnginesInfluxDB: Focus on building software with an easy-to-use serverless, scalable time series platformEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > ClickHouse vs. Firebase Realtime Database vs. KeyDB vs. Microsoft Azure Synapse Analytics vs. WakandaDB

System Properties Comparison ClickHouse vs. Firebase Realtime Database vs. KeyDB vs. Microsoft Azure Synapse Analytics vs. WakandaDB

Editorial information provided by DB-Engines
NameClickHouse  Xexclude from comparisonFirebase Realtime Database  Xexclude from comparisonKeyDB  Xexclude from comparisonMicrosoft Azure Synapse Analytics infopreviously named Azure SQL Data Warehouse  Xexclude from comparisonWakandaDB  Xexclude from comparison
DescriptionColumn-oriented Relational DBMS powering YandexCloud-hosted realtime document store. iOS, Android, and JavaScript clients share one Realtime Database instance and automatically receive updates with the newest data.An ultra-fast, open source Key-value store fully compatible with Redis API, modules, and protocolsElastic, large scale data warehouse service leveraging the broad eco-system of SQL ServerWakandaDB is embedded in a server that provides a REST API and a server-side javascript engine to access data
Primary database modelRelational DBMSDocument storeKey-value storeRelational DBMSObject oriented DBMS
Secondary database modelsTime Series DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score13.18
Rank#46  Overall
#30  Relational DBMS
Score18.80
Rank#38  Overall
#6  Document stores
Score0.33
Rank#271  Overall
#40  Key-value stores
Score22.46
Rank#36  Overall
#22  Relational DBMS
Score0.02
Rank#344  Overall
#17  Object oriented DBMS
Websiteclickhouse.techfirebase.google.com/­products/­realtime-databasegithub.com/­JohnSully/­KeyDB
keydb.dev
azure.microsoft.com/­services/­synapse-analyticswakanda.github.io
Technical documentationclickhouse.tech/­docsfirebase.google.com/­docs/­databasedocs.keydb.devdocs.microsoft.com/­azure/­synapse-analyticsdoc.wakanda.org/­home2.en.html#/­Datastore/­Introduction.200-588937.en.html
DeveloperClickhouse Inc.Google infoacquired by Google 2014EQ Alpha Technology Ltd.MicrosoftWakanda SAS
Initial release20162012201920162012
Current releasev22.6.3.35-stable, July 20222.7.0 (April 29, 2019), April 2019
License infoCommercial or Open SourceOpen Source infoApache 2.0commercialOpen Source infoBSD-3commercialOpen Source infoAGPLv3, extended commercial license available
Cloud-based only infoOnly available as a cloud servicenoyesnoyesno
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC++C++C++C++, JavaScript
Server operating systemsFreeBSD
Linux
macOS
hostedLinuxhostedLinux
OS X
Windows
Data schemeyesschema-freeschema-freeyesyes
Typing infopredefined data types such as float or dateyesyespartial infoSupported data types are strings, hashes, lists, sets and sorted sets, bit arrays, hyperloglogs and geospatial indexesyesyes
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.nonononono
Secondary indexesnoyesyes infoby using the Redis Search moduleyes
SQL infoSupport of SQLClose to ANSI SQLnonoyesno
APIs and other access methodsHTTP REST
JDBC
ODBC
Proprietary protocol
Android
iOS
JavaScript API
RESTful HTTP API
Proprietary protocol infoRESP - REdis Serialization ProtocoADO.NET
JDBC
ODBC
RESTful HTTP API
Supported programming languagesC# info3rd party library
C++
Elixir info3rd party library
Go info3rd party library
Java info3rd party library
JavaScript (Node.js) info3rd party library
Kotlin info3rd party library
Nim info3rd party library
Perl info3rd party library
PHP info3rd party library
Python info3rd party library
R info3rd party library
Ruby info3rd party library
Scala info3rd party library
Java
JavaScript
Objective-C
C
C#
C++
Clojure
Crystal
D
Dart
Elixir
Erlang
Fancy
Go
Haskell
Haxe
Java
JavaScript (Node.js)
Lisp
Lua
MatLab
Objective-C
OCaml
Pascal
Perl
PHP
Prolog
Pure Data
Python
R
Rebol
Ruby
Rust
Scala
Scheme
Smalltalk
Swift
Tcl
Visual Basic
C#
Java
PHP
JavaScript
Server-side scripts infoStored proceduresnolimited functionality with using 'rules'LuaTransact SQLyes
TriggersnoCallbacks are triggered when data changesnonoyes
Partitioning methods infoMethods for storing different data on different nodesShardingSharding, horizontal partitioningnone
Replication methods infoMethods for redundantly storing data on multiple nodesMulti-source replication
Source-replica replication
yesnone
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonononono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyEventual Consistency infoif the client is offline
Immediate Consistency infoif the client is online
Eventual Consistency
Strong eventual consistency with CRDTs
Immediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynononono infodocs.microsoft.com/­en-us/­azure/­synapse-analytics/­sql-data-warehouse/­sql-data-warehouse-table-constraints
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanoyesOptimistic locking, atomic execution of commands blocks and scriptsACIDACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyesyes
Durability infoSupport for making data persistentyesyesyes infoConfigurable mechanisms for persistency via snapshots and/or operations logsyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyesno
User concepts infoAccess controlAccess rights for users and rolesyes, based on authentication and database rulessimple password-based access control and ACLyesyes

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
ClickHouseFirebase Realtime DatabaseKeyDBMicrosoft Azure Synapse Analytics infopreviously named Azure SQL Data WarehouseWakandaDB
DB-Engines blog posts

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

show all

Recent citations in the news

StarRocks Brings Speedy OLAP Database to the Cloud
14 July 2022, Datanami

Observability startup Better Stack lands $18.6M in new cash
21 July 2022, TechCrunch

Multiple Flaws Uncovered in ClickHouse OLAP Database System for Big Data
16 March 2022, The Hacker News

Two Sizes Fit Most: PostgreSQL and ClickHouse – The New Stack
13 April 2022, thenewstack.io

ClickHouse Raises $250M Series B To Scale Groundbreaking OLAP Database Management System Globally
28 October 2021, Business Wire

provided by Google News

How to Use Complex Firebase Queries in Angular - MUO
9 August 2022, MakeUseOf

Examining New DawDropper Banking Dropper and DaaS on the Dark Web
29 July 2022, Trend Micro

Banking trojan finds new routes to accounts by infiltrating Google Play Store
5 August 2022, SC Media

Over a Dozen Android Apps on Google Play Store Caught Dropping Banking Malware
29 July 2022, The Hacker News

Raspberry Pi Unlocks Door Automatically with Facial Recognition
8 August 2022, Tom's Hardware

provided by Google News

Snap snaps up database developer KeyDB to make its infrastructure more snappy
12 May 2022, TechCrunch

How To Fix “This Blu-ray Disc Needs A Library For AACS Decoding”
13 April 2022, Tech News Today

Snap buys mind-controlled headband maker, NextMind
23 March 2022, TechCrunch

Snap partners with Live Nation to launch AR experiences at select concerts and festivals
28 April 2022, TechCrunch

Intel takes direct aim at Nvidia
12 May 2022, Protocol

provided by Google News

Azure Synapse vs. Databricks: Data Platform Comparison | eWEEK
20 July 2022, eWeek

A New Service from the Microsoft and Oracle Partnership: Oracle Database Service for Microsoft Azure
28 July 2022, InfoQ.com

Banco de Crédito e Inversiones Selects Teradata Vantage in the Cloud for Flexible and Scalable Analytics
10 August 2022, WebWire

Oracle and Microsoft announce availability of Oracle Database Service for Microsoft Azure - Stories
20 July 2022, Microsoft

SQL Server 2022 New Features
22 July 2022, Petri.com

provided by Google News

Job opportunities

Database Engineer
Jump Trading, Chicago, IL

Web Developer - Website (AMER, Remote)
ClickHouse, New York, NY

ClickHouse Customer Support Engineer
Altinity, Inc., Remote

Senior Data Engineer – Analytics & Visualization
PlayStation Global, San Francisco, CA

Data Systems Engineer
RingCentral, Remote

Software Developer
MAET LLC, Remote

Frontend VueJS Firebase Web Developer
Arcade Apps, LLC, Farmington, MI

Digital Analytics Data Architect (Hybrid)
Peapod Digital Labs, N White Plains, NY

Data Engineer
Life.Church, Edmond, OK

Digital Analytics Data Architect (Hybrid)
Peapod Digital Labs, Scarborough, ME

Backend Software Engineer
Health Recovery Solutions, Hoboken, NJ

Azure Lead
ABN Tech Corp, Remote

Azure Synapse Data Engineer
Point1 Solutions, Remote

Azure Data Engineer
Marshall Technologies, Remote

Sr.Azure Data Engineer
sourcemantra, Atlanta, GA

Azure Synapse Data Engineer
Point1 Solutions, New York, NY

jobs by Indeed



Share this page

Featured Products

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

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.

Neo4j logo

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

Redis logo

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

AllegroGraph logo

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

Present your product here