How To Install sqlitebrowser on Ubuntu 21.04

One-liner install command

For those in a hurry, here's a one-line installation command:

sudo apt-get update && sudo apt -y install sqlitebrowser

But if you are interested in the detailed steps with descriptions, the following information is for you.

What is sqlitebrowser and what are the ways to install it?

Before beginning this tutorial, you will need access to a server or computer running Ubuntu 21.04. This guide was written specifically with a server running Ubuntu 21.04 in mind, although it should also work on older, supported versions of the operating system.

Also, make sure you are running a regular, non-root user with sudo privileges configured on your server. When you have an account available, log in as your non-root user to begin.

There are several ways to install sqlitebrowser on Ubuntu 21.04. You can use (links are clickable):

In the following sections, we will describe each method in detail. You can choose one of them or refer to the recommended one.

Install sqlitebrowser using apt-get

First, update apt database with apt-get using the following command.

sudo apt-get update

After updating apt-get database, You can install sqlitebrowser using apt by running the following command:

sudo apt -y install sqlitebrowser

Install sqlitebrowser using apt

Because sqlitebrowser is available in Ubuntu 21.04’s default repositories, it is possible to install it from these repositories using the apt packaging system.

To begin, update apt database with apt using the following command.

sudo apt update

After updating apt database, You 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 21.04. Update apt database with aptitude using the following command.

sudo aptitude update

After updating aptitude database, You can install sqlitebrowser by running the following command:

sudo aptitude -y install sqlitebrowser

How to upgrade (update) a single package sqlitebrowser using apt-get?

First, you will need to update packages index. Run update command as usual:

sudo apt-get update

Next, to upgrade only the sqlitebrowser, e.g. single package, you should use the following format with the apt-get command/apt command:

sudo apt-get --only-upgrade install sqlitebrowser

Note that this command will not install any new packages! If you wish to install the package if it doesn't exist you may leave out --only-upgrade part.

sudo apt-get install sqlitebrowser

How To Uninstall sqlitebrowser from Ubuntu 21.04

To uninstall only the sqlitebrowser package you can execute the following command:

sudo apt-get remove sqlitebrowser

Uninstall sqlitebrowser and all its dependencies

To uninstall sqlitebrowser and its dependencies that are no longer needed by Ubuntu 21.04, you can use the command below:

sudo apt-get -y autoremove sqlitebrowser

Remove sqlitebrowser with all configurations and data

To remove sqlitebrowser configuration and data from your system you can run the following purge command:

sudo apt-get -y purge sqlitebrowser

Remove sqlitebrowser completely (configurations, data and all of its dependencies)

And lastly, you can run the next command to remove absolutely everything related to sqlitebrowser package, e.g.: configurations, data and all of its dependencies. Just use this command:

sudo apt-get -y autoremove --purge sqlitebrowser

Extra info and code examples

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.

Conclusion

You now have a full guide on how to install sqlitebrowser using apt, apt-get and aptitude tools. Also, we showed how to update as a single package and different ways to uninstall the sqlitebrowser from Ubuntu 21.04.

See also: