eXtremeDB vs H2 Database Engine

eXtremeDB is an in-memory database system designed for embedded devices and applications. It can combine in-memory and persistent storage within one database system. Interfaces include native APIs, REST, SQL, ODBC, and JDBC, with language APIs for C/C++, Java, Python, C#, Go, and Rust. For time-series data, a sequence type provides columnar storage. Distributed options include High Availability, Cluster, and Active Replication Fabric for replication across IoT tiers. Network communications can use TLS/SSL with OpenSSL or wolfSSL. Technical specifications list maximum database sizes of 4 GB on 32-bit architectures and 18.4 exabytes on 64-bit architectures. eXtremeDB supports Android, iOS, Linux, macOS, and Windows, and can be self-hosted. Evaluation downloads are listed for Linux, macOS, and Windows; custom trial packages can be requested for other platforms. McObject offers annual engineering support contracts that include software updates and a 50 percent discount on major upgrades. Commercial licensing is paid, with pricing available on request, and a 60-day trial is listed.

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.