HSQLDB
| HSQLDB
|
|
|---|---|
 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:
- Standard version, such as is integrated in the WildFly application server, for example
- 100 kB small, fast version
- special versions for PDA and handheld
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
- Official website (English)
- Databases with OpenOffice.org 3 Base & HSQLDB incl. DVD
- Eclipse and HSQLDB: Embedding a relational database server into Eclipse, Part 1 (English)
- Eclipse and HSQLDB: Embedding a relational database server into Eclipse, Part 2 (English)
Individual evidence
- ^ HSQLDB Development. The Development Team. The development team. June 5, 2013, accessed August 8, 2015 .
- ↑ Copyrights and Licenses (based on BSD License) at hsqldb.org, accessed on July 1, 2016 (English).