Atlantic.Net Blog

How to Install and Use SQLite on Fedora

SQLite is a free, open-source, lightweight database engine written in C. It is a library for implementing a small, fast, self-contained, high-reliability, full-featured SQL database engine. Compared to other databases, SQLite engine is not a standalone process, and you will need to link it statically or dynamically as per your requirement.

In this post, we will show you how to install SQLite from a source on Fedora.


  • A server running Fedora 34 on the Atlantic.Net Cloud Platform
  • A root password is configured on your server

Step 1 – Create Atlantic.Net Cloud Server

First, log in to your Atlantic.Net Cloud Server. Create a new server, choosing Fedora 34 as the operating system with at least 2GB RAM. Connect to your Cloud Server via SSH and log in using the credentials highlighted at the top of the page.

Once logged in to your server, run the following command to update your base system with the latest available packages.

dnf update -y

Step 2 – Remove SQLite Default Installation

By default, SQLite is already installed on the Fedora server. However, the installed SQLite version is an outdated version, so removing the SQLite and installing it again from the source is better.

First, verify the SQLite installed version with the following command.

sqlite3 --version


3.34.1 2021-01-20 14:10:07 10e20c0b43500cfb9bbc0eaa061c57514f715d87238f4d835880cd846b9ealt1

Next, remove the SQLite package using the following command.

dnf remove sqlite

Step 3 – Install SQLite from the Source

First, install all the required packages needed to compile SQLite.

dnf -y groupinstall "Development Tools"

Next, download the latest version of SQLite from their official website.


Next, extract the downloaded file using the following command.

tar -xvzf sqlite-autoconf-3410200.tar.gz

Next, navigate to the extracted directory and configure it with the following command.

cd sqlite-autoconf-3410200


checking for zlib.h... yes
checking for library containing deflate... -lz
checking for library containing system... none required
checking that generated files are newer than configure... done
configure: creating ./config.status
config.status: creating Makefile
config.status: creating sqlite3.pc
config.status: executing depfiles commands
config.status: executing libtool commands

Next, run the following command to compile and install SQLite to your server.

make install


 /usr/bin/mkdir -p '/usr/local/bin'
  /bin/sh ./libtool   --mode=install /usr/bin/install -c sqlite3 '/usr/local/bin'
libtool: install: /usr/bin/install -c sqlite3 /usr/local/bin/sqlite3
 /usr/bin/mkdir -p '/usr/local/include'
 /usr/bin/install -c -m 644 sqlite3.h sqlite3ext.h '/usr/local/include'
 /usr/bin/mkdir -p '/usr/local/share/man/man1'
 /usr/bin/install -c -m 644 sqlite3.1 '/usr/local/share/man/man1'
 /usr/bin/mkdir -p '/usr/local/lib/pkgconfig'
 /usr/bin/install -c -m 644 sqlite3.pc '/usr/local/lib/pkgconfig'
make[1]: Leaving directory '/root/sqlite-autoconf-3410200'

Next, create a symbolic link of SQLite binary.

ln -s /usr/local/bin/sqlite3 /usr/bin/

Then, verify the SQLite version with the following command.

sqlite3 --version


3.41.2 2023-03-22 11:56:21 0d1fc92f94cb6b76bffe3ec34d69cffde2924203304e8ffc4155597af0c191da

Step 4 – Create a Database and Table in SQLite

First, create a new database using the following command.

sqlite3 mydb.db


SQLite version 3.41.2 2023-03-22 11:56:21
Enter ".help" for usage hints.

Next, exit from the SQLite shell with the following command.


Next, change the database to mydb.db database and create a table named students using the following command.

sqlite3 mydb.db
CREATE TABLE students (id INTEGER PRIMARY KEY, name TEXT, position TEXT);

Next, insert some rows in the created table.

INSERT INTO students (name, position) VALUES ('Hitesh Jethva', '12th');
INSERT INTO students (name, position) VALUES ('Jay Jethva', '10th');
INSERT INTO students (name, position) VALUES ('Vyom Jethva', '5th');

You can now verify the inserted data using the following command.

SELECT * FROM students;

You will see all your data in the following output.

1|Hitesh Jethva|12th
2|Jay Jethva|10th
3|Vyom Jethva|5th


In this post, we showed you how to install SQLite from the source on Fedora. We also explained how to create a database and table in SQLite. You can now try SQLite on VPS hosting from Atlantic.Net!


Get started with 12 months of free cloud VPS hosting

Free Tier includes:
G3.2GB Cloud VPS Server Free to Use for One Year
50 GB of Block Storage Free to Use for One Year
50 GB of Snapshots Free to Use for One Year