How To Install hsqldb on CentOS 7

In this tutorial we learn how to install hsqldb on CentOS 7. hsqldb is HyperSQL Database Engine

Introduction

In this tutorial we learn how to install hsqldb on CentOS 7.

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 CentOS 7. In this tutorial we discuss both methods but you only need to choose one of method to install hsqldb.

Install hsqldb on CentOS 7 Using yum

Update yum database with yum using the following command.

sudo yum makecache

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

sudo yum -y install hsqldb

Install hsqldb on CentOS 7 Using dnf

If you don’t have dnf installed you can install DNF on CentOS 7 first. Update yum database with dnf using the following command.

sudo dnf makecache

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

sudo dnf -y install hsqldb

How To Uninstall hsqldb on CentOS 7

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

sudo dnf remove hsqldb

References

Summary

In this tutorial we learn how to install hsqldb on CentOS 7 using yum and dnf.