
HSQLDB
8.1#2 in relational databasesFrom $100 a yearFree planAPILinuxmacOSSelf-hosted
Visit
| Fact | HSQLDB | WiredTiger |
|---|---|---|
| Capacity | Official limits include disk tables up to 8 TB, text tables up to 256 GB and individual CLOB/BLOB storage up to 64 TB. | The overview states support for petabyte tables, records up to 4 GB, and 64-bit record numbers. |
| Concurrency | The engine is multithreaded and offers lock-based, MVCC and hybrid transaction-control models. | Its optimistic concurrency control avoids a centralized lock manager, and transactional operations in one thread do not block operations in other threads. |
| Maker | HSQLDB is developed and published by The HSQL Development Group, formed in 2001. | WiredTiger is developed and maintained by MongoDB, Inc., where it is the principal database storage engine. |
| Support | Support options include a help forum, a user mailing list, bug and feature request trackers, paid SupportWare, and professional commercial support. | The project directs users to its user group and [email protected], and says to contact MongoDB for technical support. |
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.
WiredTiger suits developers and teams seeking an embeddable transactional NoSQL or key/value data engine across supported 64-bit systems. Users considering tiered storage should note that it is experimental and not production-tuned.