H2 Database Engine vs WiredTiger
H2 Database Engine
h2database.comWiredTiger
source.wiredtiger.comSide by side
| Figure | H2 Database Engine | WiredTiger |
|---|---|---|
| Price from | Free | Free |
| Free plan | Yes | Yes |
| Free trial | — | — |
| Open source | — | — |
| Web | Yes | — |
| Windows | Yes | Yes |
| macOS | Yes | Yes |
| Linux | Yes | Yes |
| API | Yes | Yes |
| Self-hosted | Yes | Yes |
| Plans published | 1 | 1 |
| Spec score · Embedded Databases | 8.1 (#9) | 7.3 (#24) |
| Purpose | H2 is a free SQL database written in Java. | WiredTiger is a high-performance, scalable, transactional, open-source NoSQL data engine for data management. |
| Support | The home page directs users to Stack Overflow and a Google Group for support. | The project directs users to its user group and [email protected], and says to contact MongoDB for technical support. |
| Transactions | The feature list includes transaction support, multi version concurrency, and row level locking. | It provides ACID transactions with standard isolation levels and checkpoint-level or commit-level durability. |
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.
WiredTiger
WiredTiger has no write-up on Specifiction yet; its figures are above.