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 22.04 LTS Jammy Jellyfish by importing the official repository and installing the application from it with the command line terminal.
Table of Contents
First, update your system using the following command to ensure all packages are up-to-date.
sudo apt update && sudo apt upgrade -y
Install Required Packages
To complete the installation, you will need to install the following software packages by using the following command in your terminal.
sudo apt install software-properties-common apt-transport-https wget ca-certificates gnupg2 -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
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 that had a severe bug.
How to Launch Beekeeper Studio
To launch the application, you can use the terminal command in your console:
However, this isn’t practical, and you would use the following path on your desktop.
Activities > Show Applications > Beekeeper Studio
Once launched, you will land on the default landing screen to select a connection type to proceed.
How to Update/Upgrade Beekeeper Studio
You can run your standard apt update or upgrade commands to receive updates.
sudo apt update && sudo apt upgrade
How to Remove (Uninstall) Beekeeper Studio
When you no longer require Beekeeper installed on your Ubuntu system, use the following command to remove it.
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 22.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.