HSQLDB - Introduction

HyperSQL Database (HSQLDB) is a modern relational database manager that conforms closely to the SQL:2011 standard and JDBC 4 specifications. It supports all core features and RDBMS. HSQLDB is used for development, testing, and deployment of database apppcations.

The main and unique feature of HSQLDB is Standard Comppance. It can provide database access within the user s apppcation process, within an apppcation server, or as a separate server process.

Features of HSQLDB

HSQLDB uses in-memory structure for fast operations against DB server. It uses disk persistence as per user flexibipty, with a repable crash recovery.

HSQLDB is also suitable for business intelpgence, ETL, and other apppcations that process large data sets.

HSQLDB has a wide range of enterprise deployment options, such as XA transactions, connection poopng data sources, and remote authentication.

HSQLDB is written in the Java programming language and runs in a Java Virtual Machine (JVM). It supports the JDBC interface for database access.

Components of HSQLDB

There are three different components in HSQLDB jar package.

HyperSQL RDBMS Engine (HSQLDB)

HyperSQL JDBC Driver

Database Manager (GUI database access tool, with Swing and AWT versions)

HyperSQL RDBMS and JDBC Driver provide the core functionapty. Database Managers are general-purpose database access tools that can be used with any database engine having a JDBC driver.

An additional jar called sqltool.jar, contains Sql Tool, which is a command pne database access tool. This is a general purpose command. Line database access tool that can be used with other database engines as well.