How to Install SQLite Browser in Ubuntu 22.04

SQLite is a freely available, open-source C library used as the database engine. However, to use SQLite, we have to install the SQLite browser. It is an open-source, high-quality tool used to create, edit and design database files supported by SQLite. SQLite browser can create a database file, modify and delete tables, can import databases as “CSV” files, execute SQL queries and examine the results, and many more.

In this post, we will elaborate on how to install, launch and remove SQLite Browser in Ubuntu 22.04.

SQLite Browser installation on Ubuntu 22.04

In order to install SQLite Browser, follow the below-given instruction carefully.

Step 1: Update and Upgrade system packages

First, press “CTRL+ALT+T” to open the terminal and update and upgrade system packages:

$ sudo apt update && sudo apt upgrade

Let’s move further to install SQLite3.

Step 2: Install SQLite3

Install the SQLite3 library using the provided command:

$ sudo apt install sqlite3

Let’s move to confirm the installation.

Step 3: Check SQLite3 version

Check out the version of SQLite3:

$ sqlite3 --version

The given output indicates that we have successfully installed “SQLite3” version “3.37.2”:

Step 4: Install SQLite Browser

Let’s install SQLite Browser by utilizing the given command:

$ sudo apt install sqlitebrowser

As you can see from the above-given output, we have installed SQLite Browser. Let’s move further to launch it.

How to Launch SQLite Browser in Ubuntu 22.04

To launch SQLite Browser, first search for “sql” in the “Activities” menu and open it:

You can see that we have successfully launched SQL DB Browser on Ubuntu 22.04 and is ready to use:

Let’s check out how to uninstall SQLite Browser from Ubuntu 22.04.

SQLite Browser uninstallation from Ubuntu 22.04

From Ubuntu 22.04, to uninstall SQLite Browser, follow up the below-mentioned command and execute it on the terminal:

$ sudo apt --purge remove sqlitebrowser

The installation, launch, and removal of SQLite from Ubuntu22.04 has been demonstrated.

Conclusion

To use SQLite on Ubuntu 22.04, it is required to install SQLite Browser. To install SQLite Browser on Ubuntu, first, install SQLite3 using the “$ sudo apt install sqlite3” command, then install SQLite Browser through the “$ sudo apt install sqlitebrowser” command on the terminal. In this tutorial, we have effectively explained the method to install, launch and remove SQLite Browser on Ubuntu 22.04.