H2 Database Introduction - H2 Database

What is H2 Database Introduction?

H2 is an open-source lightweight Java database. It may be embedded in Java applications or run in the client-server mode. Specifically, H2 database may be configured to run as an in-memory database, which means that information will not persist on the disk. Due to the embedded database, it isn't used for production development, but frequently used for improvement and checking out.

This database can be used in embedded mode or in server mode. Following are the primary features of H2 database −

  • Extremely speedy, open supply, JDBC API
  • To be had in embedded and server modes; in-memory databases
  • Browser-based totally Console application
  • Small footprint − around 1.5MB jar file size

Features of H2 Database

The main features of H2 Database are as follows −

  • It is an extremely fast database engine.
  • H2 is open source and written in Java.
  • It supports standard SQL and JDBC API. It can use PostgreSQL ODBC driver too.
  • It has embedded and Server mode.
  • H2 supports clustering and multi-version concurrency.
  • It has strong security features.

Additional features

Following are a few extra features of H2 Database −

  • H2 is a disk-based or in-memory databases and tables, read-only database support, temporary tables.
  • H2 provides transaction support (read committed), 2-phase-commit a couple of connections, table level locking.
  • H2 is a cost-based optimizer, using a genetic algorithm for complex queries, zeroadministration.
  • H2 carries scrollable and updatable end result set support, large result set, external result sorting, functions can return a result set.
  • H2 supports encrypted database (AES), SHA-256 password encryption, encryption functions, and SSL.

Components in H2 Database

In order to use H2 Database, you need to have the following components −

  • A web browser
  • A H2 console server

This is a client/server application, so both server and client (a browser) are required to run it.

All rights reserved © 2020 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

H2 Database Topics