How to Install SQLite on CentOS 8 (Legacy Guide)

This guide preserves the package-based SQLite installation steps for an existing CentOS Linux 8 system.

Legacy system: CentOS Linux 8 reached end of life on December 31, 2021, and the CentOS Project no longer publishes updates for it. Do not use it for a new deployment; use a maintained Enterprise Linux release such as Rocky Linux 9 instead. See the CentOS Project lifecycle information.

Prerequisites

Before you begin the installation, make sure you have the following:

CentOS 8: Ensure you have a working CentOS 8 installation.
Terminal: Access to the terminal or command line interface with root or sudo privileges.

Now that you have the prerequisites in place, let’s proceed with the installation.

Step 1: Refresh package metadata

Refresh the package manager’s metadata so it can find the SQLite package:

sudo dnf makecache

This refreshes package metadata; it does not upgrade installed packages.

Step 2: Install SQLite

SQLite is available in the CentOS package repository. You can easily install it using the dnf package manager. To do this, run the following command:

sudo dnf install sqlite

The system will prompt you to confirm the installation. Type ‘y’ and press Enter to proceed.

Step 3: Verify the Installation

To verify that SQLite has been successfully installed, you can check the version of SQLite by running the following command:

sqlite3 --version

You should see the installed SQLite version in the output.

Step 4: Start Using SQLite

With SQLite installed, you can start using it right away. To open an interactive SQLite prompt, simply type:

sqlite3

This will open a new SQLite shell where you can execute SQL commands and manage your databases.

Conclusion

You’ve successfully installed SQLite on your CentOS 8 system. You can now use SQLite to create, manage, and query databases for your applications. This lightweight database management system is highly versatile and can be used for a wide range of projects. If you’re new to SQLite, be sure to explore its documentation and tutorials to harness the full power of this powerful database system.

Happy coding!