HSQLDB Background
HSQLDB Icon

the leading SQL relational database engine written in Java

186
Downloads
3.3
3 Ratings
All Versions
186
Total Downloads
0
Downloads Last Week
Current Version
186
Total Downloads
0
Downloads Last Week
Downloads Last 10 Weeks
All Versions
3.3
3 Ratings
5
4
3
2
1
Current Version
3.3
3 Ratings
5
4
3
2
1

HSQLDBOverview

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.

New

Fixed some bugs.

HSQLDBTech Specs

Version
1.9.0 Rc 4
Date
08.13.09
License
Free
Language
English
File Size
5.90MB
Category
SubCategory
Operating Systems
Windows XP, 2000, 98
System Requirements
No additional system requirements.

SelectedFor You

Firebird Icon
Firebird Project
Firebird is a relational database offering many ANSI SQL standard features.
SQL Server 2008 R2 Express Icon
Microsoft Corporation
SQL Server 2008 Express Edition is a free, easy-to-use, lightweight, and embeddable version of SQL Server 2008.
PostgreSQL Icon
PostgreSQL Global Development Group
PostgreSQL is a powerful, open source object-relational database system.
phpMyAdmin Icon
phpMyAdmin devel team
Manage MySQL databases via the Web.
SQL Server 2008 Management Studio Express Icon
Microsoft Corporation
Microsoft SQL Server Management Studio Express is a free, easy-to-use graphical management tool.
SqlDbx Professional Edition Icon
ACS Technologies, Inc
SqlDbx is a fast and easy to use database SQL development IDE .
dbForge Studio for MySQL Professional Icon
Devart
Database development and administration environment for MySQL
DbVisualizer Icon
Dbvis Software
Connect to different databases through JDBC drivers.