SQLite is an extremely lightweight and widely used SQL database engine. It is an efficient database engine that is implemented in C. This tool is quite useful for managing databases because it has the ability to interface with many different programming languages. Most Linux distributions can install SQLite3 from their repositories. However, there are repository versions that might be outdated or miss newer features in the latest SQLite3.
So in this tutorial, I will show how to install SQLite3 from the official source code. After the installation of SQLite, I will show how to create a simple database, then how to read data from it, insert items and delete items.
Requirements
Installed Ubuntu 20.04 operating system.
Installation
Before installing SQLite3 database management system, you need to update your server and install build-essential package:

After that, you can start configuring SQLite3.
1. SQLite3 packet download
Firstly, you need to download SQLite3 packet. The newest version you can find here. You will need to copy the .tar.gz file link from the Source Code. Then write that in the command and write which version you will install:

2. SQLite3 installation and configuration

After that, you can check the installed version with this command:
sqlite3 --version
Also, SQLite can be installed and with these commands:

Working with SQLite3
1. The database creation
The database can be created with the command sqlite3. So now we will create the database with a name - vpshosting:
sqlite3 vpshosting.db
However, if you have already created a file vpshosting.db, SQLite will open a connection to it then, but if not, SQLite will create a file vpshosting.db
After the database creation, you will receive an output:

2. the table creation of the SQLite database
SQLite databases are organized into tables and those tables store the information.
Now we will create a table and some columns with various data:
The plan number
The server's name
The server's type
The server's price per month.
So the command should look like this:
CREATE TABLE vpshosting(number integer NOT NULL, name text NOT NULL, vpshostingtype text NOT NULL, price integer NOT NULL);
Using NOT NULL makes that field required.
After creating a table, an empty prompt will return. So with down below provided command, we can add some values:
INSERT INTO tablename VALUES(values go here);
The example:
INSERT INTO vpshosting VALUES (2, "Linux", "KVM", 3.99);
INSERT INTO vpshosting VALUES (2, "Container", "OpenVZ", 2.99);
INSERT INTO vpshosting VALUES (2, "Windows", "KVM", 3.99);
To view a table, you can use this command:
SELECT * FROM vpshosting;
The output should look like this:
sqlite> SELECT * FROM vpshosting;
2| Linux | KVM | 3.99
2| Container | OpenVZ | 2.99
2| Windows | KVM | 3.99
sqlite>
To view an entry based on its price (the values we set manually), add the WHERE command to your query:
SELECT * FROM vpshosting WHERE price IS 2.99;
sqlite> SELECT * FROM vpshosting WHERE price IS 2.99;
2|COntainer|OpenVZ|2.99
sqlite>
3. Updating tables
ALTER TABLE allows creating a new column. WIth down below provided command, we will add the information about CPUcores.
ALTER TABLE vpshosting ADD COLUMN CPU integer;
With UPDATE command, we will be able to update the newly created column:
UPDATE vpshosting SET CPU= 1 WHERE number=2;
UPDATE vpshosting SET CPU= 1 WHERE number=2;
UPDATE vpshosting SET CPU= 1 WHERE number=2;
sqlite> SELECT * FROM vpshosting;
2| Linux | KVM |3.99 | 1
2| Container | OpenVZ | 2.99 | 1
2| Windows | KVM | 3.99 | 1
sqlite>
4. Deleting tables:
With DELETE command you will be able to delete tables
DELETE FROM vpshosting WHERE price <= 3.00;
The command will delete all servers from the vpshosting table whose price is less than 3.00.
2| Windows | KVM | 3.99 | 1
sqlite>
More information regarding SQLite’s syntax, you can find on the official documentation of SQLite.