DBMS > H2 vs. HyperSQL vs. KeyDB vs. Solr

System Properties Comparison H2 vs. HyperSQL vs. KeyDB vs. Solr

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
Name	H2  Xexclude from comparison	HyperSQL also known as HSQLDB  Xexclude from comparison	KeyDB  Xexclude from comparison	Solr  Xexclude from comparison
Description	Full-featured RDBMS with a small footprint, either embedded into a Java application or used as a database server.	Multithreaded, transactional RDBMS written in Java also known as HSQLDB	An ultra-fast, open source Key-value store fully compatible with Redis API, modules, and protocols	A widely used distributed, scalable search engine based on Apache Lucene
Primary database model	Relational DBMS	Relational DBMS	Key-value store	Search engine
Secondary database models	Spatial DBMS			Spatial DBMS
DB-Engines Ranking measures the popularity of database management systems Trend Chart	Score 9.90 Rank #51   Overall #31   Relational DBMS	Score 5.46 Rank #76   Overall #41   Relational DBMS	Score 0.34 Rank #268   Overall #40   Key-value stores	Score 56.61 Rank #20   Overall #3   Search engines
Website	www.h2database.com	hsqldb.org	github.com/­JohnSully/­KeyDB keydb.dev	lucene.apache.org/­solr
Technical documentation	www.h2database.com/­html/­main.html	hsqldb.org/­web/­hsqlDocsFrame.html	docs.keydb.dev	lucene.apache.org/­solr/­resources.html
Developer	Thomas Mueller		EQ Alpha Technology Ltd.	Apache Software Foundation
Initial release	2005	2001	2019	2006
Current release	2.1.210, January 2022	2.6.1, October 2021		9.0.0, May 2022
License Commercial or Open Source	Open Source dual-licence (Mozilla public license, Eclipse public license)	Open Source based on BSD license	Open Source BSD-3	Open Source Apache Version 2
Cloud-based only Only available as a cloud service	no	no	no	no
DBaaS offerings (sponsored links) Database as a Service Providers of DBaaS offerings, please contact us to be listed.
Implementation language	Java	Java	C++	Java
Server operating systems	All OS with a Java VM	All OS with a Java VM Embedded (into Java applications) and Client-Server operating modes	Linux	All OS with a Java VM runs as a servlet in servlet container (e.g. Tomcat, Jetty is included)
Data scheme	yes	yes	schema-free	yes Dynamic Fields enables on-the-fly addition of new fields
Typing predefined data types such as float or date	yes	yes	partial Supported data types are strings, hashes, lists, sets and sorted sets, bit arrays, hyperloglogs and geospatial indexes	yes supports customizable data types and automatic typing
XML support Some form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.	no	no	no	yes
Secondary indexes	yes	yes	yes by using the Redis Search module	yes All search fields are automatically indexed
SQL Support of SQL	yes	yes	no	Solr Parallel SQL Interface
APIs and other access methods	JDBC ODBC	HTTP API JDBC via HTTP JDBC ODBC	Proprietary protocol RESP - REdis Serialization Protoco	Java API RESTful HTTP/JSON API
Supported programming languages	Java	All languages supporting JDBC/ODBC Java	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	.Net Erlang Java JavaScript any language that supports sockets and either XML or JSON Perl PHP Python Ruby Scala
Server-side scripts Stored procedures	Java Stored Procedures and User-Defined Functions	Java, SQL	Lua	Java plugins
Triggers	yes	yes	no	yes User configurable commands triggered on index changes
Partitioning methods Methods for storing different data on different nodes	none	none	Sharding	Sharding
Replication methods Methods for redundantly storing data on multiple nodes	With clustering: 2 database servers on different computers operate on identical copies of a database	none	Multi-source replication Source-replica replication	yes
MapReduce Offers an API for user-defined Map/Reduce methods	no	no	no	spark-solr: github.com/­lucidworks/­spark-solr and streaming expressions to reduce
Consistency concepts Methods to ensure consistency in a distributed system	Immediate Consistency	Immediate Consistency	Eventual Consistency Strong eventual consistency with CRDTs	Eventual Consistency
Foreign keys Referential integrity	yes	yes	no	no
Transaction concepts Support to ensure data integrity after non-atomic manipulations of data	ACID	ACID	Optimistic locking, atomic execution of commands blocks and scripts	optimistic locking
Concurrency Support for concurrent manipulation of data	yes, multi-version concurrency control (MVCC)	yes	yes	yes
Durability Support for making data persistent	yes	yes	yes Configurable mechanisms for persistency via snapshots and/or operations logs	yes
In-memory capabilities Is there an option to define some or all structures to be held in-memory only.	yes	yes	yes	yes
User concepts Access control	fine grained access rights according to SQL-standard	fine grained access rights according to SQL-standard	simple password-based access control and ACL	yes
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
	H2	HyperSQL also known as HSQLDB	KeyDB	Solr
DB-Engines blog posts