Managing PostgreSQL with TablePlus
After setting up local
PostgreSQL, I'm looking for a SQL GUI tool to help me manage relational databases, such as
The first tool I used is
pgAdmin4, but when I launch it, it can not be opened and throw errors:
And then I tried to solve this problem but failed finally. Thus, I gave up to use it and turn to other tools.
Finally I decided to choose
TablePlus as the GUI tool of managing database. The reasons are:
- It is cross-platform tool for Mac, Linux and Windows.
- It has elegant UI and uses easily.
- It supports multiple databases including MySQL and PostgreSQL.
Ubuntu 22.04, you can run the commands below to install
# Add TablePlus gpg key wget -qO - https://deb.tableplus.com/apt.tableplus.com.gpg.key | gpg --dearmor | sudo tee /etc/apt/trusted.gpg.d/tableplus-archive.gpg > /dev/null # Add TablePlus repo sudo add-apt-repository "deb [arch=amd64] https://deb.tableplus.com/debian/22 tableplus main" # Install sudo apt update sudo apt install tableplus
For more information, see: https://tableplus.com/blog/2019/10/tableplus-linux-installation.html
On Ubuntu 22.04
The official tutorial: