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