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

DBMS > dBASE vs. DuckDB vs. HyperSQL vs. KairosDB vs. YDB

System Properties Comparison dBASE vs. DuckDB vs. HyperSQL vs. KairosDB vs. YDB

Editorial information provided by DB-Engines
NamedBASE  Xexclude from comparisonDuckDB  Xexclude from comparisonHyperSQL infoalso known as HSQLDB  Xexclude from comparisonKairosDB  Xexclude from comparisonYDB  Xexclude from comparison
DescriptiondBase 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.An embeddable, in-process, column-oriented SQL OLAP RDBMSMultithreaded, transactional RDBMS written in Java infoalso known as HSQLDBDistributed Time Series DBMS based on Cassandra or H2A distributed fault-tolerant database service, with high availability, scalability, immediate consistency and ACID transactions and providing an Amazon DynamoDB compatible API
Primary database modelRelational DBMSRelational DBMSRelational DBMSTime Series DBMSDocument store
Relational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score9.70
Rank#44  Overall
#28  Relational DBMS
Score4.63
Rank#69  Overall
#37  Relational DBMS
Score3.23
Rank#93  Overall
#48  Relational DBMS
Score0.67
Rank#233  Overall
#20  Time Series DBMS
Score0.33
Rank#287  Overall
#43  Document stores
#132  Relational DBMS
Websitewww.dbase.comduckdb.orghsqldb.orggithub.com/­kairosdb/­kairosdbgithub.com/­ydb-platform/­ydb
ydb.tech
Technical documentationwww.dbase.com/­support/­knowledgebaseduckdb.org/­docshsqldb.org/­web/­hsqlDocsFrame.htmlkairosdb.github.ioydb.tech/­en/­docs
DeveloperAsthon TateYandex
Initial release19792018200120132019
Current releasedBASE 2019, 20191.0.0, June 20242.7.2, June 20231.2.2, November 2018
License infoCommercial or Open SourcecommercialOpen Source infoMIT LicenseOpen Source infobased on BSD licenseOpen Source infoApache 2.0Open Source infoApache 2.0; commercial license available
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.
Implementation languageC++JavaJava
Server operating systemsDOS infodBase Classic
Windows infodBase Pro
server-lessAll OS with a Java VM infoEmbedded (into Java applications) and Client-Server operating modesLinux
OS X
Windows
Linux
Data schemeyesyesyesschema-freeFlexible Schema (defined schema, partial schema, schema free)
Typing infopredefined data types such as float or dateyesyesyesyesyes
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.nononono
Secondary indexesyesyesyesnoyes
SQL infoSupport of SQLnoyesyesnoSQL-like query language (YQL)
APIs and other access methodsnone infoThe IDE can access other DBMS or ODBC-sources.Arrow Database Connectivity (ADBC)
CLI Client
JDBC
ODBC
HTTP API infoJDBC via HTTP
JDBC
ODBC
Graphite protocol
HTTP REST
Telnet API
RESTful HTTP API (DynamoDB compatible)
Supported programming languagesdBase proprietary IDEC
C# info3rd party driver
C++
Crystal info3rd party driver
Go info3rd party driver
Java
Lisp info3rd party driver
Python
R
Ruby info3rd party driver
Rust
Swift
Zig info3rd party driver
All languages supporting JDBC/ODBC
Java
Java
JavaScript infoNode.js
PHP
Python
Go
Java
JavaScript (Node.js)
PHP
Python
Server-side scripts infoStored proceduresno infoThe IDE can access stored procedures in other database systems.noJava, SQLnono
Triggersnonoyesno
Partitioning methods infoMethods for storing different data on different nodesnonenonenoneSharding infobased on CassandraSharding
Replication methods infoMethods for redundantly storing data on multiple nodesnonenonenoneselectable replication factor infobased on CassandraActive-passive shard replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonononono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyEventual Consistency infobased on Cassandra
Immediate Consistency infobased on Cassandra
Immediate Consistency
Foreign keys infoReferential integrityyesnoyesnono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datano infonot for dBase internal data, but IDE does support transactions when accessing external DBMSACIDACIDnoACID
Concurrency infoSupport for concurrent manipulation of datayesyes, multi-version concurrency control (MVCC)yesyesyes
Durability infoSupport for making data persistentyesyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyesnono
User concepts infoAccess controlAccess rights for users and rolesnofine grained access rights according to SQL-standardsimple password-based access controlAccess rights defined for Yandex Cloud users

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
dBASEDuckDBHyperSQL infoalso known as HSQLDBKairosDBYDB
DB-Engines blog posts

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

show all

Recent citations in the news

AIHA and dBase Media Launch Season Two of Healthier Workplaces, A Healthier World, an Occupational and ...
13 June 2024, Business Wire

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

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

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

WFP DBase (Logistics Data, Budgets and Systems Execution) Factsheet (November 2019) - World
23 December 2019, ReliefWeb

provided by Google News

MotherDuck Announces General Availability; Brings Simplicity and Power of DuckDB in a Serverless Data Warehouse
11 June 2024, PR Newswire

DuckDB: The tiny but powerful analytics database
15 May 2024, InfoWorld

DuckDB promises greater stability with 1.0 release
5 June 2024, The Register

DuckDB: In-Process Python Analytics for Not-Quite-Big Data
31 May 2024, The New Stack

My First Billion (of Rows) in DuckDB | by João Pedro | May, 2024
1 May 2024, Towards Data Science

provided by Google News

HyperSQL DataBase flaw leaves library vulnerable to RCE
24 October 2022, The Daily Swig

Introduction to JDBC with HSQLDB tutorial
14 November 2022, TheServerSide.com

provided by Google News

Real-Time Performance and Health Monitoring Using Netdata
2 September 2019, CNX Software

provided by Google News

Personal Data Protection Service Initiates Probe into Yandex.Go App’s Data Processing
10 August 2023, Civil Georgia

Data leak from Russian delivery app shows dining habits of the secret police
3 April 2022, The Verge

Yandex code leak: Why hack of ‘Russian Google’s’ ranking factors has spooked the SEO industry
1 February 2023, The Indian Express

Russian Court Sues Yandex CEO For LGBT Propaganda Case
5 July 2023, VOI English

Russian secret police data leaked by food delivery app including where they live and what they eat...
4 April 2022, The US Sun

provided by Google News



Share this page

Featured Products

Neo4j logo

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

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

Present your product here