PgAdmin is one of the most popular Open Source administration and development platforms for PostgreSQL. Note that, for the installation examples, we’ll test it on Ubuntu 18.04 Bionic. Now, let’s see some of the most commons GUI tools for PostgreSQL. One of the main advantages of the GUIs is that they are, in general, easier to learn than a lot of commands and probably one action on the GUI could generate a few commands to perform the task.Īnother advantage could be that the GUI is more friendly than the command line, and in most cases, you don’t need any programming or sysadmin knowledge to use it.īut, you should be careful before performing a task from the GUI, because by using the wrong button, you could generate a big issue like deleting a table and for this reason, do be careful when using this kind of tool. Using a GUI is not a must, but it can be useful.
The actions are performed by using graphical elements. What is a GUI Tool?Ī GUI or Graphical User Interface is a software that simplifies the tasks of the users through graphical icons and visual indicators. Let’s look at what these tools are about and review some of them. It’s not that you don’t need to manage the command line commands (it’s for sure a must), but there are some tools that can help you speed up many of the daily DBA tasks. The command line can sometimes be arduous and the display may not be optimal for what you are doing.īrowsing through databases and tables, checking indexes or user privileges, monitoring, managing, and even coding can get really messy when trying to handle it through the console. Managing databases from the command line does come with a learning curve to get the most out of it.
0 kommentar(er)
