Shipped: Affiliate Command Center — Live Partner Dashboard
Astro 6 dashboard with 5 pages, Turso serverless DB, redirect handler, and PartnerStack profile integration. All pages live with data.
By JTT
Solo Developer & Writer
Affiliate Command Center is live at https://affiliate-tawny-rho.vercel.app — a password-gated dashboard to manage affiliate programs, track short-link redirects, log commissions, and break down revenue per MVP.
What it does: Five integrated pages — Dashboard (overview stats), Programs (CRUD for partner programs like PartnerStack, Vercel, Stripe), Links (short-link codes with click tracking), Commissions (paid/pending per program), and MVPs (per-product revenue breakdown). The /r/[code] redirect handler works in production with a static fallback — no database required for link redirects.
Database: Turso serverless SQLite (affiliate-cc database). Schema has 5 tables with proper indexes. The app auto-initializes the schema and seeds default data (5 programs, 4 MVPs, 2 sample links) on first connection.
Tech stack: Astro 6 + React 19 + Tailwind CSS 3 + TypeScript. Dark-first design matching byjtt.com’s zinc/purple aesthetic. Vercel deployment with @astrojs/vercel adapter. Password auth via env var (no multi-user).
PartnerStack profile: Logo uploaded (300×300px JT lettermark, dark rounded square with purple accent). Profile at 88% complete — needs “What should program managers provide?” field filled in.
Next: Fill remaining PartnerStack profile fields. Start adding real affiliate links. Connect PartnerStack API for auto-imported commissions.
Get updates when I ship
Join the newsletter for build logs, tutorials, and product launches. No spam, unsubscribe anytime.
Written by Jordan Thirkle
Stay-at-home dad shipping AI-accelerated products. Posts come from real builds, not theory.
Continue Reading
Astro 6 View Transitions: High-Performance DOM Caching
Master Astro 6 view transitions. Learn how to architect zero-layout-shift DOM caching and unblock the event loop for highly performant, minimalist web apps.
Edge-Native Micro-SaaS with Astro 6 and Preact
A deep dive into building ultra-fast, edge-native micro-SaaS applications using Astro 6, Preact, and Cloudflare Workers. Zero-BS engineering for solo devs.
VibeBranding Phase 2.5: Mock Fallback, Export, 218 Tests
Zero-warning build with deterministic mock data for all 9 pipeline stages, dashboard export endpoint, proxy migration, and 26 new tests.