SQL

H2 – embedded and server-based SQL database

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
MariaDBHigh compatibility with MySQL, ensuring drop-in replacement capability
PostgreSQLAward winning Object-relational database management system
MySQLMultithreaded, multi-user SQL database management system
SQLiteEmbeddable SQL Database Engine
TiDBCloud-native, distributed SQL database
DuckDBIn-process SQL OLAP database management system
TursoIn-process relational database engine
YugabyteDBPostgreSQL-compatible distributed SQL database
rqliteDistributed database built on SQLite
MonetDBHigh performance relational database system for analytics
DoltVersion-controlled SQL database
FirebirdRelational database offering many ANSI SQL features
H2Relational database management system written in Java
HSQLDBJDBC interface, client-server version, query tool, grid and more
CUBRIDDatabase engine with built-in enterprise grade features
Apache CloudberryMassively parallel processing database
VirtuosoData Management with Web Application Server and Web Services
Apache DerbyFull-featured relational database implemented entirely in Java

Read our verdict in the software roundup.


Best Free and Open Source Software 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.
Subscribe

Please read our Comment Policy before commenting.

Notify of
guest
0 Comments
Oldest
Newest Most Voted