How To Install SQLite on Fedora 39

In this tutorial, we will show you how to install SQLite on Fedora 39. SQLite is a renowned database management system favored for its simplicity, reliability, and ease of use. It operates with a serverless architecture, making it an ideal choice for a wide range of applications, from small local databases to large-scale mobile and web applications.

This article assumes you have at least basic knowledge of Linux, know how to use the shell, and most importantly, you host your site on your own VPS. The installation is quite simple and assumes you are running in the root account, if not you may need to add ‘sudo‘ to the commands to get root privileges. I will show you the step-by-step installation of the SQLite database on a Fedora 39.

Prerequisites

Before diving into the installation process, let’s ensure that you have everything you need:

• A server running one of the following operating systems: Fedora 39.
• It’s recommended that you use a fresh OS install to prevent any potential issues.
• You will need access to the terminal to execute commands. Fedora 39 provides the Terminal application for this purpose. It can be found in your Applications menu.
• A network connection or internet access to download the SQLite repository.
• A non-root sudo user or access to the root user. We recommend acting as a non-root sudo user, however, as you can harm your system if you’re not careful when acting as the root.

Install SQLite on Fedora 39

Step 1. Before proceeding with the installation, ensure that your Fedora 39 system is up-to-date to avoid any conflicts with existing packages. You can update your system using the following command:

sudo dnf clean all
sudo dnf update

Check for any existing SQLite installations to prevent version conflicts:

sqlite3 --version

If SQLite is already installed and you wish to update or reinstall it, you can proceed with the installation steps. Additionally, ensure you have root or sudo privileges to install new software packages.

Step 2. Installing SQLite on Fedora 39.

• Using Fedora’s DNF Package Manager

The simplest and most straightforward method to install SQLite on Fedora is through the DNF package manager. To install SQLite, execute the following command:

sudo dnf install sqlite

After the installation is complete, verify it by checking the SQLite version:

sqlite3 --version

• Manual Installation from Source

For those who need a specific version of SQLite or prefer to compile from source, follow these steps:

wget https://www.sqlite.org/2024/sqlite-autoconf-3450100.tar.gz

Extract the archive and navigate to the directory:

tar xvfz sqlite-autoconf-3450100.tar.gz
cd sqlite-autoconf-3450100

Compile and install SQLite:

./configure
make
sudo make install

Once SQLite is installed, you can start using it by entering the SQLite command console:

sqlite3

Inside the console, you can create a new database or connect to an existing one by simply typing:

sqlite3 mydatabase.db

Here are some basic SQLite commands to get you started:

• .help – Displays help information.
• .databases – Lists all databases.
• .tables – Shows all tables in the current database.
• .schema – Displays the schema of a table.
• .exit – Exits the SQLite console.

You can also perform SQL operations such as inserting, updating, and querying data within the SQLite console.

Congratulations! You have successfully installed SQLite. Thanks for using this tutorial for installing the SQLite database on your Fedora 39 system. For additional or useful information, we recommend you check the official SQLite website.