H2 is a relational database management system that supports embedded operation and networked client-server access.
The database is particularly useful for applications requiring a compact SQL engine, local persistence or an in-memory database for testing and temporary processing.
H2 provides a JDBC interface and an interactive browser-based console. Its SQL compatibility modes help applications use syntax and conventions associated with other relational database systems.
This is free and open source software.
Key Features
- Supports embedded, in-memory and client-server database operation.
- Provides JDBC database connectivity.
- Includes a browser-based SQL console.
- Supports transactions, savepoints and multi-version concurrency control.
- Offers views, triggers, indexes, constraints and sequences.
- Provides SQL window functions and common table expressions.
- Includes compatibility modes for several established SQL databases.
- Supports encrypted database files and encrypted network connections.
- Provides full-text search facilities.
- Includes database backup, recovery and SQL scripting tools.
- Supports user-defined functions and stored procedures.
- Cross-platform support – runs on Linux, macOS, and Windows.
Website: github.com/h2database/h2database
Support:
Developer: H2 Developers
License: Mozilla Public License v2.0 or Eclipse Public License v1.0
H2 is written in Java. Learn Java with our recommended free books and free tutorials.
Related Software
| Relational Databases | |
|---|---|
| MariaDB | High compatibility with MySQL, ensuring drop-in replacement capability |
| PostgreSQL | Award winning Object-relational database management system |
| MySQL | Multithreaded, multi-user SQL database management system |
| SQLite | Embeddable SQL Database Engine |
| TiDB | Cloud-native, distributed SQL database |
| DuckDB | In-process SQL OLAP database management system |
| Turso | In-process relational database engine |
| YugabyteDB | PostgreSQL-compatible distributed SQL database |
| rqlite | Distributed database built on SQLite |
| MonetDB | High performance relational database system for analytics |
| Dolt | Version-controlled SQL database |
| Firebird | Relational database offering many ANSI SQL features |
| H2 | Relational database management system written in Java |
| HSQLDB | JDBC interface, client-server version, query tool, grid and more |
| CUBRID | Database engine with built-in enterprise grade features |
| Apache Cloudberry | Massively parallel processing database |
| Virtuoso | Data Management with Web Application Server and Web Services |
| Apache Derby | Full-featured relational database implemented entirely in Java |
Read our verdict in the software roundup.
LinuxLinks helps you discover the best free and open source software for Linux. Explore our extensive collection of recommended applications, including alternatives to popular proprietary software.We also publish software reviews, Linux tutorials, hardware reviews, free programming books and articles covering the wider open source community. Browse our Linux resources to discover more. Know a useful free and open source Linux application we haven't covered? Suggest a program for inclusion. Has your software been featured on LinuxLinks? Display one of our Featured on LinuxLinks badges on your website or GitHub README. |


Please read our Comment Policy before commenting.