How lokesh081103/fast works
fast is a PostgreSQL explorer and report generator with a Streamlit interface and a companion FastAPI service. Users authenticate, inspect tables and columns, then generate filtered reports or pivot-style summaries; API clients can request JSON or XLSX results. The app also exposes monthly summaries, data upload, custom SQL, and admin capabilities. The excerpts show selected UI and API-to-core calls, but not all feature implementations or database wiring, so unsampled links are omitted.
Main entry points: app.py Streamlit app · api.py REST API · db_core.py Query and pivot core
Components 19
User interfaces
- Streamlit app
fast/app.py - REST API
fast/api.py
Access control
- App authentication
fast/app.py - API authentication
fast/api.py - Admin panel
fast/app.py
Data exploration
- Table discovery
fast/api.py - Report builder
fast/app.py - Custom SQL
fast/app.py - Data upload
fast/app.py
Report analytics
- Monthly summary
fast/app.py - Summary table UI
fast/app.py - Pivot matrix
fast/api.py - DPD buckets
fast/db_core.py - Efficiency pivot
fast/api.py - Flat pivot
fast/api.py
Shared data core
- Query and pivot core
fast/db_core.py
Other components
- User
- API client
- PostgreSQL
Connections 23
- User → Streamlit app: uses
fast/app.py - API client → REST API: requests
fast/api.py - Streamlit app → App authentication: requires login
fast/app.py - REST API → API authentication: checks access
fast/api.py - REST API → Query and pivot core: calls core
fast/api.py - Streamlit app → Query and pivot core: uses shared core
fast/app.py - REST API → Table discovery: serves schema
fast/api.py - Streamlit app → Report builder: renders report flow
fast/app.py - Streamlit app → Summary table UI: renders summary tab
fast/app.py - Summary table UI → Query and pivot core: builds pivot
fast/app.py - Report builder → Query and pivot core: fetches report data
fast/app.py - Streamlit app → Custom SQL: executes query
fast/app.py - Streamlit app → Data upload: offers upload
fast/app.py - Streamlit app → Monthly summary: offers summary
fast/app.py - Streamlit app → Admin panel: offers admin
fast/app.py - REST API → Pivot matrix: routes matrix
fast/api.py - Pivot matrix → Query and pivot core: builds matrix
fast/api.py - Pivot matrix → DPD buckets: adds buckets
fast/api.py - REST API → Efficiency pivot: routes efficiency
fast/api.py - Efficiency pivot → Query and pivot core: builds efficiency pivot
fast/api.py - REST API → Flat pivot: routes flat pivot
fast/api.py - Flat pivot → Query and pivot core: builds flat pivot
fast/api.py - Query and pivot core → PostgreSQL: queries database