Overview

HyperXtremeSQL™ shares HSQLDB's interface and most of the query-processing classes, so it is fully compatible at the application level with the latest release version of HSQLDB. In addition, the new core has been written in such a way that the behaviour is very similar to HSQLDB. For example, the rows returned from a SELECT query without an ORDER BY clause will be generally in the same order.

Shared features are covered extensively on the HSQLDB WEB SITE. Some important common features are listed below:

• Fully multithreades with MVCC and two phase lock transaction models
• Full support for SQL:2008 core features and around 150 optional features
• Embedded (in-process) and client-server modes of operation
• ACID compliance and full support for transactions

Additional documentation on specific aspects of HXSQL (namely configuration, speed and memory usage) is supplied with the software.

^ TOP

Specific HXSQL Features

Apart from overall speed improvement, the new core in HyperXtremeSQL offers several other advantages:

• All aggregate queries are much faster, even with conditions.
• Creation of indexes, unique and foreign key constraints is much faster than HSQLDB.
• Dropping indexes and constraints is almost instant.

HyperXtremeSQL is supplied in binary format only. There are different binaries for different JDK versions. Jar sizes for embedded platforms start are around 350KB (smaller footprint than HSQLDB).