How to Install Beekeeper Studio on Ubuntu 20.04 LTS

Beekeeper Studio might be a perfect choice for those looking for an easy-to-use and comprehensive GUI electron front end for database management. This open-source database GUI can easily connect with any MariaDB or Postgres and works well alongside other popular databases such as MySQL, CockroachDB, Amazon Redshift, SQLite, and SQL DB. Currently, Beekeeper Studio only supports TCP connections for PSQL or MySQL, not the Unix socket connections.

Beekeeper Studio comes equipped with all sorts of useful features you would expect in a quality SQL program: autocomplete functionality includes completable queries without having to make multiple trips back-and-forth between programs; there’s even live reflection on what your query will do right before it finishes running so that minor mistakes don’t go unnoticed while typing.

In the following tutorial, you will learn how to install Beekeeper Studio on Ubuntu 20.04 LTS Focal Fossa by importing the official repository and installing the application from it.

Update Ubuntu System

Update your Ubuntu operating system to make sure all existing packages are up to date:

sudo apt update && sudo apt upgrade -y

Import Beekeeper Studio Repository

By default, Beekeeper is not available on Ubuntu’s repository; luckily, you can import the Beekeeper Studio PPA.

First, import the GPG key using the following command.

sudo wget -O- https://deb.beekeeperstudio.io/beekeeper.key | gpg --dearmor | sudo tee /usr/share/keyrings/beekeeper.gpg

Next, import the repository.

echo 'deb [signed-by=/usr/share/keyrings/beekeeper.gpg] https://deb.beekeeperstudio.io stable main' | sudo tee /etc/apt/sources.list.d/beekeeper-studio-app.list

Lastly, run an APT update.

sudo apt update

Install Beekeeper Studio

With the GPG key and repository now imported and added securely, you can begin the installation of Beekeeper using the following terminal command.

sudo apt install beekeeper-studio

Next, confirm the installation by using the apt-cache policy command.

apt-cache policy beekeeper-studio

Example output:

How to Install Beekeeper Studio on Ubuntu 20.04 LTS

As above, the latest Beekeeper Studio is installed. Also listed are alternative backward installations that you can install if you had to back-track to any alternative versions of the latest had a severe bug.

Launch Beekeeper Studio

To launch the application, you can use the terminal command in your console:

beekeeper-studio

Alternatively, run beekeeper-studio & command in the background to free up the terminal:

beekeeper-studio &

However, this isn’t practical, and you would use the following path on your desktop to open with the path: Activities > Show Applications > Beekeeper Studio

Example:

How to Install Beekeeper Studio on Ubuntu 20.04 LTS

Once launched, you will land on the default landing screen to select a connection type to proceed.

Example:

How to Install Beekeeper Studio on Ubuntu 20.04 LTS

Update/Upgrade Beekeeper Studio

You can run your standard apt update or upgrade commands to receive updates.

sudo apt update && sudo apt upgrade

Remove (Uninstall) Beekeeper Studio

Use the following command to remove when you no longer require Beekeeper installed on your Ubuntu system.

sudo apt autoremove beekeeper-studio --purge -y

Next, remove the GPG key.

sudo rm /usr/share/keyrings/beekeeper.gpg

Lastly, remove the repository.

sudo rm /etc/apt/sources.list.d/beekeeper.list

Make sure to remove both the GPG key and repository together!!!

Comments and Conclusion

In the tutorial, you have learned how to install Beekeeper Studio on Ubuntu 20.04 LTS by importing the repository and gpg key, giving you the latest version.

The Beekeeper Studio software is a powerful tool for learning SQL or monitoring SQL without making multiple trips back-and-forth between programs. It has all the features you would expect from a quality program and will quickly help you become more skilled in this field.



Follow LinuxCapable.com!

Like to get automatic updates? Follow us on one of our social media accounts!