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.
Talk Description: pgAdmin 4 Management Tool for PostgreSQL
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
is a free software project released under the PostgreSQL License.
is it useful?
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.
4 is a complete rewrite of pgAdmin III, built using Python and
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.
features of the pgAdmin (Presentation and Live Demo)
will select some of the following features to cover in 45 minutes.
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
can we use this dashboard?
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
Diff is a feature that allows you to compare objects between two
databases or two schemas. The Schema Diff feature allows you to:
and synchronize the database objects (from source to target).
the differences between database objects.
the differences in SQL statements for target database objects.
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
PSQL tool allows users to connect to PostgreSQL or EDB Advanced
server using the PSQL command-line interface through their browser.
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.
import/export: from or to a file (csv)
PostgreSQL server can be deployed on the cloud-like Amazon RDS, EDB’s BigAnimal,
Azure. Currently, pgAdmin 4 supports only Amazon AWS RDS.
Support for various authentications like Kerberos/LDAP/Oauth2/Two Factor Authentication.