BrighTO-Router PostgreSQL Role

BrighTO-Router PostgreSQL Role An architecture diagram generated by Archify. Admin Portal · routes, teams, keys · Architecture component · control Admin Portal routes, teams, keys control Client Apps · LLM / adapter calls · Architecture component · traffic Client Apps LLM / adapter calls traffic Admin API · validate changes · Architecture component · SQL write Admin API validate changes SQL write Rust Hot Path · auth, budget, proxy · Architecture component · fast path Rust Hot Path auth, budget, proxy fast path Control Tables · backends, routes, teams, api_keys · PostgreSQL durable store · source of truth Control Tables backends, routes, teams, api_keys source of truth Model Group Counters · cross-pod round robin · PostgreSQL durable store · PostgreSQL Model Group Counters cross-pod round robin PostgreSQL Usage Ledger · tokens, latency, status, errors · PostgreSQL durable store · metadata only Usage Ledger tokens, latency, status, errors metadata only JSONL Fallback · local replay file · Architecture component · temporary JSONL Fallback local replay file temporary ArcSwap Snapshot · lock-free config read · Router process memory · in memory ArcSwap Snapshot lock-free config read in memory Async Ledger Queue · batch off hot path · Router process memory · mpsc Async Ledger Queue batch off hot path mpsc LLM Providers · cloud or local backends · Architecture component · upstream LLM Providers cloud or local backends upstream Usage Dashboard · Portal charts and logs · Architecture component · read-only Usage Dashboard Portal charts and logs read-only Admin CRUD validated SQL poll + swap API request read config reserve RR block proxy + stream usage event batch INSERT DB down: append replay later usage SQL PostgreSQL durable store Router process memory Legend Frontend Backend Database Cloud Message bus