HyperSQL 2.2.9

Operating systemsOS : Windows 2000,Windows XP/2003/2008,Windows Vista,Windows 7,MAC OS,Linux
Program licensingSoftware Licensing : Open source
CreatedCreated : May 9, 2011
Size downloadDownload size : 8.1 MBytes
Program licensing
Thank you for voting...
Test result: CLEAN

HyperSQL 2.2.9 HSQLDB - 100% Java Database...

SQL (HyperSQL by HSQLDB Development Team DataBase) is the leading SQL relational database engine written in Java. It has a JDBC driver and supports nearly full ANSI-92 SQL (BNF  format) plus many SQL:2008 enhancements. It offers a small, fast multithreaded and transactional database engine which offers in-memory and disk-based tables and supports embedded and server modes. Additionally, it includes tools such as a command line SQL tool and GUI query tools. The product is currently being used as a database and persistence engine in many Open Source Software projects and  in commercial projects and products. In its current supported versions it is extremely stable and reliable. It is best known for its small size, ability to execute completely in memory, its flexibility and speed. This feature-packed software is completely free to use and distribute under our licenses , based on the standard BSD license. Completely free of cost or restrictions and fully compatible with all major open source licenses. Java source code and extensive documentation included. Our group was formed in 2001 to continue the closed Hypersonic SQL Project. We have actively developed and released 10 new versions of the database since April 2001. Current code has little in common with Hypersonic SQL. The latest version features the most extensive set of SQL features ever in an open-srouce database engine. The project enjoys a high ranking among all SourceForge projects, over 1, 500, 000 direct downloads, and hundreds of millions of copies distributed as part of other software packages. Features Summary General

  • Original code, based on in-depth study of database theory and the SQL Standard

  • Ahead of other open-source solutions in supported SQL features

  • The fastest overall open-source SQL implementation for small and medium sized databases

  • Three transaction control models, including lock based and MVCC models

  • Fully multithreaded

  • Compact code footprint


  • 100% Java

  • Support JDK 1. 1. x, 1. 2. x, 1. 3. x, 1. 4. x, 1. 5. x, 1. 6. x in HyperSQL 2.2.9 1. 8. 1 and 1. 5. x and 1. 6. x in HyperSQL [hypersql2.2.9.exe] 2. 0

  • Extensive JDBC interface support with batch statement and scrollable ResultSet functionality

  • Updatable, insertable ResultSet functionality

  • Full JDBC DatabaseMetaData and ResultSetMetaData support

  • User-defined Java stored procedures and functions, including aggregate functions

  • Supports procedures with multiple INOUT params, returning multiple ResultSets, and functions returning ResultSet and Array objects

  • Java triggers, including synchronous and asynchronous execution

  • Full support for CallableStatement and PreparedStatement, including batch execution to speed up data processing


  • 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 datetime  arithmetic with and without time zone

  • Full support for powerful INTERVAL expressions, such as (CURRENT_DATE - 3 MONTH)

  • Supports user-defined DOMAIN types, including type constraints

  • Supports ARRAY objects of other data types with full syntax allowing access and conversions

  • Fast SELECT, INSERT, DELETE, UPDATE operations

  • MERGE statement allows single or multiple INSERT or UPDATE depending on existing data


  • NATURAL, USING and UNION joins

  • LATERAL and UNNEST in joins

  • UNION, EXCEPT, INTERSECT, including use of parentheses, limits and offsets, ALL, DISTINCT and CORRESPONDING keywords

  • Scalar (single value) SELECTS, row, table and correlated subqueries including IN, EXISTS, ANY, ALL

  • Views and temporary tables

  • Updatable, insertable into, deletable 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)


  • COUNT, SUM, MIN, MAX, AVG and statistical aggregate functions

  • Full support for SQL expressions such as CASE . . WHEN . . ELSE . . , NULLIF , BETWEEN, MATCHES, etc.

  • Extended SQL standard autoincrement IDENTITY column

  • Extended SQL standard support for sequences

  • SQL standard GENERATED columns calculated using other columns and function calls

  • Very extensive set of built-in functions

  • Transaction COMMIT, ROLLBACK and SAVEPOINT support

  • Multiple schemata per database

  • Triggers as blocks of SQL statements, including IF conditions

  • INSTEAD OF triggers which enable insert, update and delete on several tables with a single statement

  • SQL user-defined stored procedures and functions with full SQL procedural language support

  • SQL procedures can return multiple ResultSet objects

  • SQL  user-defined aggregate functions

  • Database security with passwords, user rights and roles with GRANT and REVOKE

  • Table level DELETE privileges and column level SELECT and UPDATE privileges

  • Extensive set of ALTER TABLE commands, including change of table column type

  • Full set of SQL Standard INFORMATION SCHEMA views

  • Query optimizer can use indexes for AND, OR, IN predicates, also ORDER BY, MAX, MIN 


  • In-memory tables for fastest operation

  • Disk based tables for large data sets

  • Text tables with external file data sources such as CSV files can be used as SQL tables

  • Fast CLOB and BLOB storage up to 64 TB with no memory limit on individual LOB size

  • Disk tables (CACHED TABLE) up to 256GB and text tables up to 2GB each

  • Size of each string or binary item only limited by memory

  • Fast startup and shutdown with internal incremental backup feature

  • Online and offline backup capability

  • Database dump as SQL script with or without data


  • Embedded (into Java applications) and Client-Server operating modes

  • Three client server protocols: HSQL, HTTP and HSQL-BER - can run as an HTTP web server - all with SSL option

  • Can be used in applets, read-only media (CD), inside jars, webstart and embedded applications

  • Multiple databases per JVM

  • ODBC support


  • SQLTool, powerful and compact Java command line  tools for database management, supports most leading databases

  • Two simple GUI database management tools

  • Transfer tool for conversion of databases to / from other popular database management systems

  • Test / script utility that can run SQL scripts with user-defined checks

What is new in official HyperSQL 2.2.9 software version? - Unable to resolve 2.2.9 news. What is expected in the future? Newly-made HyperSQL 2.3 be downloaded from current page, we also looking forward to unconfirmed 2.4 release build. You may download hsqldb-2.2.9.zip directly, estimated download time by ADSL or EDGE [~1.8 Mbit/s] is 0:00:36. Just write the reviews of the HyperSQL. System requirements are unspecified. Program has been scanned and verified by the several antivirus and anti-spyware applications and HyperSQL found to be clean. No guide or HyperSQL tutorial available. The following languages are supported by HyperSQL: English.

Put a free download button on your own website


Support HyperSQL, just copy+paste this html: