fullstack-vc/tasks

Path
tasks/index.md

Tasks

  • Migrate Participant Stacks from Markdown to Turso with DB→Markdown Materialization - Stacks (current / aspirational / abandoned) live today in src/content/participants/.md and persist via GitHub App commits on every save — the same pattern the polling blueprint v2 §8.1 explicitly retired for time-sensitive data because of commit-history pollution, PEM brittleness, and concurrent-edit fragility. This task moves stacks to Astro DB on Turso as the authoritative store, with a periodic snapshot back to markdown so the build-in-public visibility stays intact. Generalizes the same materialization motion polling already uses (v2 §9), bringing two surfaces under one principled pattern.
  • Pre-create Turso User Rows from External Rosters and Fuzzy-Bind to Public Participant Profiles - Build the Turso-side ingest + fuzzy-match layer that lets us pre-create User rows from external sources (Zoom exports, Luma RSVPs, conference registrations) with full email PII safely sequestered in the private database, then auto-bind those rows to OAuth sign-ins by email and offer high-confidence manual claims against public participants/*.md profiles. Closes the loop between ‘we know they registered’ and ‘they have a face on the site.’
  • Redesign Stack Builder with Toggleable Multi-Column Layout and Cross-Column Drag-Drop - Today’s StackBuilder is a single-column ‘Current stack’ editor — aspirational and abandoned entries are only reachable by scrolling far below and editing the markdown frontmatter by hand. Redesign as a wider three-bucket canvas with pill toggles for which buckets are visible, two-up side-by-side view when two are active, and drag-and-drop to move tools across buckets. Cross-column moves reshape data (notes ↔ intent ↔ reason) with inline prompts so nothing is silently lost. Mobile gracefully degrades to a tap-to-move modal.
  • Wire Google Workspace OAuth as a Third Identity Provider - Env scaffolding for Google OAuth was added (uncommitted .env.example diff + real credentials in .env), but the code wiring was never written. This task implements the routes, session-payload union widening, header tooltip row, login button, and roster matching to bring Google to parity with the GitHub + LinkedIn providers — highest-leverage move before the May 27 All-Hands since most VC attendees convert better on Workspace than on either existing provider.