How I Added Unit Tests to a Next.js Project Using Vitest (and Why It Matters for Portfolio Projects)
typescript
dev.to
I recently built a SQL and Python interview prep app using Next.js, TypeScript, Supabase, and Vercel, with ChatGPT and Claude Code for code assist. The core of the app is a custom SQL answer checker — a function that evaluates whether a user's SQL query contains the right keywords, avoids forbidden patterns, and selects the right columns. The sql-warmup-questions.ts file contains the promptText and expectedIncludes for each question: export type WarmupQuestion = { slug: string; title: st