Technical reference

System Reference

Five deep-dives into specific pieces of the system — the two AI models, the analytics warehouse, security practices, the page/schema map, and the admin dashboard. Each stands on its own; this page is just the index.

PageWhat it covers
AI: Foundation vs. Open-WeightTwo ways of reaching a model — a hosted foundation model (Claude) and a self-hosted open-weight model — run side by side and compared
Data WarehouseThe DuckDB analytics warehouse: schema, ETL, and the first real findings from studying what predicts a good draft pick
Security PracticesHow the site handles accounts, data, and credentials, written to be read by anyone
App InfoEvery player-facing page and the database schema behind them, in one reference
Admin TourA guided tour of what an admin can actually do