17 lines
792 B
Markdown
17 lines
792 B
Markdown
# 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.
|