In this tutorial, we will show you how to install SQLite on Ubuntu 20.04 LTS. For those of you who didn’t know, SQLite is a lightweight command-line database application. It is one of the most efficient database engines in the world. In part, thanks to that made in C Language which makes it very efficient in managing the resources of the system.
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 SQLite on Ubuntu 20.04 (Focal Fossa). You can follow the same instructions for Ubuntu 18.04, 16.04, and any other Debian-based distribution like Linux Mint.
Prerequisites
- A server running one of the following operating systems: Ubuntu 20.04, 18.04, 16.04, and any other Debian-based distribution like Linux Mint.
- It’s recommended that you use a fresh OS install to prevent any potential issues.
- A
non-root sudo useror access to theroot user. We recommend acting as anon-root sudo user, however, as you can harm your system if you’re not careful when acting as the root.
Install SQLite on Ubuntu 20.04 LTS Focal Fossa
Step 1. First, make sure that all your system packages are up-to-date by running the following apt commands in the terminal.
sudo apt update sudo apt upgrade
Step 2. Installing SQLite on Ubuntu 20.04.
Run the following command to install SQLite on the Ubuntu system:
sudo apt install sqlite3
Check the installed version by running the following command:
sqlite3 --version
Install SQLite browser in Ubuntu 20.04 LTS Focal Fossa
Step 1. Before installing the SQLite browser, it is recommended that you update the apt repository on your system using the following command:
sudo apt update
Step 2. Installing SQLite browser on Ubuntu.
Run the following command to install the SQLite browser:
sudo apt install sqlitebrowser
Once the installation is successfully, Launch the SQLite browser by accessing the application launcher and typing the term “SQLite browser” into the search bar.
Congratulations! You have successfully installed SQLite. Thanks for using this tutorial for installing SQLite on Ubuntu 20.04 LTS Focal Fossa system. For additional help or useful information, we recommend you check the official SQLite website.
