I am a Python Full Stack developer and have been working on web technologies since 2005. I have been involved in pgAdmin 4 development since 2014, the very beginning of the project. Currently working as a Software Architect at EnterpriseDB.
What is pgAdmin?
Is the most popular and feature-rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world. pgAdmin is a management tool for PostgreSQL and derivative relational databases, including EnterpriseDB's EDB Advanced Server.
pgAdmin is a free software project released under the PostgreSQL License.
Why is it useful?
pgAdmin is an easy-to-use program designed for both novice and experienced Postgres users, providing a graphical user interface for creating, retrieving, maintaining, and using database objects.
Evolution of pgAdmin
pgAdmin 4 is a complete rewrite of pgAdmin III, built using Python and Javascript/jQuery. A desktop runtime is written in NWjs (from v5.0) allows it to run standalone for individual users, or the web application code may be deployed directly on a web server for use by one or more users through their web browser.
Main features of the pgAdmin (Presentation and Live Demo)
We will select some of the following features to cover in 45 minutes.
Query Tool
The Query Tool is a powerful, feature-rich environment that allows you to execute arbitrary SQL commands and review the result set. You can access the Query Tool via the Query Tool menu option on the Tools menu or through the context menu of select nodes of the Browser tree control. Autocompletion
Dashboard
How can we use this dashboard?
Debugger
The debugger may be used to debug PL/pgSQL functions in PostgreSQL, as well as EDB-SPL functions, stored procedures, and packages in EDB Postgres Advanced Server. The Debugger is available as an extension for your PostgreSQL installation and is distributed as part of the Advanced Server. You must have superuser privileges to use the debugger.
Schema Diff
Schema Diff is a feature that allows you to compare objects between two databases or two schemas. The Schema Diff feature allows you to:
Compare and synchronize the database objects (from source to target).
Visualize the differences between database objects.
List the differences in SQL statements for target database objects.
Generate synchronization scripts.
ERD Tool
The Entity-Relationship Diagram (ERD) tool is a database design tool that provides a graphical representation of database tables, columns, and inter-relationships. ERD can give sufficient information for the database administrator to follow when developing and maintaining the database.
PSQL Tool
The PSQL tool allows users to connect to PostgreSQL or EDB Advanced server using the PSQL command-line interface through their browser.
Import/Export
Configuration: Server definitions (and their groups) can be exported to a JSON file and re-imported to the same or a different system to enable easy pre-configuration of pgAdmin.
Data import/export: from or to a file (csv)
Cloud Deployment
The PostgreSQL server can be deployed on the cloud-like Amazon RDS, EDB’s BigAnimal, Azure. Currently, pgAdmin 4 supports only Amazon AWS RDS.
Authentication
Support for various authentications like Kerberos/LDAP/Oauth2/Two Factor Authentication.