Version 2.3.1 Released!
Version 2.3.1 is now available from the file download page.
SourceForge Project of the Month January 2012
HyperSQL was selected as the SourceForge Project of the Month for
January 2012 and was featured on SourceForge.net home page. An
interview with core developers is published here.
HSQLDB (HyperSQL DataBase) is the leading SQL
relational database engine written in Java. It offers a small, fast
multithreaded and transactional database engine with in-memory and
disk-based tables and supports embedded and server modes. It includes a
powerful command line SQL
tool and simple GUI query tools.
HSQLDB supports the widest range of SQL Standard features seen in
any open source database engine: SQL:2011 core language features and an
extensive list of SQL:2011 optional features. It supports nearly full
SQL (BNF format).
Many extensions to the Standard, including syntax compatibility and
features of other popular database engines, are also supported.
Version 2.3.1 is fully
multithreaded and supports high performance 2PL and MVCC
(multiversion concurrency control) transaction control models. See the
list of new features in version
HSQLDB has been constantly developed over 12 years and
is used as a database and persistence engine in over 1700 Open Source
Software projects and many commercial products. The latest versions are
extremely stable and reliable. It is known for its small size, ability
to execute completely or partly in memory, its flexibility and
HSQLDB is completely free to use and distribute under
our licenses, based on the standard
BSD license and fully compatible with all major open source
The database performance test package PolePosition compares the
performance of relational and object databases for storing objects.
We ran the PolePosition 0.4 tests with HSQLDB 2.2.6 embedded and server
(both with disk tables with sync-on-commit), Apache Derby embedded and
MySQL+InnoDB server. See the results,
which show the query processing improvements in HSQLDB 2.2.x.
Our group was formed in 2001 and has released 10 major
new versions of the database. Early versions were based on code from
the closed Hypersonic SQL project while the latest code has little in
common with it. Direct downloads exceed 1,800,000 copies, with hundreds
of millions of copies distributed as part of other software
New Developments for 2013
The 2.3.0 series has just been launched. It enhances reliablility
and performance compared to previous releases.
The latest version improves on access and management of very large
data sets. It supports up to 270 billion rows of data in a single
database and a hot backup capability.
New SupportWare subscriptions are invited to fund the development
and maintenance effort.
HSQLDB is Java developers' best choice for development, testing and
deployment of database applications.
HSQLDB SupportWare allows individual developers and
organizations to support the development and maintenance of HSQLDB.
Participation in the program is by annual subscription or
Developer subscription - $100 or €80
Corporate subscription - $500 - $2500 or €400 - €2000
Allows you to sponsor new features or the whole
How to join
details on SupportWare