Menu

HyperSQL Database Engine (HSQLDB) / News: Recent posts

HyperSQL version 2.7.3 released

Version 2.7.3 was released in May 2024 on SourceForge and Maven https://repo1.maven.org/maven2/org/hsqldb/. This version has some new features and enhancements.

Posted by Fred Toussi 2024-05-31

HSQLDB Release Candidate for version 2.7.3

New Release Candidate jars are available here:
https://sourceforge.net/projects/hsqldb/files/release_candidate/

Please test and report any issues.

Posted by Fred Toussi 2024-05-22

HyperSQL version 2.7.2 released

Version 2.7.2 was released on 1 June 2023. This version has some enhancements and fixes for reported bugs.

Posted by Fred Toussi 2023-06-04

HyperSQL version 2.7.1 released

Version 2.7.1 was released on 20 October 2022. This version changes the default for the use of Java methods as a security feature. Enhancements to recursive queries and some minor bug fixes are also included.

Posted by Fred Toussi 2022-10-23

HyperSQL version 2.7.0 released

Version 2.7.0 was released on 18 July 2022. It features JSON constructor functions, direct CSV data load and save, improved region-based date time handling and bug fixes, The main jars require Java 11 or later. These are Java module jars containing modules org.hsqldb and org.hsqldb.sqltool. Jars for Java 8 are also in the zip package available from http://hsqldb.org. The documentation on the web site covers the latest release.

Posted by Fred Toussi 2022-07-23

HSQLDB Release Candidate 3 for version 2.7.0

New Release Candidate jars are available here:
https://sourceforge.net/projects/hsqldb/files/release_candidate/

Please test and report any issues.

Posted by Fred Toussi 2022-07-03

HSQLDB Release Candidate for version 2.7.0

Release candidate jars are available here:
https://sourceforge.net/projects/hsqldb/files/release_candidate/

Please test and report any issues. Final release is due in 2 weeks.

Posted by Fred Toussi 2022-06-01

HyperSQL version 2.6.1 released

Version 2.6.1 was released on 21 October 2021. The main jars require Java 11 or later. These are Java module jars containing modules org.hsqldb and org.hsqldb.sqltool. Jars for Java 8 are also in the zip package. Version 2.6.1 jars for Java 6 are available from http://hsqldb.org/download/. The documentation on the web site covers the latest release.

Posted by Fred Toussi 2021-10-21

Maven Releases of version 2.6.0

Version 2.6.0 for JDK 8 has been released to Maven under version number 2.5.2, which is also the version in the Jar manifests. The version reported inside HSQLDB is 2.6.0.

Version 2.6.0 for JDK11 has been released to Maven with identical version number.

Posted by Fred Toussi 2021-04-12

HyperSQL version 2.6.0 released

Version 2.6.0 was released on 21 March. The main jars require Java 11 or later. These are Java module jars containing modules org.hsqldb and org.hsqldb.sqltool. An hsqldb-jdk8.jar is also in the zip package. Version 2.6.0 jars for Java 8 and Java 6 are now available from http://hsqldb.org/download/. The documentation on the web site covers the latest release.

Posted by Fred Toussi 2021-03-27

HyperSQL version 2.6.0 release candidate

Release Candidate Jars for version 2.6.0 are now available from http://hsqldb.org/download/ The jars require Java 11 or later. Jars for Java 8 and Java 6 will be available with the final release. The documentation on the web site covers the latest release.

Posted by Fred Toussi 2021-03-04

HyperSQL version 2.5.1 released

Version 2.5.1 adds GROUPING SETS, CUBE and ROLLUP support with ALL and DISTINCT qualifiers. Improvements to Fine-Grained Access Control at row level, and data file space management, are among the many enhancements in this release.

Posted by Fred Toussi 2020-06-30

HyperSQL version 2.5.0 released

Version 2.5.0 has several new features. System-Versioned Temporal tables keep full histories of updated and deleted rows. Fine-Grained Access Control works at row level. Log-based synchronization keeps replicas in sync. There are also many bug fixes and enhancements in this release.

