Menu

How to Install SQLite on CentOS Stream 8 (Legacy Guide)

Legacy guide to installing SQLite on CentOS Stream 8, which stopped receiving builds in May 2024. Use a supported release for new systems.

Posted on By Updated on
On this page

Legacy guide: CentOS Stream 8 ended builds on May 31, 2024. The CentOS Project says the release was archived and no further updates are provided. This page preserves the older SQLite package procedure; repository URLs may need to point to the CentOS archive. Do not use CentOS Stream 8 for a new system. For current instructions, see How to Install SQLite on CentOS Stream 9.

Prerequisites

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

  1. CentOS Stream 8: Ensure you have a working CentOS Stream 8 installation.
  2. 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 Stream 8 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 Stream 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!