How To Install sqlitebrowser on Ubuntu 18.04
Introduction
In this tutorial we learn how to install sqlitebrowser on Ubuntu 18.04.
What is sqlitebrowser
sqlitebrowser is:
SQLite Database Browser is a visual tool used to create, design and edit database files compatible with SQLite. Its interface is based on QT, and is meant to be used for users and developers that want to create databases, edit and search data using a familiar spreadsheet-like interface, without the need to learn complicated SQL commands. Controls and wizards are available for users to:
- Create and compact database files
- Create, define, modify and delete tables
- Create, define and delete indexes
- Browse, edit, add and delete records
- Search records
- Import and export records as text
- Import and export tables from/to CSV files
- Import and export databases from/to SQL dump files
- Issue SQL queries and inspect the results
- Examine a log of all SQL commands issued by the application
SQLite Database Browser is not a visual shell for the sqlite command line tool. It does not require familiarity with SQL commands.
There are three methods to install sqlitebrowser on Ubuntu 18.04. We can use apt-get, apt and aptitude. In the following sections we will describe each method. You can choose one of them.
Install sqlitebrowser Using apt-get
Update apt database with apt-get using the following command.
sudo apt-get update
After updating apt database, We can install sqlitebrowser using apt-get by running the following command:
sudo apt-get -y install sqlitebrowser
Install sqlitebrowser Using apt
Update apt database with apt using the following command.
sudo apt update
After updating apt database, We can install sqlitebrowser using apt by running the following command:
sudo apt -y install sqlitebrowser
Install sqlitebrowser Using aptitude
If you want to follow this method, you might need to install aptitude first since aptitude is usually not installed by default on Ubuntu. Update apt database with aptitude using the following command.
sudo aptitude update
After updating apt database, We can install sqlitebrowser using aptitude by running the following command:
sudo aptitude -y install sqlitebrowser
How To Uninstall sqlitebrowser on Ubuntu 18.04
To uninstall only the sqlitebrowser package we can use the following command:
sudo apt-get remove sqlitebrowser
Uninstall sqlitebrowser And Its Dependencies
To uninstall sqlitebrowser and its dependencies that are no longer needed by Ubuntu 18.04, we can use the command below:
sudo apt-get -y autoremove sqlitebrowser
Remove sqlitebrowser Configurations and Data
To remove sqlitebrowser configuration and data from Ubuntu 18.04 we can use the following command:
sudo apt-get -y purge sqlitebrowser
Remove sqlitebrowser configuration, data, and all of its dependencies
We can use the following command to remove sqlitebrowser configurations, data and all of its dependencies, we can use the following command:
sudo apt-get -y autoremove --purge sqlitebrowser
References
Summary
In this tutorial we learn how to install sqlitebrowser package on Ubuntu 18.04 using different package management tools: apt, apt-get and aptitude.
