How stuv1983/afldb works
AFLDB is a closed-beta historical VFL/AFL and separately scoped AFLW statistics reference, with public browsing, records, comparisons and several kinds of search, plus audited administration and data-maintenance workflows. A typical user asks a question or opens a statistical page; the application resolves it through typed query logic against PostgreSQL and presents results. The README documents a deterministic natural-language search pipeline and the V2 acquisition, derived-data and operations capabilities. Source excerpts are limited, so links for unsampled areas use documented relationships rather than presumed implementation calls.
Main entry points: search Search pages · app Statistics pages · queries Statistics queries · parser.ts Question parser
Components 21
Public statistics
- Statistics pages
src/app - Statistics queries
src/db/queries - PostgreSQL
Search tools
- Search pages
src/app/search - Question parser
src/search/nl/parser.ts - Query planner
src/search/nl/plan.ts - Query executor
src/db/queries/nl/execute.ts - Statistical query builder
src/search/query-builder-spec.ts - Grid Solver
src/search/grid-solver-spec.ts
Administration
- Operations centre
src/app/admin/operations - Awards curation
packages/admin/src/curated-awards.ts
V2 data platform
- Acquisition pipeline
packages/acquisition/src/pipeline.ts - Domain controls
packages/domain/src/coverage-registry.ts - Derived statistics
packages/derived/src - Database utilities
packages/db/src - Historical dataset
Data operations
- Current-season AFL API
src/lib/acquisition/afl-api-client.ts - Vetted CSV intake
src/lib/ingest/pipeline.ts
Other components
- Visitor
- Search user
- Administrator
Connections 19
- Visitor → Statistics pages: browses
README.md - Statistics pages → Statistics queries: requests statistics
src/app/api/early-access/route.ts - Statistics queries → PostgreSQL: queries
- Search user → Search pages: asks question
README.md - Search pages → Question parser: parses question
README.md - Question parser → Query planner: plans query
README.md - Query planner → Query executor: compiles query
README.md - Query executor → PostgreSQL: queries PostgreSQL
README.md - Search pages → Statistical query builder: offers typed filters
README.md - Search pages → Grid Solver: offers grid questions
README.md - Administrator → Operations centre: reviews operations
README.md - Administrator → Awards curation: curates awards
README.md - Acquisition pipeline → Historical dataset: acquires data
- Current-season AFL API → Acquisition pipeline: supplies updates
- Vetted CSV intake → Historical dataset: stages submissions
- Domain controls → Historical dataset: defines coverage
- Historical dataset → Derived statistics: rebuilds aggregates
README.md - Database utilities → Historical dataset: produces manifests
README.md - Operations centre → Derived statistics: reviews determinations