Final_PGA/docs/architecture.md

PostgreSQL Admin Control Plane

Overview

This repository contains a production-oriented PostgreSQL admin panel with:

• backend: Express + TypeScript API, RBAC, audit, session management, SQL guard
• frontend: React + TypeScript admin console
• infra: SQL bootstrap for control and target databases
• docker: production-style images and reverse proxy

Key Design Decisions

• Metadata, sessions, RBAC, and audit live in a dedicated control database.
• Managed PostgreSQL access is mediated by the backend only.
• Dynamic schema operations use pg with validated identifiers instead of an ORM.
• Permissions are enforced on the backend for every sensitive route.
• The UI preserves the visual direction of the original index.html, but is split into modular React components.