HSQLDB
for Windows

the leading SQL relational database engine written in Java

  • Total Downloads
    171
  • Downloads Last Week
    0
  • User Rating
    3.3
  • My Rating

HSQLDB Description

HSQLDB is the leading SQL Relational database engine written in Java. It 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 for applets), fast database engine which offers both in-memory and disk-based tables and supports embedded and server modes. 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.
Features Summary
SQL

* Relational Database Management System, which can store Serializable Java objects
* Very extensive support for SQL:2008 Standard syntax, including most optional features
* Supports all base data types of the SQL Standard, including BINARY, BIT, BOOLEAN, date-time, INTERVAL, BLOB, CLOB
* Supports user-defined DOMAIN types, including type constraints
* Fast SELECT, INSERT, DELETE, UPDATE and MERGE operations
* INNER, LEFT OUTER, RIGHT OUTER and FULL joins
* NATURAL, USING and UNION joins
* UNION, EXCEPT, Intersect, including use of parentheses, limits and offsets, ALL, DISTINCT and CORRESPONDING keywords
* Scalar (single value) SELECTS, row and correlated subqueries including IN, EXISTS, ANY, ALL
* Views, Temp tables and sequences
* Updatable views
* Primary key, unique and check constraints on single or multiple columns
* Referential Integrity (foreign keys) on multiple columns with full cascading options (delete, update, set null, set default)
* ORDER BY, GROUP BY and HAVING
* COUNT, SUM, MIN, MAX, AVG and statistical aggregate functions

new:
Fully multithreaded core supports 2PL (two-phased locking) and MVCC (multiversion concurrency control). Transactions can be SERIALIZABLE or READ COMMITTED, using strict 2PL concurrency control. adds SNAPSHOT ISOLATION and READ CONSISTENCY, which are comparable to REPEATABLE READS and READ COMMITTED isolation levels.

HSQLDB Screenshots

Screenshots are not available currently.

What's New in HSQLDB 1.9.0 Rc 4

Release notes are not available currently.

HSQLDB Requirements

Operating Systems:

Windows XP, 2000, 98

System Requirements:

No additional system requirements.

Quick Specifications

See Full Specifications

Essential Downloads in Databases

  • Crystal Reports Server XI
    Transforming data into actionable information accessible anytime, anywhere
  • Firebird
    Firebird is a relational database offering many ANSI SQL standard features.
  • DbVisualizer
    Connect to different databases through JDBC drivers.
  • Allegro CL
    Persistency built in, not a database add-on.
  • phpMyAdmin
    Manage MySQL databases via the Web.
  • MySQL
    MySQL Community Edition is the world's most popular open source database.
See More