Most Popular New & Updated Top Rated Search Authors Contact Us

Linux Software › Database › Database Engines › hsqldb Database Engine 1.8.0

hsqldb Database Engine 1.8.0

HSQLDB is the leading SQL relational database engine written in Java

Developer:	The hsqldb Development Team more software by author →
Price:	0.00
License:	BSD License
File size:	0K
Language:
OS:
Rating:	0 /5 (0 votes)
Your vote:
enlarge screenshot

HSQLDB is the leading SQL relational database engine written in Java. hsqldb Database Engine has a JDBC driver and supports a rich subset of ANSI-92 SQL (BNF tree format) plus SQL 99 and 2003 enhancements.

It offers a small (less than 100k in one version), fast 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.

The product is currently being used as a database and persistence engine in many Open Source Software projects and even in commercial projects and products. In it's current version it is extremely stable and reliable. It is best known for its small size, ability to execute completely in memory and its speed.

This feature-packed software is completely free under our licenses , based on the standard BSD license. Yes, that's right, completely free of cost or onerous restrictions and fully compatible with all major open source licenses. Java source code and extensive documentation always included!

Here are some key features of "hsqldb Database Engine":

100% Java

A full RDBMS (Relational Database Management System), with the Object capabilities of Java

Switchable source code to support JDK 1.1.x, JDK 1.2.x, JDK (SE) 1.3.x, JDK (SE) 1.4.x.

Standard SQL (Structured Query Language) syntax

Correlated subqueries, inner and outer joins are possible

Views, Temp tables and sequences

Text Tables (with external file data sources such as csv files)

Primary key, unique and check constraints on single or multiple columns

ORDER BY, GROUP BY and HAVING are supported

COUNT, SUM, MIN, MAX, AVG, alone and in expressions

Full support for SQL language expressions such as CASE .. WHEN .. ELSE .. , NULLIF etc.

Transaction support

Supports Referential Integrity (foreign keys) with full cascading options (delete, update, set null, set default)

Java Stored Procedures and Functions can be called

Triggers

Database Security functions

95% JDBC interface support with full metadata and batch statement functionality

All JDBC 1 data types supported, also 'Object' , Blob and Clob

In-memory, Standalone and Client-Server operating modes

A small WebServer and a Servlet is included

It can be used in Applets and Applications

Autoincrement column support

Cached or Text tables up to 2 gigabytes

Size of strings and binary data only limited by memory

Indexes can be created for one or many fields

JDBC Metadata support

Readonly connection and database support

An SQL script describing the database can be created

Database security

There is a built-in security system using users, passwords and access rights. There exists by default a 'System Administrator' with the user name 'sa' and the password '' (empty password). This special user can create new users, drop users and grant and revoke access rights for tables or stored procedures to other users. The general users can only change their own password and connect as another user. All this user administration can be done by SQL scripts (GRANT, REVOKE). Access can be granted also to PUBLIC.

Identity (autoincrement) column type

Identity columns can be used to serve as automatic unique row identifier for a table. When a new row is added to the table and the identity column is not inserted (or a NULL value is inserted), then HSQLDB provides a unique, incremental value for the column. The identity column is automatically the primary key of the table. Only one identity column can be created per table. In HSQLDB, any value can be used for updating or inserting in an identity column provided it does not violate the primary key constraint.

Metadata support

HSQLDB supports extensive system tables that are build dynamically when a query is made to them. These tables provide database metadata. The names of the tables are 'SYSTEM_' followed by the corresponding JDBC DatabaseMetaData method. For example the methode 'getColumns(...)' queries the table 'SYSTEM_COLUMNS'. There are several other system tables reporting on database tables, indexes, primary keys, foreign keys etc.

Readonly connection and database support

Connections can be set to readonly using the command SET READONLY [TRUE|FALSE] or using the method Connection.setReadOnly(boolean readonly). Additionally the whole database can be put in read-only mode by manually adding the line 'readonly=true' to the .properties file. All connections are then automatically readonly. The database files will then be opened in readonly mode, and it is thus possible to create a CD with this database. Other variations, allow modifiable readonly database (changes are discarded at shutdown) or inclusion of a database in the application JAR.
tags

identity column database engine the table primary key the database database can database support connection and and database access rights revoke access system tables using the

Download hsqldb Database Engine 1.8.0

http://prdownloads.sourceforge.net/hsqldb/hsqldb_1_8_0_6.zip?use_mirror=heanet

http://prdownloads.sourceforge.net/hsqldb/hsqldb_1_8_0_6.zip?use_mirror=mesh

http://prdownloads.sourceforge.net/hsqldb/hsqldb_1_8_0_6.zip?use_mirror=jaist

Authors software

hsqldb Database Engine 1.8.0 (by The hsqldb Development Team)
HSQLDB is the leading SQL relational database engine written in Java

Similar software

hsqldb Database Engine 1.8.0 (by The hsqldb Development Team)
HSQLDB is the leading SQL relational database engine written in Java

H2 Database Engine 1.0/2006-12-03 (by H2)
H2 Database Engine is a free SQL database engine writen in Java.

JDBC and ODBC APIs are supported

PHP SQLDiff 2.2 (by Terry Gliedt)
PHP SQLDiff is a Web application that shows the difference between two SQL database tables.

If you manage your database tables lik

PHP SQLView 2.4 (by Terry Gliedt)
SQLView provides a user friendly interface for browsing a SQL database and modifying SQL tables using a Web browser.

This is stric

GEBORA Beta5 (by Eduardo Costa)
GEBORA is an administrative tool for the Oracle Relational Database Management System

phpMyAdmin 2.9.1.1 (by phpMyAdmin Devel Team)
phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the WWW.

Currently it can create and drop

Gaudi - Database Visual Editor 1r1 (by Memoria Persistente)
Gaud? - Database Visual Editor is a Java application that allows you to visually design the tables of a database using a JDBC 2.0 (or

DbVisualizer 5.1.1 (by Roger Bj?revall)
DbVisualizer project is a cross-platform database tool for all major relational databases

Druid 3.8 (by Andrea Carboni)
Druid project is a tool that allows users to create databases in a graphical way

MyJSQLView 2.63 (by MyJSQLView Team)
MyJSQLView provides an easy to use Java based user interface frontend for viewing, adding, editing, or deleting entries in a MySQL da

Other software in this category

Berkeley DB 4.5.20 (by Oracle)
Berkeley DB (libdb) is a programmatic toolkit that provides embedded database support for both traditional and client/server applicat

phpPgAdmin 4.0.1 (by Christopher Kings-Lynne)
phpPgAdmin is a web-based administration tool for PostgreSQL

SQLite 3.3.8 (by D. Richard Hipp)
SQLite is a small C library that implements a self-contained, embeddable, zero-configuration SQL database engine.

Here are some ke

Firebird Relational Database 2.0 Final (by Firebird Project)
Firebird is a relational database offering many ANSI SQL-99 features that runs on Linux, Windows, and a variety of Unix platforms.

gdbm 1.8.3 (by Phil Nelson)
gdbm is a database indexing library replacement for the traditional 'dbm' and 'ndbm' libraries