pgadmin4

Overview of pgadmin4

What it is

pgAdmin 4 is a rewrite of the popular pgAdmin3 management tool for the PostgreSQL database. It is written as a web application with Python (Flask) on the server side and ReactJS, HTML5 with CSS for the client side processing and UI. It can be deployed either on a web server using a browser, or standalone on a workstation via an Electron-based runtime.

Key features

• Server-side Python (Flask) and client-side ReactJS, HTML5, CSS architecture - Supports both server mode (web browser) and desktop mode (standalone runtime)
• Provides a graphical interface for PostgreSQL administration and development - Built-in SQL query tool and schema browser - Supports multiple PostgreSQL server connections - Extensible through configuration and local settings

Use cases

• Administering PostgreSQL databases, including creating, modifying, and managing database objects - Developing and testing SQL queries - Monitoring database server activity and performance - Managing user roles and permissions - Migrating or comparing database schemas

Getting started

bash # Enable Corepack (adds yarn to PATH) corepack enable # Build web assets (on Linux/macOS) cd $PGADMIN4_SRC make install-node make bundle # Set up Python virtual environment python3 -m venv venv source venv/bin/activate pip install --upgrade pip pip install -r $PGADMIN4_SRC/requirements.txt # Run initial setup python3 $PGADMIN4_SRC/web/setup.py # Start pgAdmin 4 python3 $PGADMIN4_SRC/web/pgAdmin4.py For Windows setup, see the repository README.

License and pricing

The license is not stated in the metadata (NOASSERTION). The project is listed as open source.

Based on the project's public README and repository metadata.