Actian Ingres vs H2 Database Engine
Actian Ingres
actian.comH2 Database Engine
h2database.comSide by side
| Figure | Actian Ingres | H2 Database Engine |
|---|---|---|
| Price from | — | Free |
| Free plan | — | Yes |
| Free trial | — | — |
| Open source | — | — |
| Web | — | Yes |
| Windows | Yes | Yes |
| macOS | — | Yes |
| Linux | Yes | Yes |
| API | — | Yes |
| Self-hosted | — | Yes |
| Plans published | 0 | 1 |
| Spec score · Sql Databases | 6.1 (#21) | 8.1 (#11) |
Plans
In their own words
Actian Ingres
Actian Ingres has no write-up on Specifiction yet; its figures are above.
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.