How to install SQLite 3 in Ubuntu 20.04 and Linux Mint 20

28/12/2020

SQLite is a free, lightweight, and command-line database application. It is an efficient database engine that is implemented in C. It is a cross-platform database application. Like SQL and MySQL, SQLite is also a relational database. It is widely used in combination with Android and web applications. SQLite is leveraged with an SQLite browser. SQLite Browse is a graphical and free software platform for developing and designing, SQLite databases. In this post, you will get to know the installation procedure of SQLite 3 and SQLite Browser on Linux Mint 20 Ubuntu 20.04.

Installing SQLite 3 in Ubuntu 20.04 and Linux Mint 20

To install SQLite 3 on Ubuntu 20.04 and Linux Mint 20, perform the following steps:

Step 1: Update apt repository cache

Before installing any application or package, it is recommended to update the system apt repository cache using the following command:

$ sudo apt update

Step 2: Update apt-cache

Next, upgrade the apt repository cache using the following command:

$ sudo apt upgrade

Step 3: Install SQLite 3

Alright! Now we are ready to install SQLite 3 on Ubuntu 20.04 and Linux 20. SQLite is available through Ubuntu 20.04 and Linux Mint 20 repositories. Install SQLite 3 using the following command:

$ sudo apt install sqlite3

Step 4: Verify the installation

After installing SQLite 3, we can view the installed version of SQLite 3. Additionally, it also verifies the installation. Run the below-given command to do so:

$ sqlite3 –version

Installing SQLite browser in Ubuntu 20.04 and Linux Mint 20

The SQLite browser can be installed in Ubuntu 20.04 and Linux Mint 20 through the below-given steps:

Step 1: Update apt repository cache

Before installing the SQLite browser, update the system’s apt repository cache with the following command:

$ sudo apt update

Step 2: Install SQLite browser on your Ubuntu 20.04 and Linux Mint 20

The SQLite browser can be installed by executing the following command:

$ sudo apt install sqlitebrowser

The command line will display a prompt. You are supposed to press “y” to continue the installation process. However, if you want to cancel the installation process then press ‘n’ and hit enter.

Step 3: Launch SQLite browser

After the successful installation, click on the application menu and search for SQLite browser and open it.

It is the main window of SQLite bowser.

Removing SQLite 3 from Ubuntu 20.04 and Linux Mint 20

At any point, if you want to remove or uninstall the SQLite 3 from your system, run the following command to do so:

$ sudo apt –purge remove sqlitebrowser

Conclusion

SQLite 3 is a free and efficient database engine. This article explains how to install SQLite 3 on Ubuntu 20.04 and Linux Mint 20.

ONET IDC thành lập vào năm 2012, là công ty chuyên nghiệp tại Việt Nam trong lĩnh vực cung cấp dịch vụ Hosting, VPS, máy chủ vật lý, dịch vụ Firewall Anti DDoS, SSL… Với 10 năm xây dựng và phát triển, ứng dụng nhiều công nghệ hiện đại, ONET IDC đã giúp hàng ngàn khách hàng tin tưởng lựa chọn, mang lại sự ổn định tuyệt đối cho website của khách hàng để thúc đẩy việc kinh doanh đạt được hiệu quả và thành công.
Bài viết liên quan

Connect to Office 365, Hotmail, MS Exchange with Hiri eMail Client

Hiri email client is an attractive mail app that integrates seamlessly not only with Microsoft Exchange servers, but also...
28/12/2020

Best 10 Video Players for Linux

Many of us love to watch movies, music, TV series, etc. to take short break from daily routine work. Apart from that multimedia...
29/12/2020

[CEPH] [LAB] Hướng dẫn cài đặt CEPH chỉ định minor version trên CentOS 7

Như mọi người đã biết, tên các phiên bản của Ceph bao gồm 3 số, ngăn cách nhau bởi dấu chấm...
30/12/2020