HSQLDB
8.1#2 in relational databasesFrom $100 a yearFree planAPILinuxmacOSSelf-hosted
VisitHSQLDB vs LMDB
What both publish
| Fact | HSQLDB | LMDB |
|---|---|---|
| Concurrency | The engine is multithreaded and offers lock-based, MVCC and hybrid transaction-control models. | Readers do not block writers, writers do not block readers, and multiple processes can open the same environment on one host. |
| Integrations | The project documents JDBC and ODBC connectivity and integration with OpenOffice.org and LibreOffice. | Symas reports integrations with OpenDKIM, Heimdal Kerberos, Postfix, Cyrus SASL, MemcacheDB, SQLite3, and Riak. |
| License | HSQLDB source and binaries use permissive BSD-based licenses, with separate terms for legacy Hypersonic SQL code. | Symas states that LMDB is part of OpenLDAP and is under the OpenLDAP license, basically a BSD-style license. |
| Support | Support options include a help forum, a user mailing list, bug and feature request trackers, paid SupportWare, and professional commercial support. | Symas offers fixed-price Gold or Enterprise source-level support and porting or professional services for LMDB users. |
HSQLDB plans
- Developer subscription$100 a year
- Basic Corporate subscription—
- Premier Corporate subscription$2,500 a year
- HSQLDB softwareFree
- HSQLDBFree
- Developer SupportWare$100 a year
LMDB plans
- EnterprisePriced on request
- GoldPriced on request
Pick HSQLDB if…
HSQLDB may suit developers and organizations seeking a self-hosted Java database with embedded or server operation. Its listed tools and integrations may also be relevant to teams using the named Java and database projects.
Pick LMDB if…
LMDB suits developers needing a compact embedded key-value store for Windows or POSIX-compatible systems. It is also relevant when sorted keys, concurrent access, transactions, and local persistence are required.