What is the H2 Database?

About

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)

UI

Web Console

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

Example:

jdbc:h2:./path;AUTO_SERVER=TRUE

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

Shell

The shell tool

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

Documentation / Reference

• H2