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

DBMS > BigchainDB vs. Citus vs. ClickHouse vs. dBASE vs. LokiJS

System Properties Comparison BigchainDB vs. Citus vs. ClickHouse vs. dBASE vs. LokiJS

Editorial information provided by DB-Engines
NameBigchainDB  Xexclude from comparisonCitus  Xexclude from comparisonClickHouse  Xexclude from comparisondBASE  Xexclude from comparisonLokiJS  Xexclude from comparison
DescriptionBigchainDB is scalable blockchain database offering decentralization, immutability and native assetsScalable hybrid operational and analytics RDBMS for big data use cases based on PostgreSQLA high-performance, column-oriented SQL DBMS for online analytical processing (OLAP) that uses all available system resources to their full potential to process each analytical query as fast as possible. It is available as both an open-source software and a cloud offering.dBase was one of the first databases with a development environment on PC's. Its latest version dBase V is still sold as dBase classic, which needs a DOS Emulation. The up-to-date product is dBase plus.In-memory JavaScript DBMS
Primary database modelDocument storeRelational DBMSRelational DBMSRelational DBMSDocument store
Secondary database modelsDocument storeTime Series DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.86
Rank#210  Overall
#36  Document stores
Score2.21
Rank#129  Overall
#61  Relational DBMS
Score16.31
Rank#37  Overall
#23  Relational DBMS
Score12.24
Rank#43  Overall
#27  Relational DBMS
Score0.52
Rank#259  Overall
#41  Document stores
Websitewww.bigchaindb.comwww.citusdata.comclickhouse.comwww.dbase.comgithub.com/­techfort/­LokiJS
Technical documentationbigchaindb.readthedocs.io/­en/­latestdocs.citusdata.comclickhouse.com/­docswww.dbase.com/­support/­knowledgebasetechfort.github.io/­LokiJS
DeveloperClickhouse Inc.Asthon Tate
Initial release20162010201619792014
Current release8.1, December 2018v23.12.1.1368-stable, December 2023dBASE 2019, 2019
License infoCommercial or Open SourceOpen Source infoAGPL v3Open Source infoAGPL, commercial license also availableOpen Source infoApache 2.0commercialOpen Source
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.
  • DoubleCloud: Fully managed ClickHouse alongside best-in-class managed open-source services to build analytics at scale.
  • Aiven for Clickhouse: Managed cloud data warehousing with high-speed analytics.
  • ClickHouse Cloud: Get the performance you love from open source ClickHouse in a serverless offering that takes care of the details so you can spend more time getting insight out of the fastest database on earth.
Implementation languagePythonCC++JavaScript
Server operating systemsLinuxLinuxFreeBSD
Linux
macOS
DOS infodBase Classic
Windows infodBase Pro
server-less, requires a JavaScript environment (browser, Node.js)
Data schemeschema-freeyesyesyesschema-free
Typing infopredefined data types such as float or datenoyesyesyesno
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.noyes infospecific XML type available, but no XML query functionalitynono
Secondary indexesyesyesyesyes infovia views
SQL infoSupport of SQLnoyes infostandard, with numerous extensionsClose to ANSI SQL (SQL/JSON + extensions)nono
APIs and other access methodsCLI Client
RESTful HTTP API
ADO.NET
JDBC
native C library
ODBC
streaming API for large objects
gRPC
HTTP REST
JDBC
MySQL wire protocol
ODBC
PostgreSQL wire protocol
Proprietary protocol
none infoThe IDE can access other DBMS or ODBC-sources.JavaScript API
Supported programming languagesGo
Haskell
Java
JavaScript
Python
Ruby
.Net
C
C++
Delphi
Java
JavaScript (Node.js)
Perl
PHP
Python
Tcl
C# 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
Rust
Scala info3rd party library
dBase proprietary IDEJavaScript
Server-side scripts infoStored proceduresuser defined functions inforealized in proprietary language PL/pgSQL or with common languages like Perl, Python, Tcl etc.yesno infoThe IDE can access stored procedures in other database systems.View functions in JavaScript
Triggersyesnonoyes
Partitioning methods infoMethods for storing different data on different nodesShardingShardingkey based and customnonenone
Replication methods infoMethods for redundantly storing data on multiple nodesselectable replication factorSource-replica replication infoother methods possible by using 3rd party extensionsAsynchronous and synchronous physical replication; geographically distributed replicas; support for object storages.nonenone
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonononoyes
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate Consistencynone
Foreign keys infoReferential integritynoyesnoyesno
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDnono infonot for dBase internal data, but IDE does support transactions when accessing external DBMSno infoatomic operations within a single collection possible
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes
Durability infoSupport for making data persistentyes,with MongoDB ord RethinkDByesyesyesyes infoSerialization of a DB in a Node.JS/Cordova/PhoneGap environment. Usage of the IndexedDB-API in a browser.
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.noyesyes
User concepts infoAccess controlyesfine grained access rights according to SQL-standardAccess rights for users and roles. Column and row based policies. Quotas and resource limits. Pluggable authentication with LDAP and Kerberos. Password based, X.509 certificate, and SSH key authentication.Access rights for users and rolesno

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
3rd partiesDoubleCloud: Fully managed ClickHouse alongside best-in-class managed open-source services to build analytics at scale.
» more

