HSQLDB

from Wikipedia, the free encyclopedia
HSQLDB

Screenshot
HSQL database manager
Basic data

Maintainer Fred Toussi
Publishing year 2001
Current  version 2.5.0
(June 3, 2019)
operating system cross-platform
programming language Java
category Database management system
License modified BSD license
German speaking No
www.hsqldb.org

HSQLDB ( H yper S tructured Q uery L anguage D ata b ase ) is a free , completely in Java programmed relational SQL - database ( RDBMS ) and is under a free license according to the pattern of the BSD license . The project describes itself as a "Lightweight 100% Java SQL Database Engine " and is based on Thomas Müller's discontinued Hypersonic SQL Project.

In addition to the server, the HSQL package includes an SQL client (database manager) that works in both server and standalone mode. HSQLDB can be integrated into other applications as an embedded database system .

properties

In terms of speed, HSQLDB is roughly equivalent to MySQL . The table types stored on the data carrier can be operated in read-only mode, which is advantageous for projects on CD / DVD data carriers, for example . HSQLDB is integrated with OpenOffice.org and LibreOffice to provide an MS Access- like application.

HSQLDB supports large parts of the SQL standards 92, 99 and 2003. HSQLDB is available in several versions:

Difference to other database systems

HSQLDB differs from other database systems in many ways:

  • Size: hsqldb. jar is only ~ 1 MB in size.
  • Integrability: The package includes both an HSQL server that accepts SQL queries from the network (via JDBC ) and the option of operating the database completely without a server and thus integrating it into a program. Communication then only takes place via API calls and not via the network.
  • Flexibility: the following types of table are available:
    • Memory only : All data is only held in memory and not saved on the data carrier. Changes are lost when the server is closed (or the application in standalone mode).
    • Log file tables: All SQL commands that change the table data (CREATE, ALTER, INSERT, UPDATE) are saved in a large SQL log file. The log file is processed again at each start and then stored in the memory.
    • Cached tables: Tables stored on the data carrier that do not have to be completely read into memory at startup. The size limit of a table and a field is currently 8 TB. Working on such tables is very quick.

Products related to HSQLDB

The original developer Thomas Müller is currently working on the open source database H2 Database , which has similar goals as HSQLDB.

Web links

Individual evidence

  1. ^ HSQLDB Development. The Development Team. The development team. June 5, 2013, accessed August 8, 2015 .
  2. Copyrights and Licenses (based on BSD License) at hsqldb.org, accessed on July 1, 2016 (English).