My Weird Prompts
Daniel Rosehill
Podcast
Episodes
Listen, download, subscribe
The Missing Middle: Content APIs and ISR for a 6,000-Episode Catalog
Daniel has built a 6,000-episode podcast with no admin panel — just Claude Code and a custom admin MCP talking to Neon. But Neon's docs explicitly warn against connecting MCP agents to production databases, and Vercel's 45-minute build ceiling looms over every deploy. This episode works through the architecture question: does the catalog need a bespoke content API, or do Vercel's ISR with tag-based revalidation and Neon's Data API already provide the arbiter layer? We dig into why the current "batch of five triggers a deploy" pattern breaks, how generateStaticParams and on-demand revalidation flip the model from build-time to request-time, and the one caveat that actually matters — every new deployment starts with a cold ISR cache. Key sources: • Vercel — https://vercel.com/docs/incremental-static-regeneration • Vercel — https://vercel.com/docs/incremental-static-regeneration/quickstart • Vercel — https://vercel.com/kb/guide/how-do-i-reduce-my-build-time-with-next-js-on-vercel Episode 5940 — myweirdprompts.com/n/5940 (permanent short link: myweirdprompts.com/931798)
My Weird Prompts RSS Feed
