Add to Chrome
Add to Edge
Add to Firefox
Add to Opera
Add to Brave
Add to SafariWhen comparing DBeaver vs pgAdmin 4, the Slant community recommends DBeaver for most people. In the question“What are the best GUI tools for PostgreSQL on Windows?” DBeaver is ranked 1st while pgAdmin 4 is ranked 6th. The most important reason people chose DBeaver is:
Supported on Windows (2000/XP/2003/Vista/7/8/10), Linux, Mac OS and Solaris (x86).
Specs
Question Ranking
Pros
Pro Cross-platform
Supported on Windows (2000/XP/2003/Vista/7/8/10), Linux, Mac OS and Solaris (x86).
Pro Free
It is licensed under GPL v2.
Pro Works for many types of databases
MySQL, Oracle, PostgreSQL, IBM DB2, Microsoft SQL Server, Microsoft Access, Sybase, Java DB (Derby), Firebird (Interbase), Derby (JavaDB), SQLite, Mimer, HSQLDB, H2, IBM Informix, Teradata, SAP MAX DB, Cache, Ingres, Linter, Vertica, MongoDB, Cassandra, ODBC, Any JDBC compliant data source.
Pro Follow foreign key to their primary key
If you have a table with a foreign key you can click on it to see the table row where this key references to.
Pro Formatted text view
It has the classic grid view and a well-organized text view that you can quick-select with CTRL-A.
Pro Easy to use, clean neat inteface
Pro Open source
pgAdmin is open source and actively contributed to.
Pro Dashboard displays useful overview of server activity
The dashboard tab includes server load visualizations and other useful details on database activity, such as connected sessions, database locks, and prepared transactions.
Pro Can be deployed on a server and accessed remotely from browser
As pgAdmin 4 is a web application, it can be easily deployed on any server and accessed remotely using any web browser.
Pro UI can be re-organized to user's liking
pgAdmin 4's user interface elements are detachable panels that can be dragged around and re-arranged to be displayed standalone or in the tabbed browser.
Pro Tabbed views to accomodate different screen/window sizes
The tabbed browser in pgAdmin 4 is excellent for accomodating different screen/window sizes. If you're on a small screen, the tabbed browser can save you screen estate by displaying the different panels in different tabs. If you're on a big screen, you can make full use of your screen estate by detaching the panels and moving it where you like.
Pro Portable version available
There is a portable version of pgAdmin available, pgAdminPortable that allows you to easily move your info between machines.
Cons
Con Never-ending function errors
Like, 'Communications link failure', 'Connection refused' (Community Edition 6.2.1).
Con Cannot view function
Con Trigger edition
Until version 3.5.8 you can not edit triggers, only view (since 3.5.6).
Con Resource intensive
pgAdmin4 is a web application. The native binary is a wrapped version of the web app that runs a webserver and web browser, thus it has a high memory footprint and other possible impacts on system resources a native application wouldn't have.
Con UI is slow
The user interface is slow, especially when interacting with query results. While queries execute fast, the user interface can lag behind — selecting a row from a table, scrolling through data, and performing other UI operations can have some delays.
Con UI for Mac is very different from other Mac apps
The file navigation seems homegrown and is very hard to use. It resets you to the root directory every time you open a new file browser. Actively frustrating to use.
Con Bloated
900MB installed, and for an unintuitive, and feature-lacking software.
Con Lack of a schema - sql option
Con Not Intuitive
Dated and obtuse UI design.
Con Non-native UI
Many "normal" key bindings don't work like in other apps. Scrolling behavior is terrible.
