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

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

Documentation / Reference

H2