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:

• Full support for SQL:2008 core features and around 150 optional features
• Support for Unicode strings, and all common SQL types, and column defaults
• Advanced SQL features including subqueries, OUTER joins, UNION, INTERSECT, GROUP BY, HAVING, IN, EXISTS
• Extensive list of built-in SQL functions including CASE WHEN and COALESCE
• Support for foreign keys with ON DELETE/UPDATE CASCADE/SET NULL etc.
• Extensive JDBC metadata support plus additional system tables for metadata
• JDBC scrollable result sets, prepared statements, batch statements, clob and blob
• 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).