HSQLDB is known for its small size, ability to execute completely or partly in memory, its flexibility and speed. The Lucee core needs a HSQLDB jar to run the CFML “query of queries” (QoQ) feature, but the jar itself is not registered as a JDBC source and no component for the admin exists… yet.
Good thing about JDBC sources, you don’t have to install an extension to use it. You can create your own datasource with something simple like this:
HyperSQL (HSQLDB) is a real workhorse; a regular “Little Engine That Could”. It’s one of three core Java databases; including Apache Derby and H2.
Sixteenth anniversary release, 9 April 2017. Version 2.4.0 for Java 8 adds support for java.time classes in JDBC and adds many enhancements. These include table spaces for disk-based tables, more compatibility functions and improved SQL routine support.
http://hsqldb.org/ (changelog http://hsqldb.org/doc/changelist_2_0.txt)
@micstriit has recently added version 2.3.5 and 2.4.0 of the HSQLDB extensions and extended the test case to include all these versions. And rolled the jar out into its own OSGi bundle:
Hypersonic SQL DB Driver. Here you can not only create a database connection to a existing HSQL Database, you can also create a new one. That means, when a Database you define not exist, it will be automatically created.
Coming to a version of Lucee in the near future.