Skip to the content
Know your tech before you buy it. Makers: get listed from $49/mo

HSQLDB

By HSQLDB · hsqldb.org

  • Free plan
  • Open source
  • Windows
  • macOS
  • Linux
  • API
  • Self-hosted
8.3 Club score Visit hsqldb.org

What HSQLDB is

HSQLDB is a Java-based relational database engine that supports both in-memory and disk-based tables, in embedded or server mode. It supports SQL:2023 core features and many optional features, with lock-based and MVCC transaction models in a fully multithreaded engine. Listed capabilities include JSON constructor functions, CSV loading and unloading, temporal system-versioned tables, row-level access control, and log-based replica synchronization. Command-line SQL and simple GUI query tools are included. The latest official release listed is version 2.7.4, compatible with JDK 8 and above; release packages include Java 11 module jars and Java 8 jars for HSQLDB and SQL Tool. It is self-hosted, with high availability, read replicas, and JSON data support listed. HSQLDB is free to use in commercial products when license terms are met; the licenses are based on the new BSD License. The Developer subscription costs $100 a year. The Premier Corporate subscription starts at $2,500 a year and includes deployment support and enhancement requests. The default combined CACHED-table size limit is 8TB, extendable to 256TB with a connection property; each TEXT table is limited to 256GB.

Who it suits

HSQLDB may suit developers and organizations seeking a self-hosted Java relational database with embedded and server modes. Its listed integrations include OpenOffice, LibreOffice, Spring, Hibernate, Flyway, Liquibase, DBeaver, and Eclipse.

Good to know, and what to watch

  • Supports in-memory and disk-based tables.
  • Offers lock-based and MVCC transaction models.
  • Includes command-line and GUI query tools.
  • Free commercial use when license terms are met.
  • CACHED table limit can be extended to 256TB.
  • Memory tables are limited by available memory.
  • Each TEXT table is limited to 256GB.
  • Priority support subscriptions start at $100 a year.

Developer subscription

$100/yr

Basic Corporate subscription

—

Premier Corporate subscription

$2,500/yr

HSQLDB

Free

Free plan

The verdict

HSQLDB offers multiple operating modes, SQL tooling, and a broad set of database capabilities for self-hosted use. Review its licensing terms, storage limits, and support options before choosing a subscription.

What the maker publishes

Backup
The engine supports fast startup and shutdown with incremental backup plus online and offline backups and SQL-script dumps. source
Capacity
Official limits include disk tables up to 8 TB, text tables up to 256 GB and individual CLOB/BLOB storage up to 64 TB. source
Concurrency
The engine is multithreaded and offers lock-based, MVCC and hybrid transaction-control models. source
Data storage limit
The FAQ states the default combined size limit for CACHED tables is 8TB, extendable to 256TB with a connection property; TEXT tables are limited to 256GB each. source
Deployment protocols
Embedded and client-server operation are supported through HSQL, HTTP and HSQL-BER protocols, each with an SSL option. source
Developer tooling
The distribution includes SQLTool command-line administration, two GUI database managers, a transfer utility and a test/script utility. source
Developer tools
The product includes a command-line SQL tool and simple GUI query tools. source
Distribution
The release package includes Java 11 module jars and Java 8 jars for HSQLDB and SQL Tool. source
Documentation depth
The project publishes HTML, PDF and text guides, JavaDoc for public classes, utilities documentation, examples, tests and SQL scripts. source
Extensibility
Applications can define Java stored procedures, Java or SQL triggers, aggregate functions and routines with INOUT parameters and multiple result sets. source
Founded
2001 source
Free plan
Yes source
Installation requirement
Installation consists of downloading and unpacking hsqldb.zip and requires a Java Runtime Environment or JDK. source
Integrations
The maker lists use with OpenOffice and LibreOffice, and names projects and tools including Spring, Hibernate, Flyway, Liquibase, DBeaver, and Eclipse. source
Integrations
The project documents JDBC and ODBC connectivity and integration with OpenOffice.org and LibreOffice. source
Java compatibility
The latest official release listed is version 2.7.4, which works with JDK 8 and above. source
Java support
HSQLDB is written entirely in Java; the standard jar targets Java 11+ while an alternative jar supports Java 8+. source
JDBC API
It provides extensive JDBC support including batch statements, scrollable and updatable ResultSets, metadata, CallableStatement and PreparedStatement. source
Latest release
The official latest release is version 2.7.4, dated 25 October 2024. source
License
HSQLDB is free to use in commercial products when the license terms are met; the licenses are based on the new BSD License. source
License
HSQLDB source and binaries use permissive BSD-based licenses, with separate terms for legacy Hypersonic SQL code. source
Limit: Capterra scale
One Capterra reviewer says the embedded database is not suitable for a large project, and another notes it is unsupported in newer SAP Commerce Cloud versions. source
Limit: SourceForge debugging
A critical SourceForge review complained that older error messages did not identify the failing table or column, making debugging laborious. source
Limit: SourceForge DSV handling
A reviewer reported that an older SqlTool DSV export failed to escape quotes and line breaks, preventing reliable re-import of multiline data. source

Checked against the maker's pages on 15 Oct 2026.