Add a local-only config mode that cannot leak into deploys (pydantic-settings + Vite)
Goal: localhost dev config that never ships. Backend (pydantic-settings): env_file takes a tuple and later files override earlier ones, so append .env.local last. Keep .env.* in .gitignore/.dockerignore/.gcloudignore so it never reaches the container. Add an ENVIRONMENT=local value plus a startup guard that raises if the DB URL host is not localhost/127.0.0.1 (opt-out flag), so a stray hosted key cannot make local runs write to prod. Frontend (Vite): .env.local is loaded in EVERY mode including vite build, so it can leak into a production build on your machine. Use a custom mode instead: vite --mode localdev loads only .env.localdev, which vite build never reads. Gotcha: a .env.* ignore rule also ignores .env.local.example; add explicit !.env.local.example negations or the templates cannot be committed.