HSQLDB
| HSQLDB | |
| Latest release: | 1.8.0.8 / August 28, 2007 |
|---|---|
| OS: | Cross-platform |
| Genre: | RDBMS |
| License: | BSD license |
| Website: | hsqldb.org |
HSQLDB is a relational database management system written in Java. It is based on Thomas Mueller's discontinued Hypersonic SQL Project[1]. The software is available under a BSD license.
It has a JDBC driver and supports a rich subset of SQL-92, SQL-99, and SQL:2003 standards[2]. It offers a fast[3], small (less than 100k in one version, around 600k in the standard version) database engine which offers both in-memory and disk-based tables. Embedded and server modes are available.
Additionally, it includes tools such as a minimal web server, in-memory query and management tools (can be run as applets), and a number of demonstration examples. HSQLDB is currently being used as a database and persistence engine in many open source software projects, such as OpenOffice.org Base and the Standalone Roller Demo,[4] as well as in commercial projects and products, such as InstallShield or InstallAnywhere (starting with version 8.0).
It is best known for being bundled with Hibernate, a popular object-relational mapping library for Java. It can also run on free Java runtimes such as Kaffe.
Please Note: The JDBC is not fully implemented. For example, there is no way to use the update method to change an existing row of data; you'll get a not-implemented error (with very cryptic suggestions at how to work around it from the HSQLDB documentation). What works: Select the row that you want to change, read the row, save the contents, delete the row, alter the elements that you want changed (that you saved) and insert a new row. This a minor issue, however you will likely encounter this if migrating working JDBC from another Relational Database implementation.
See also
- List of relational database management systems
- Comparison of relational database management systems
- OpenOffice.org Base
References
- ^ The new HSQLDB. hsqldb.org.
- ^ HSQLDB SQL Syntax. hsqldb.org.
- ^ HSQLDB Performance Comparison. hsqldb.org.
- ^ Standalone Roller Demo. rollerweblogger.org.
External links
This entry is from Wikipedia, the leading user-contributed encyclopedia. It may not have been reviewed by professional editors (see full disclaimer)
