HSQLDB vs MySQL
HSQLDB
hsqldb.org
MySQL
mysql.comSide by side
| Figure | HSQLDB | MySQL |
|---|---|---|
| Price from | $8.33/mo | Free |
| Free plan | Yes | Yes |
| Free trial | — | Yes |
| Open source | Yes | — |
| Windows | Yes | Yes |
| macOS | Yes | Yes |
| Linux | Yes | Yes |
| API | Yes | Yes |
| Self-hosted | Yes | Yes |
| Plans published | 11 | 18 |
| Spec score · Sql Databases | 9.2 (#1) | 8.9 (#2) |
| Spec score · Relational Databases | 9.1 (#2) | 8.9 (#4) |
| Spec score · Database Software | 8.9 (#13) | 9.5 (#1) |
| Backup | The engine supports fast startup and shutdown with incremental backup plus online and offline backups and SQL-script dumps. | MySQL Enterprise Backup supports online hot backups, full, incremental and partial backups, point-in-time recovery and compression. |
| Developer tooling | The distribution includes SQLTool command-line administration, two GUI database managers, a transfer utility and a test/script utility. | MySQL provides ODBC, JDBC and .NET connectors plus MySQL Workbench for visual modeling, SQL development and administration. |
| Free plan | Yes | Yes |
| Support | Support options include a help forum, a user mailing list, bug and feature request trackers, paid SupportWare, and professional commercial support. | MySQL Enterprise technical support provides 24x7 direct access to MySQL support engineers. |
| Transactions | The engine supports lock-based and MVCC transaction models and is fully multithreaded. | MySQL is transaction-safe and ACID compliant with commit, rollback, crash recovery and row-level locking. |
Plans
HSQLDB
- Developer subscription$100 a year
- Basic Corporate subscriptionPrice not published
- Premier Corporate subscription$2,500 a year
- HSQLDBFree
- HSQLDB softwareFree
- Developer SupportWare$100 a year
- SupportWare Developer subscription$100 a year
- Basic Corporate SupportWare$500 a year
- SupportWare Basic Corporate subscription$500 a year
- Premier Corporate SupportWare$2,500 a year
MySQL
- Community EditionPrice not published
- Community EditionPriced on request
- Standard EditionPriced on request
- Standard EditionPrice not published
- Enterprise EditionPriced on request
- Enterprise EditionPrice not published
- Cluster Carrier Grade EditionPriced on request
- Cluster Carrier Grade EditionPrice not published
- MySQL Cluster Carrier Grade EditionPriced on request
- MySQL Enterprise EditionPriced on request
In their own words
HSQLDB
HSQLDB is a Java-based relational database engine for embedded or server use, with both in-memory and disk-based tables. It supports SQL:2023 core features and many optional features, plus lock-based and MVCC transaction models; the engine is fully multithreaded. Listed capabilities include JSON constructor functions, CSV loading and unloading, temporal system-versioned tables, row-level access control, and log-based replica synchronization. It includes a command-line SQL tool and simple GUI query tools. The latest official release listed is version 2.7.4, compatible with JDK 8 and above, and packages include Java 11 module jars as well as Java 8 jars for HSQLDB and SQL Tool. HSQLDB is self-hosted, with high availability, read replicas, and JSON data support listed. Its default combined limit for CACHED tables is 8TB, extendable to 256TB with a connection property; each TEXT table is limited to 256GB, and memory tables depend on available memory. The software is free to use in commercial products when license terms are met; its licenses are based on the new BSD License. The HSQLDB plan is free. A Developer subscription is $100 a year; Premier Corporate is $2,500 a year at the base level. Support options include community channels and paid commercial support.