Posted by Fred Toussi 2019-06-03

HyperSQL version 2.5.0 getting ready

Preview of #HyperSQL version 2.5.0 is in SVN dev-three branch. Checkout, build and run your tests. Docs on trunk also updated. System-Versioned Temporal tables keep full histories of updated and deleted rows. Fine Grained Access Control works at row level.

Posted by Fred Toussi 2019-01-29

HSQLDB 2.3.4 Released!

The latest version of HSQLDB is available for download at hsqldb.org.

New features include support for creating SYNONYM for tables and functions, PERIOD predicates, the UUID type, and TIMESTAMP columns with automatic update on row update. UTF-16 files are now supported for text table sources. Improved MySQL compatibility for REPLACE, INSERT IGNORE and ON DUPLICATE KEY UPDATE statements.

This release incorporates extensive code reviews, enhancements and bug fixes.

Posted by Fred Toussi 2016-05-16

HSQLDB 2.3.3 Released

The latest version of HSQLDB is available for download at hsqldb.org.

New features include support for DELETE and additional search conditions in MERGE statements, support for LIMIT in DELETE and UPDATE statements, plus extended MySQL compatibility, including, REPLACE, INSERT IGNORE and ON DUPLICATE KEY UPDATE.

This release incorporates extensive code reviews, enhancements and bug fixes.

Posted by Fred Toussi 2015-06-30

HSQLDB 2.3.3 Release Candidate

The next version of HSQLDB is due to be released very soon. The latest release candidate snapshot jar is now available from http://hsqldb.org/repos/org/hsqldb/hsqldb/SNAPSHOT/

New features include support for DELETE and additional search conditions in MERGE statements, support for LIMIT in DELETE and UPDATE statements, plus extended MySQL compatibility, including, REPLACE, INSERT IGNORE and ON DUPLICATE KEY UPDATE.

Posted by Fred Toussi 2015-06-17

HSQLDB 2.3.2 Released!

The final release package for HyperSQL Database version 2.3.2 is available from http://hsqldb.org. This release completes the development cycle for the 2.3.x series with several bug fixes and enhancements.

Posted by Fred Toussi 2014-02-15

HSQLDB 2.3.1 Released!

The final release package for HyperSQL Database version 2.3.1 is available from http://hsqldb.org.

Posted by Fred Toussi 2013-10-09

HSQLDB 2.3.0 Released!

The final release package for version 2.3.0 is available from http://hsqldb.org.

Posted by Fred Toussi 2013-07-08

HSQLDB 2.3.0 Final Release Candidate

The latest Release Candidate for version 2.3.0 is available from http://hsqldb.org. The Final release will follow shortly.

Posted by Fred Toussi 2013-06-06

HSQLDB 2.2.9 Released

This release completes the dvelopment of the 2.2 series. It features extensive enhancements and bug fixes.

Posted by Fred Toussi 2012-08-06

HSQLDB 2.2.9 Snapshot

A release candidate snapshot jar for the forthcoming version 2.2.9 has just been released. Please check and report any issues.

http://www.hsqldb.org/repos/org/hsqldb/hsqldb/SNAPSHOT/

Posted by Fred Toussi 2012-07-02

HSQLDB 2.2.8 Final Release

HSQLDB was featured as the SourceForge Project of the Month for January 2012.

This is the second release this month. It adds hot backup of database files and fixes a recently discovered issue with database recovery after a crash, present in 2.2.6 and 2.2.7. This version should be used for development and deployment in preference to all earlier 2.x releases. Also available on Maven.

Posted by Fred Toussi 2012-01-22

HSQLDB 2.2.7 Final Release

HSQLDB was featured as the SourceForge Project of the Month for January 2012.

The latest version has several enhancements, bug fixes and extra features. This version should be used for development and deployment in preference to all earlier 2.x releases. Also available on Maven.

Posted by Fred Toussi 2012-01-15