What is HSQLDB?
It offers a small, fast multi-threaded and transactional database engine with in-memory and disk-based tables and supports embedded and server modes. It includes a powerful command line SQL tool and simple GUI query tools.
HSQLDB is a tool in the Databases category of a tech stack.
HSQLDB is an open source tool with 66 GitHub stars and 30 GitHub forks. Here’s a link to HSQLDB's open source repository on GitHub
Who uses HSQLDB?
Companies
7 companies reportedly use HSQLDB in their tech stacks, including Swingvy, picturesafe media/data/bank GmbH, and Sakai.
Developers
54 developers on StackShare have stated that they use HSQLDB.
HSQLDB Integrations
Spring Boot, Slick, Woopra, Cloud 66, and Leftronic are some of the popular tools that integrate with HSQLDB. Here's a list of all 6 tools that integrate with HSQLDB.
HSQLDB's Features
- Original code, based on in-depth study of database theory and the SQL Standard
- Extensive syntax compatibility modes for porting from other database systems
- The fastest overall open-source SQL implementation for small and medium sized databases
- Three transaction control models, including lock based and MVCC models
- Fully multi-threaded
- Compact code footprint
HSQLDB Alternatives & Comparisons
What are some alternatives to HSQLDB?
MySQL
The MySQL software delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software.
SQLite
SQLite is an embedded SQL database engine. Unlike most other SQL databases, SQLite does not have a separate server process. SQLite reads and writes directly to ordinary disk files. A complete SQL database with multiple tables, indices, triggers, and views, is contained in a single disk file.
PostgreSQL
PostgreSQL is an advanced object-relational database management system
that supports an extended subset of the SQL standard, including
transactions, foreign keys, subqueries, triggers, user-defined types
and functions.
Firebird
Firebird is a relational database offering many ANSI SQL standard features that runs on Linux, Windows, MacOS and a variety of Unix platforms. Firebird offers excellent concurrency, high performance, and powerful language support for stored procedures and triggers. It has been used in production systems, under a variety of names, since 1981.
Oracle
Oracle Database is an RDBMS. An RDBMS that implements object-oriented features such as user-defined types, inheritance, and polymorphism is called an object-relational database management system (ORDBMS). Oracle Database has extended the relational model to an object-relational model, making it possible to store complex business models in a relational database.
