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.
Plans
Every plan and priceDeveloper subscription
Basic Corporate subscription
Premier Corporate subscription
HSQLDB
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.