H2 Database Engine vs LMDB
H2 Database Engine
h2database.comLMDB
symas.comSide by side
| Figure | H2 Database Engine | LMDB |
|---|---|---|
| Price from | Free | — |
| Free plan | Yes | — |
| Free trial | — | — |
| Open source | — | — |
| Web | Yes | Yes |
| Windows | Yes | Yes |
| macOS | Yes | Yes |
| Linux | Yes | Yes |
| API | Yes | — |
| Self-hosted | Yes | Yes |
| Plans published | 1 | 2 |
| Spec score · Embedded Databases | 8.1 (#9) | 7.5 (#22) |
| License | H2 is dual licensed under MPL 2.0 or EPL 1.0, and the license page says it can be integrated into and distributed with commercial applications. | Symas states that LMDB is part of OpenLDAP and is under the OpenLDAP license, basically a BSD-style license. |
| Purpose | H2 is a free SQL database written in Java. | LMDB is an ultra-fast, ultra-compact, crash-proof key-value embedded data store developed for the OpenLDAP Project. |
| Support | The home page directs users to Stack Overflow and a Google Group for support. | Symas offers fixed-price Gold or Enterprise source-level support and porting or professional services for LMDB users. |
| Transactions | The feature list includes transaction support, multi version concurrency, and row level locking. | LMDB provides full ACID semantics with MVCC, reader/writer transactions, and deadlock-free serialized writes. |
Plans
In their own words
H2 Database Engine
H2 Database Engine is a free SQL database written in Java. It runs in embedded, server or mixed modes, with databases held on disk or in memory. H2 supports standard SQL and JDBC; server mode also accepts JDBC or ODBC over TCP/IP. A browser-based Console provides autocomplete. Listed database capabilities include transactions, multi-version concurrency and row-level locking, with JSON data support and high availability listed. Compatibility modes cover IBM DB2, Apache Derby, HSQLDB, MS SQL Server, MySQL, Oracle and PostgreSQL. Database files can use AES-128 encryption, while remote JDBC connections can use TLS. H2 is available for Linux, macOS and Windows, as an API, and for self-hosted or web deployment. It is dual licensed under MPL 2.0 or EPL 1.0, allowing integration into and distribution with commercial applications. The JAR is described as around 2.5 MB. The plan costs nothing.