Codec is a multi-game companion with a separate pillar for each game, behind one Google sign-in.
Teamfight Tactics: an annotated comp library with Riot API match tracking, AI-assisted coaching and growth analytics. Enshrouded: a recipe and crafting tracker with shared campaign accounts, unlock tracking and a recursive bill-of-materials gather list for co-op sessions. 7 Days to Die: an item and recipe reference.
SHIPPED
scripts/enrich-enshrouded-drops.ts pulls the wiki Drops
Cargo table (286 rows), matches to ref_items by slug, writes drops: [{ source, qty, type }]
into properties; 91 items enriched, idempotent on re-runEmber, Shroud, EmberSpan,
ShroudSpan) as a workaround for next-mdx-remote/rsc style stripping/api/wiki/feedback — codec server-to-server calls authenticate
via CODEC_API_KEY; game_slug column added to public.wiki_feedback (additive, nullable —
existing wiki inserts unaffected)category — ON CONFLICT DO UPDATE still
validates all NOT NULL constraints before routing to UPDATE even when the row exists; fixed by
switching to individual .update().eq("id") callsnext-mdx-remote/rsc silently strips style={{ }} props from inline MDX JSX — DOM inspection
confirms style attr: null at runtime; define named components in the page file with styles in
TypeScript and reference by name in the MDXON CONFLICT DO UPDATE validates NOT NULL constraints on the INSERT row before checking
for a conflict — partial upserts that omit required columns fail even when the row already existsDrops table has 40 slugs that don't match ref_items — name discrepancies
between the Ingredients table (ETL source) and Drops; 91/131 is still solid coverage for v1action=cargoquery); 5,227 ingredient edges stored in a normalized junction table for recursive traversalexplode()) recursively expands any recipe to raw materials, cycle-guarded via Set, depth-capped at 12 — crafted intermediates collapse automatically into the final aggregatejoin_campaign() returned "Invalid invite code" for all callers — root cause: codec schema tables don't auto-grant INSERT to service_role; fixed by converting to a SECURITY DEFINER function owned by postgresRETURNS TABLE(campaign_id uuid, ...) caused "column reference is ambiguous" inside the function body — output variable shadowed the same-named column in INSERT ... ON CONFLICT; fixed by switching to RETURNS void (required DROP FUNCTION + recreate, return type can't change in place).range() paginationremark-gfm was imported but not in package.json, breaking the build and silently breaking table rendering everywhere; missing dep committed immediatelyservice_role bypasses RLS but still needs explicit grants on non-public schemas — service_role is not omnipotent the moment you use a custom schemaRETURNS TABLE(col_name type) creates output variables that shadow same-named columns inside the function body — use RETURNS void when the caller needs no return value.select() results at 1000 rows with no error — any ETL read-back or full-table scan needs .range() pagination from the startMDXRemote made every table in the wiki render as pipe text; the tool catching its own gap on first use is a good signaction=cargoquery) is a clean structured data source for any wiki on the platform — structured JSON, no scraping, covers the full recipe corpus.env.local + Verceluser_profilessyncRecentMatches pulls last 20 TFT games, parses participant data (units, traits, augments, placement, duration), upserts into games + game_unitsuser_profiles schema extended with riot_puuid, riot_game_name, riot_tag_line columnslib/riot/client.ts — Riot API utility: PUUID lookup, match history, match detail, region → routing value mapping, queue ID → mode stringRIOT_API_KEY added to Vercel env via file redirect (pipe fails on this CLI version)env add requires file redirect (< /tmp/file), not pipe — pipe produces "Invalid number of arguments" on current CLI versionamericas, europe, asia, sea) for PUUID lookup — distinct from platform values (NA1, EUW1); using the wrong one returns 40401, 1 byte per champion) doesn't match current codes; text paste via Claude API is more reliable than binary format decoding.env.local and Vercel when receivedsimilarity_score + matched_comp_id on gamesadaptation panel uses amber accent to flag game-critical notesuseMemo over full comp set; show_archived: true on initial fetch so archive toggle works without refetchcodec.understorylabs.co — Google OAuth working, all routes protected, user data isolated via Supabase RLSmiddleware.ts with export function middleware() — produced deprecation warning in Vercel build; fixed by creating proxy.ts with export async function proxy() and deleting middleware.tssetTimeout(() => setIsModalOpen(true), 0)localhost:5173 on live deployment: caused by Supabase shared project having only localhost in Redirect URLs; fixed by adding https://codec.understorylabs.co/auth/callback to Redirect URLs (Site URL unchanged)nrisacher-lang/codec — private; git remote set-url required after initial remote conflictcodec.understorylabs.co CNAME routes through Cloudflare (DNS-only) to Vercelmiddleware.ts is present — the message says "use proxy instead," which is exact; reading Vercel build output catches this immediatelystyle props for opacity variants — bg-my-color/80 silently outputs full opaque color when the token is a CSS variable; color-mix() is the fix