Categories: Ubuntu

How to install SQLite 3 in Ubuntu 22.04

SQLite is a C language library that comprises a lightweight and free-to-use Relational Database Management System or RDMS. It is also called a “client-server” database engine. Almost all of the programming languages are developed with the functionality to support SQLite, and it can be embedded with the “.sqlite3/.sqlite/.DB” extension. Also, SQLite is primarily utilized for handling client-side or local storage.

This write-up will discuss the procedure to install SQLite 3 in Ubuntu 22.04. So, let’s start!

How to install SQLite 3 in Ubuntu 22.04

You must follow the below-given step-by-step instructions for installing SQLite 3 in Ubuntu 22.04.

Sponsored

Step 1: Update system repositories
Press “CTRL+ALT+T” to open the terminal of your Ubuntu 22.04 and run the below-given commands to update system repositories:

$ sudo apt update

$ sudo apt upgrade

Step 2: SQLite 3 installation
After updating the system repositories, execute the following command for the installation of SQLite3 in Ubuntu 22.04:

$ sudo apt install sqlite3

The given error-free output indicates that SQLite3 is successfully installed in Ubuntu 22.04 system:

Step 3: Validate the SQLite installation
Lastly, validate the version of the installed software by executing the “sqlite” command with the “–version” option:

$ sqlite3 –version

As you can see, now we have SQLite version “3.37.2” is installed in our Ubuntu 22.04 system:

Now, let’s check out the method of installing SQLite Browser in Ubuntu 22.04.

How to install SQLite Browser in Ubuntu 22.04

For the installation of SQLite browser, follow the below-given procedure.

Step 1: Update system repositories
Press “CTRL+ALT+T” to open the terminal of your Ubuntu 22.04 and run the below-given commands to update system repositories:

$ sudo apt update

Sponsored
$ sudo apt upgrade

Step 2: SQLite Browser installation
Now, execute the following command for the installation of SQLite browser in Ubuntu 22.04:

$ sudo apt install sqlitebrowser

Wait for a few minutes as the installation of the SQLite browser will take some time to complete:

Step 3: Open SQLite Browser
To open the recently installed SQLite Browser in Ubuntu 22.04, search for the “SQLite browser” in the “Activities” menu:

The main interface of the SQLite browser will somehow look like this. You can further explore it according to your requirements:

How to uninstall SQLite browser from Ubuntu 22.04

Want to uninstall SQLite browser from your system? If yes, then utilize the below-given command in your Linux terminal:

$ sudo apt –purge remove sqlitebrowser

We have compiled the simplest method to install SQLite 3 and its browser in Ubuntu 22.04.

Conclusion

For the installation of SQLite 3 in Ubuntu 22.04, first, update the system repositories with the help of the “$ sudo apt update” command and execute the “$ sudo apt install sqlite3” command. You can also install SQLite browser on your Linux-based system by utilizing the “$ sudo apt install sqlitebrowser” command. This write-up discussed the method of installing SQLite 3 in Ubuntu 22.04.

Ubuntu Server Admin

Recent Posts

Building RAG with enterprise open source AI infrastructure

One of the most critical gaps in traditional Large Language Models (LLMs) is that they…

17 hours ago

Life at Canonical: Victoria Antipova’s perspective as a new joiner in Product Marketing

Canonical is continuously hiring new talent. Being a remote- first company, Canonical’s new joiners receive…

2 days ago

What is patching automation?

What is patching automation? With increasing numbers of vulnerabilities, there is a growing risk of…

3 days ago

A beginner’s tutorial for your first Machine Learning project using Charmed Kubeflow

Wouldn’t it be wonderful to wake up one day with a desire to explore AI…

4 days ago

Ubuntu brings comprehensive support to Azure Cobalt 100 VMs

Ubuntu and Ubuntu Pro supports Microsoft’s Azure Cobalt 100 Virtual Machines (VMs), powered by their…

4 days ago

Ubuntu Weekly Newsletter Issue 870

Welcome to the Ubuntu Weekly Newsletter, Issue 870 for the week of December 8 –…

4 days ago