Khushboo Vashi

Bio

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

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.

  1. 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

  1. Dashboard

How can we use this dashboard?

  1. 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.

  1. 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.

  1. 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.

  1. PSQL Tool

The PSQL tool allows users to connect to PostgreSQL or EDB Advanced server using the PSQL command-line interface through their browser.

  1. 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)

  1. 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.

  1. Authentication

Support for various authentications like Kerberos/LDAP/Oauth2/Two Factor Authentication.