How To Install hsqldb on Fedora 34

hsqldb is HyperSQL Database Engine

Introduction

In this tutorial we learn how to install hsqldb on Fedora 34.

What is hsqldb

HSQLdb is a relational database engine written in JavaTM , with a JDBC driver, supporting a subset of ANSI-92 SQL. It offers a small (about 100k), fast database engine which offers both in memory and disk based tables. Embedded and server modes are available. Additionally, it includes tools such as a minimal web server, in-memory query and management tools (can be run as applets or servlets, too) and a number of demonstration examples. Downloaded code should be regarded as being of production quality. The product is currently being used as a database and persistence engine in many Open Source Software projects and even in commercial projects and products! In it’s current version it is extremely stable and reliable. It is best known for its small size, ability to execute completely in memory and its speed. Yet it is a completely functional relational database management system that is completely free under the Modified BSD License. Yes, that’s right, completely free of cost or restrictions!

We can use yum or dnf to install hsqldb on Fedora 34. In this tutorial we discuss both methods but you only need to choose one of method to install hsqldb.

Install hsqldb on Fedora 34 Using dnf

Update yum database with dnf using the following command.

sudo dnf makecache --refresh

The output should look something like this:

Fedora 34 - x86_64                               20 kB/s | 6.6 kB     00:00
Fedora 34 openh264 (From Cisco) - x86_64        1.4 kB/s | 989  B     00:00
Fedora Modular 34 - x86_64                       68 kB/s | 6.5 kB     00:00
Fedora 34 - x86_64 - Updates                    3.5 kB/s | 6.2 kB     00:01
Fedora Modular 34 - x86_64 - Updates             17 kB/s | 5.9 kB     00:00
Metadata cache created.

After updating yum database, We can install hsqldb using dnf by running the following command:

sudo dnf -y install hsqldb

Install hsqldb on Fedora 34 Using yum

Update yum database with yum using the following command.

sudo yum makecache --refresh

The output should look something like this:

Fedora 34 - x86_64                               20 kB/s | 6.6 kB     00:00
Fedora 34 openh264 (From Cisco) - x86_64        1.4 kB/s | 989  B     00:00
Fedora Modular 34 - x86_64                       68 kB/s | 6.5 kB     00:00
Fedora 34 - x86_64 - Updates                    3.5 kB/s | 6.2 kB     00:01
Fedora Modular 34 - x86_64 - Updates             17 kB/s | 5.9 kB     00:00
Metadata cache created.

After updating yum database, We can install hsqldb using yum by running the following command:

sudo yum -y install hsqldb

How To Uninstall hsqldb on Fedora 34

To uninstall only the hsqldb package we can use the following command:

sudo dnf remove hsqldb

hsqldb Package Contents on Fedora 34

/etc/sysconfig/hsqldb
/usr/lib/hsqldb
/usr/lib/hsqldb/hsqldb-post
/usr/lib/hsqldb/hsqldb-stop
/usr/lib/hsqldb/hsqldb-wrapper
/usr/lib/systemd/system/hsqldb.service
/var/lib/hsqldb
/var/lib/hsqldb/data
/var/lib/hsqldb/lib
/var/lib/hsqldb/lib/hsqldb.jar
/var/lib/hsqldb/lib/servlet.jar
/var/lib/hsqldb/server.properties
/var/lib/hsqldb/sqltool.rc
/var/lib/hsqldb/webserver.properties

References

Summary

In this tutorial we learn how to install hsqldb on Fedora 34 using yum and dnf.