ALTIBASE vs HSQLDB

ALTIBASE is a relational database engine that combines in-memory and on-disk storage. It can run entirely in memory, entirely on disk, or in a hybrid mode, with features for both OLTP and OLAP workloads. Built-in replication supports synchronous or asynchronous consistency and Active-Active or Active-Standby architectures. Listed interfaces include ODBC, JDBC, .NET and Entity Framework, OLEDB, Embedded SQL, CLI, Perl DBD, and PHP. ALTIBASE V7.3 lists migration support for Oracle, PostgreSQL, MySQL, SQL Server, Tibero, and CUBRID, along with DBeaver compatibility through plugins. Its listed utilities cover querying, replication management, profiling, monitoring, migration, exporting, and loading data. Security capabilities include SSL/TLS communication, SQL auditing, password policies, IP access control, object privileges, and methods to integrate third-party encryption. The Linux, self-hosted product offers a free A+ Edition for development, testing, and education; it is not for commercial use and is limited to 128 concurrent users, 10 GB in-memory, and 50 GB disk database. Enterprise subscription pricing is available on request.

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.