Aiven for Clickhouse: Managed cloud data warehousing with high-speed analytics.
» more

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

More resources
BigchainDBCitusClickHousedBASELokiJS
DB-Engines blog posts

DB-Engines Ranking coverage expanded to 169 database management systems
3 June 2013, Paul Andlinger

show all

New kids on the block: database management systems implemented in JavaScript
1 December 2014, Matthias Gelbmann

show all

Recent citations in the news

Exploring the 10 BEST Python Libraries for Blockchain Applications
9 September 2023, DataDrivenInvestor

An Introduction to BigchainDB, a Popular Blockchain Database
17 September 2020, Open Source For You

Blockchain Database Startup BigchainDB Raises €3 Million
27 September 2016, CoinDesk

BigchainDB and Toyota announce decentralized exchange for sharing autonomous vehicle data
23 May 2017, CryptoNinjas

What is BigchainDB Technology & How it works and the Characteristics?
26 August 2017, Blockchain Council

provided by Google News

Ubicloud wants to build an open source alternative to AWS
5 March 2024, TechCrunch

Microsoft Benchmarks Distributed PostgreSQL DBs
10 July 2023, Datanami

How Citus Health Uses AWS to Provide Secure and Real-Time Virtual Patient Care - AWS Startups
18 August 2023, AWS Blog

Distributed PostgreSQL Benchmarks: Azure Cosmos DB, CockroachDB, and YugabyteDB
8 July 2023, InfoQ.com

Microsoft acquires Citus Data, re-affirming its commitment to Open Source and accelerating Azure PostgreSQL ...
24 January 2019, Microsoft

provided by Google News

Why Clickhouse Should Be Your Next Database
6 July 2023, The New Stack

ClickHouse Cloud & Amazon S3 Express One Zone: Making a blazing fast analytical database even faster | Amazon ...
28 November 2023, AWS Blog

ClickHouse Announces Launch of ClickPipes
26 September 2023, Datanami

Can LLMs Replace Data Analysts? Getting Answers Using SQL
22 December 2023, Towards Data Science

ClickHouse Announces ClickPipes: A Continuous Data Ingestion Service for ClickHouse Cloud
26 September 2023, Yahoo Finance

provided by Google News

30 Years Ago: The Rise, Fall and Survival of Ashton-Tate's dBASE
19 September 2013, eWeek

DBF File (What It Is and How to Open One)
6 April 2023, Lifewire

Microsoft Access 2016 Now Supports dBase Database Format
7 September 2016, redmondmag.com

DBASE 5.0 FOR WINDOWS HAS A BIG ENGINE, BUT LACKS SPEED
26 September 1994, The Washington Post

A malicious document could lead to RCE in Apache OpenOffice (CVE-2021-33035)
22 September 2021, Help Net Security

provided by Google News

LokiJS - A JavaScript Database
18 November 2014, iProgrammer

provided by Google News



Share this page

Featured Products

Milvus logo

Vector database designed for GenAI, fully equipped for enterprise implementation.
Try Managed Milvus 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

SingleStore logo

Build AI apps with Vectors on SQL and JSON with milliseconds response times.
Try it today.

Ontotext logo

GraphDB allows you to link diverse data, index it for semantic search and enrich it via text analysis to build big knowledge graphs. Get it free.

Neo4j logo

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

Present your product here