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.

Step 1 – 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 2 – 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.

wget https://www.sqlite.org/2023/sqlite-autoconf-3410200.tar.gz

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 3 – 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!