SQLite is a small and independent database system that doesn’t need a separate server. It helps organize and manage data in an easy and open way.
Install and uninstall SQLite 3 on linux ubuntu 22.04; Through this tutorial, we will show you how to install and uninstall SQLite 3 on linux ubuntu 22.04 system using command line or terminal.
Install and Uninstall SQLite3 in Linux Ubuntu 22.04 Command Line
Steps to install and uninstall SQLite 3 in linux ubuntu 22.04 using terminal or command line:
- Step 1 – Update System Dependencies
- Step 2 – Install SQLite 3
- Step 3 – Verify SQLite3 Installation
- Step 4 – Using SQLite 3
- Step 5 – Uninstall SQLite 3 Ubuntu
Step 1 – Update System Dependencies
First of all, open terminal or command line and then execute the following command into it to update system dependencies:
sudo apt update
Step 2 – Install SQLite 3
To install SQLite 3 on Ubuntu, simply use the following command:
sudo apt install sqlite3
Step 3 – Verify SQLite3 Installation
Once the installation is complete, you can verify it by checking the version of SQLite 3 installed:
sqlite3 --version
Step 4 – Using SQLite 3
SQLite 3 doesn’t require a separate server to be set up; it’s a self-contained database system that operates from the command line.
To open an SQLite database or create a new one, use the following command:
sqlite3 your_database_name.db
Replace your_database_name.db with the desired name of your database file.
Once you’re in the SQLite shell, you can start executing SQL commands. For example, to create a table:
CREATE TABLE students (
id INTEGER PRIMARY KEY,
name TEXT,
age INTEGER
);
Step 5 – Uninstall SQLite 3 Ubuntu
If, for any reason, you need to uninstall SQLite 3, you can do so with the following command:
sudo apt remove sqlite3
Conclusion
Through this tutorial, we have shown you how to install and uninstall SQLite 3 on Linux ubuntu 22.04 system using the command line.
