How To Install sqlitebrowser on Debian 10

Learn how to install sqlitebrowser on Debian 10 with this tutorial. sqlitebrowser is GUI editor for SQLite databases

Introduction

In this tutorial we learn how to install sqlitebrowser on Debian 10.

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 Debian 10. 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 Debian. 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 Debian 10

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 Debian 10, we can use the command below:

sudo apt-get -y autoremove sqlitebrowser

Remove sqlitebrowser Configurations and Data

To remove sqlitebrowser configuration and data from Debian 10 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

Dependencies

sqlitebrowser have the following dependencies:

References

Summary

In this tutorial we learn how to install sqlitebrowser package on Debian 10 using different package management tools: apt, apt-get and aptitude.