What is HSQLDB?

What is HSQLDB?

HSQLDB is an open source, cross-platform, SQL, relational database management system (RDBMS). It's also known as HyperSQL or HSQL database engine. It's written in Java so a JRE (Java Runtime Environment) must be installed (or available as a portable app) in order to utilize this database engine.

Version 1.8.0.10 (circa 2005) of HSQLDB is integrated with OpenOffice (AOO/LibO).

The integrated JDBC driver supports several HSQLDB operating modes including two with Base.

• In-process ('file mode') provides seamless, single-user access with Base. "Seamless" implies automated database access with no need to start/stop a database server; similar to H2, dBase, and SQLite.
• Client-server ('server mode') provides multi-user access on a network or locally from client-applications such as Base.