What is the H2 Database?

Card Puncher Data Processing

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





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...
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:...
Compiler
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