HSQLDB

HSQLDB


HSQLDB (Hyper Structured Query Language Database) is a relational database management system written in Java. It has a JDBC driver and supports a large subset of SQL-92 and SQL:2008 standards. It offers a fast, small (around 1300 kilobytes in version 2.2) 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, command line and GUI management tools (can be run as applets), and a number of demonstration examples. It can run on Java runtimes from version 1.1 upwards, including free Java runtimes such as Kaffe.
The HSQLDB is used for interactive user access to databases, including creation of a database, inserting or modifying data, or querying the database.
Main classes for the Hsqldb tools
*        org.hsqldb.util.DatabaseManager
*        org.hsqldb.util.DatabaseManagerSwing
When a tool is up and running, you can connect to a database (may be a new database) and use SQL commands to access and modify the data.
Tools can use command line arguments. You can add the command line argument --help to get a list of available arguments for these tools.

bullet point HSQLDB Catalog - Data Storage   click here
bullet point Connect Java with HSQL DB Tutorial   click here

No comments:

Post a comment