Install SQLite and SQLite Browser on Ubuntu 18.04/20.04 LTS

SQLite is a lightweight database software. It is a command line application. You must use the command line or SQLite API on other programming languages to use SQLite database. SQLite has a graphical front end SQLite Browser for working with SQLite databases graphically.

SQLite 3 is the latest version at the time of this writing. SQLite 3 is available in the official package repository of Ubuntu 18.04 LTS. SQLite Browser is also available in the official package repository of Ubuntu 18.04 LTS.

In this article, I will show you how to install SQLite 3 and SQLite Browser on Ubuntu 18.04 LTS. I will also show you some of the basic queries of SQLite 3. Let’s get started.

Installing SQLite 3

First update the apt package repository cache with the following command:

$ sudo apt-get update

The apt package repository cache should be updated.

Now to install SQLite 3, run the following command: 

$ sudo apt-get install sqlite3

SQLite 3 should be installed.

Now you can check whether SQLite 3 is 

working with the following command:

$ sqlite3 --version

Installing SQLite Browser

Run the following command to install SQLite Browser:

$ sudo apt-get install sqlitebrowser

Now press y and then press <Enter>.

SQLite Browser should be installed.

Using SQLite using SQLite Browser

Now you can go to the Application Menu and search 

for SQLite Browser. You should see a database icon 

as marked in the screenshot below. Click on it.

 Now I will show you how to insert data into the users table.
First go to the Browse Data tab as marked in the screenshot below.