HSQLDB vs TiDB Cloud
HSQLDB
hsqldb.org
TiDB Cloud
pingcap.comSide by side
| Figure | HSQLDB | TiDB Cloud |
|---|---|---|
| Price from | $8.33/mo | Free |
| Free plan | Yes | Yes |
| Free trial | — | — |
| Open source | Yes | Yes |
| Web | — | Yes |
| Windows | Yes | — |
| macOS | Yes | — |
| Linux | Yes | Yes |
| API | Yes | Yes |
| Self-hosted | Yes | Yes |
| Plans published | 11 | 13 |
| Spec score · Sql Databases | 9.2 (#1) | 8.5 (#8) |
| Spec score · Database Software | 8.9 (#13) | 9.2 (#5) |
| Founded | 2001 | 2015 |
| Free plan | Yes | Yes |
| Integrations | The project documents JDBC and ODBC connectivity and integration with OpenOffice.org and LibreOffice. | Official integrations include Kubernetes via TiDB Operator, Prometheus, Grafana, Datadog, New Relic, Kafka, Flink, Confluent, Airbyte, Amazon AppFlow and dbt. |
| Product | HSQLDB is a Java-based relational database engine with in-memory and disk-based tables, supporting embedded and server modes. | TiDB Cloud is a fully managed cloud database service built around an open-source distributed SQL database with MySQL compatibility. |
| Rating on G2 | 4.0 out of 5 from 22 reviews. | 4.6 out of 5 from 66 reviews |
| Security controls | Security features include passwords, users, roles, GRANT/REVOKE privileges and fine-grained row-level access control. | Security features include SSO, MFA, fine-grained IAM, private endpoints, VPC peering, IP access lists, TLS, CMEK options and console/database audit logs. |
| Support | Support options include a help forum, a user mailing list, bug and feature request trackers, paid SupportWare, and professional commercial support. | Support is provided through the Help Center, email, chat and video conferencing; Basic users use community Slack or Discord for technical questions. |
| What it does | HSQLDB (HyperSQL) is a Java relational database engine supporting transactional in-memory and disk tables in embedded or server deployments. | TiDB Cloud is a fully managed distributed SQL database service for transactional, analytical, vector-search and AI workloads. |
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
TiDB Cloud
- TiDB Cloud StarterFree
- TiDB Cloud EssentialPrice not published
- TiDB Cloud Premium$1,800 a month
- TiDB Cloud Dedicated$0.22 a month
- StarterFree
- TiDB Cloud StarterFree
- Essential$400 a month
- Dedicated$1,376 a month
- Premium$1,800 a month
- TiDB Cloud Premium Preview$1,800 a month
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.
TiDB Cloud
TiDB Cloud is a managed cloud database service built around an open-source distributed SQL database with MySQL compatibility. It supports transactional and analytical workloads, horizontal scaling, multi-region deployment, and geo-partitioning across Starter, Essential, Premium, and Dedicated plans. Starter includes up to 25 GiB of row storage, 25 GiB of column storage, and 250 million Request Units per month per organization, for up to the first five instances. Its on-demand compute scales to zero when idle, and vector storage and search are in public preview. CSV, Parquet, and SQL file imports are supported across the listed plans. Email and password login, SSO options, private and public endpoints, and console audit logging are listed across all four plans. Prometheus, Grafana, and Datadog integrations are listed for Essential, Premium, and Dedicated in public preview. All users can submit billing and account support tickets; guaranteed technical-ticket response times require paid support plans. The service is available through web and API platforms. Starter is free; the Dedicated plan is listed as starting at $0.22 a month and from $1376 / month.