SQLite, a renowned database management system, is widely appreciated for its simplicity, reliability, and ease of use. This serverless architecture makes it an ideal choice for applications ranging from small local databases to large-scale mobile and web applications.

What You Will Need

Before we start installing SQLite on your Fedora 39 system, let’s make sure you have everything you need:

1. A server running Fedora 39: It’s recommended to use a fresh OS install to prevent any potential issues.
2. Terminal Access: You will need access to the terminal to execute commands. Fedora 39 provides the Terminal application for this purpose.
3. Internet Connection: To download the SQLite repository.
4. Root User Access: Access to the root user or a non-root sudo user is necessary. It’s recommended to act as a non-root sudo user to prevent harm to your system.

Installation Process

The installation process of SQLite on Fedora 39 is quite straightforward. Here is a step-by-step guide:

Step 1: Update your Fedora 39 System

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 by executing the following commands in the terminal:

sudo dnf clean all
sudo dnf update

Step 2: Check for Existing SQLite Installations

Before installing SQLite, check for any existing installations to prevent version conflicts. Use the command below to check the version of SQLite installed on your system:

sqlite3 --version

If SQLite is already installed and you wish to update or reinstall it, you can proceed with the installation steps.

Step 3: Install SQLite using Fedora’s DNF Package Manager

Now we can proceed to install SQLite. The simplest method to install SQLite on Fedora is through the DNF package manager. Execute the following command in the terminal:

sudo dnf install sqlite

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

sqlite3 --version

Step 4: Manual Installation from Source

Alternatively, if you need a specific version of SQLite or prefer to install from source, follow these steps:

First, download the SQLite source using the command below:

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

Then, extract the archive and navigate to the directory:

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

Finally, compile and install SQLite:

./configure
make
sudo make install

Using SQLite

Once SQLite is installed, you can start using it by entering the SQLite command console. 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.

You have successfully installed SQLite on your Fedora 39 system. If you found this article helpful, feel free to share it with others who might benefit from this information.

For those who don’t have the time or expertise to manage their VPS, Shape.host offers Cloud VPS services starting from $4. With their expert team managing your VPS, you can focus on what you do best and leave the server management to them.

Christian Wells