What is the H2 Database?

Card Puncher Data Processing


H2 is an embedded and standalone ANSI-SQL89 compliant SQL engine on top of the internal key-value mvstore.

Features / Advantages

The database is implemented in Java (It was used as an example by Flyway)

You have:

  • a SQL database
  • a Key-value database (ie mvstore)
  • support of the PostgreSQL network protocol (It works then with the Postgres ODBC driver)


Web Console

To start the embedded UI, you need to set the auto-server properties



then you can access the GUI to the URL: http://localhost:8082


The shell tool

java -cp h2-*.jar org.h2.tools.Shell

Documentation / Reference

Discover More
Card Puncher Data Processing
Database - HyperSQL DataBase (HSQLDB)

HSQLDB is a relational database written in Java. It is used as an embedded database to avoid the requirement of having a third-party database server running separately. for unit and integration...
Data System Architecture
What are embedded databases?

embedded databases are database that run in an embedded mode: It means that it: runs along the code of the application in the same thread does not run as a service (ie client server mode) Pros:...
Keycloak Db Idea
What is Keycloak?

Keycloak is an iam software that is OAuth 2.0 compliant. It's java based and supports multiple realms (ie application user repository) To start a local keycloak instance in a dev mode, with docker:...
What is a Railroad Diagram? known as Syntax diagram

A Railroad is a diagram that permits to visualize a grammar (Same as a process flow) With RRDiagram and BNF syntax of H2 select SQL A Railroad diagram is made of: a main diagram a set of syntax...

Share this page:
Follow us:
Task Runner