# Brandon Perfetti - Full LLM Index
> Senior frontend-focused full-stack engineer delivering practical software systems with Next.js, TypeScript, GraphQL, and AI SDK + MCP workflows.

Base: https://brandonperfetti.com
Primary index: https://brandonperfetti.com/llms.txt
Sitemap: https://brandonperfetti.com/sitemap.xml

## Content Corpus
## Your Runbook Is Rotting. Teach It to an Agent Instead.
- URL: https://brandonperfetti.com/articles/runbooks-to-agent-skills
- Published: 2026-08-18T12:00:00.000Z
- Updated: 2026-08-23T15:43:29.401Z
- Summary: A real Next.js modernization produced a playbook — and instead of letting it rot in a wiki, I turned it into a tested AI agent skill. The arc: capture the bruises, convert ordering into gates, pitfalls into tripwires, checks into code, and prove it with baselined evals (14/14 vs 7/14).
- Topics: Developer Tooling, Web Development, Next.js
- Keywords: Developer Tooling, Web Development, Next.js, AI Agents, Agent Skills, Claude, Next.js
- Tech: AI Agents, Agent Skills, Claude, Next.js

## The Cheapest Database Migration Is the One You Do Before Production Exists
- URL: https://brandonperfetti.com/articles/from-neon-to-supabase
- Published: 2026-08-14T12:00:00.000Z
- Updated: 2026-08-23T15:43:09.756Z
- Summary: I moved my portfolio's Postgres from Neon to Supabase in one evening — and the real reason it was easy is timing. The cheap-migration-window thesis, plus the adapter swap, pooler modes, restore ordering, and the username gotcha.
- Topics: Databases, Backend, Web Development
- Keywords: Databases, Backend, Web Development, Supabase, Neon, PostgreSQL, Payload CMS, Vercel
- Tech: Supabase, Neon, PostgreSQL, Payload CMS, Vercel

## I Was Paying $20 a Month to Email Myself
- URL: https://brandonperfetti.com/articles/from-sendgrid-to-resend
- Published: 2026-08-11T12:00:00.000Z
- Updated: 2026-08-23T15:42:53.473Z
- Summary: A $19.95/month plan whose only job was delivering my own contact form — until a paywall forced the audit. The one-evening SendGrid-to-Resend migration, and a four-signal framework for spotting vendor inertia.
- Topics: Backend, Web Development, Tips
- Keywords: Backend, Web Development, Tips, Resend, SendGrid, Email Deliverability, Payload CMS, Next.js
- Tech: Resend, SendGrid, Email Deliverability, Payload CMS, Next.js

## The Stack I'll Reuse: My 2026 Next.js Foundation, and the Rules That Keep It Current
- URL: https://brandonperfetti.com/articles/the-nextjs-stack-i-reuse
- Published: 2026-08-10T12:00:00.000Z
- Updated: 2026-08-23T15:42:33.541Z
- Summary: The production-proven stack from my portfolio rebuild — Next.js 16, Payload, Tailwind v4, Clerk, the AI SDK, and a real testing spine — plus the upgrade discipline that matters more than any single tool choice.
- Topics: Next.js, Frontend Architecture, Developer Tooling
- Keywords: Next.js, Frontend Architecture, Developer Tooling, Next.js, React 19, TypeScript, Tailwind CSS, Payload CMS, Vitest
- Tech: Next.js, React 19, TypeScript, Tailwind CSS, Payload CMS, Vitest

## From Notion to Payload: Why I Rebuilt My Portfolio's Content Engine
- URL: https://brandonperfetti.com/articles/from-notion-to-payload
- Published: 2026-08-10T12:00:00.000Z
- Updated: 2026-08-23T15:41:56.570Z
- Summary: A field report from replacing a five-system Notion content pipeline with Payload embedded in Next.js: what the workspace-tool era got right, where it broke down, and the architecture decisions worth stealing.
- Topics: Web Development, Code Migration, Frontend Architecture
- Keywords: Web Development, Code Migration, Frontend Architecture, Payload CMS, Notion, Next.js, TypeScript, PostgreSQL
- Tech: Payload CMS, Notion, Next.js, TypeScript, PostgreSQL

## Writing Tests for React That Don't Make You Want to Quit
- URL: https://brandonperfetti.com/articles/writing-tests-for-react-that-dont-make-you-want-to-quit
- Published: 2025-05-12T00:00:00.000Z
- Updated: 2026-08-22T22:41:25.333Z
- Summary: A practical React testing guide with Testing Library: what to test, what to skip, resilient patterns, and a workflow teams actually adopt.
- Topics: Frontend, Web Development, Tips, Developer Experience, Testing
- Keywords: Frontend, Web Development, Tips, Developer Experience, Testing, React, JavaScript, TypeScript, Vitest, Jest, React Testiing Library, MSW
- Tech: React, JavaScript, TypeScript, Vitest, Jest, React Testiing Library, MSW

## Component Composition Patterns in React That Actually Scale
- URL: https://brandonperfetti.com/articles/component-composition-patterns-in-react-that-actually-scale
- Published: 2023-07-03T00:00:00.000Z
- Updated: 2026-08-22T22:41:18.851Z
- Summary: A practical guide to React composition patterns that scale across teams, with clear trade-offs, implementation tactics, and migration steps.
- Topics: React component composition, Scalable UI architecture, React Best Practices, Frontend Architecture
- Keywords: React component composition, Scalable UI architecture, React Best Practices, Frontend Architecture, React, TypeScript, JavaScript
- Tech: React, TypeScript, JavaScript

## Custom React Hooks: When to Extract and When to Leave It Inline
- URL: https://brandonperfetti.com/articles/custom-react-hooks-when-to-extract-and-when-to-leave-it-inline
- Published: 2023-07-17T00:00:00.000Z
- Updated: 2026-08-22T22:41:12.713Z
- Summary: A practical guide to deciding when to extract custom React hooks versus leaving logic inline, with clear trade-offs and review-ready criteria.
- Topics: React Best Practices, Frontend Architecture
- Keywords: React Best Practices, Frontend Architecture, React, JavaScript, TypeScript
- Tech: React, JavaScript, TypeScript

## Node.js Error Handling That Doesn't Embarrass You in Production
- URL: https://brandonperfetti.com/articles/nodejs-error-handling-that-doesnt-embarrass-you-in-production
- Published: 2023-11-06T00:00:00.000Z
- Updated: 2026-08-22T22:41:06.285Z
- Summary: A practical guide to Node.js error handling in production: classification, centralized middleware, observability, and resilient failure patterns.
- Topics: Node.js backend, Error Handling, Production Reliability
- Keywords: Node.js backend, Error Handling, Production Reliability, Node.js, Express.js, TypeScript
- Tech: Node.js, Express.js, TypeScript

## Web Performance Metrics That Actually Move the Needle
- URL: https://brandonperfetti.com/articles/web-performance-metrics-that-actually-move-the-needle
- Published: 2025-06-09T00:00:00.000Z
- Updated: 2026-08-22T22:41:00.087Z
- Summary: A practical guide to LCP, CLS, and INP in plain English, including what each metric measures, how to diagnose it with Chrome tools, and the fixes that usually pay off
- Topics: Web Development, Frontend, Performance, Developer Experience, Tips
- Keywords: Web Development, Frontend, Performance, Developer Experience, Tips, Browsers, Chrome DevTools, Lighthouse, Web Vitals, HTTP/CDN
- Tech: Browsers, Chrome DevTools, Lighthouse, Web Vitals, HTTP/CDN

## useCallback and useMemo: Stop Reaching for Them by Default
- URL: https://brandonperfetti.com/articles/usecallback-and-usememo-stop-reaching-for-them-by-default
- Published: 2023-09-25T00:00:00.000Z
- Updated: 2026-08-22T22:11:39.291Z
- Summary: A practical guide to when useCallback and useMemo improve React performance, and when they only add complexity without measurable gains.
- Topics: React Best Practices, Frontend Architecture
- Keywords: React Best Practices, Frontend Architecture, React, JavaScript, TypeScript
- Tech: React, JavaScript, TypeScript

## Monorepo vs Polyrepo: The Real Decision for Full-Stack JS Teams
- URL: https://brandonperfetti.com/articles/monorepo-vs-polyrepo-the-real-decision-for-full-stack-js-teams
- Published: 2025-05-26T00:00:00.000Z
- Updated: 2026-08-22T22:11:33.119Z
- Summary: A pragmatic guide to choosing monorepo or polyrepo for a full-stack JavaScript team, including where pnpm workspaces and Turborepo help, where they add friction, and how
- Topics: Web Development, Backend, Frontend, Developer Experience, Tips
- Keywords: Web Development, Backend, Frontend, Developer Experience, Tips, Node.js, Git, CI/CD
- Tech: Node.js, Git, CI/CD

## React useRef Beyond DOM Manipulation: The Patterns Worth Knowing
- URL: https://brandonperfetti.com/articles/react-useref-beyond-dom-manipulation-patterns-worth-knowing
- Published: 2025-04-14T00:00:00.000Z
- Updated: 2026-08-22T22:11:27.021Z
- Summary: A practical React useRef guide beyond DOM access, including stable references, escaping re-renders, and integration patterns.
- Topics: React, Hooks, Component Patterns
- Keywords: React, Hooks, Component Patterns, React, Hooks, JavaScript
- Tech: React, Hooks, JavaScript

## CSS Grid: The Layout System You've Been Avoiding (And Shouldn't)
- URL: https://brandonperfetti.com/articles/css-grid-the-layout-system-youve-been-avoiding-and-shouldnt
- Published: 2023-09-11T00:00:00.000Z
- Updated: 2026-08-22T22:11:19.557Z
- Summary: Stop avoiding CSS Grid. Learn the core concepts, practical patterns, and a migration checklist to ship better, responsive layouts fast.
- Topics: Grid fundamentals and mental model, Pattern-first layout design, Responsive techniques with Grid, Interoperability with Flexbox, Debugging and browser behaviour, Incremental migration strategies, Accessibility considerations for layout
- Keywords: Grid fundamentals and mental model, Pattern-first layout design, Responsive techniques with Grid, Interoperability with Flexbox, Debugging and browser behaviour, Incremental migration strategies, Accessibility considerations for layout, CSS, HTML, Web browsers
- Tech: CSS, HTML, Web browsers

## JavaScript Async/Await Patterns That Trip Up Senior Devs
- URL: https://brandonperfetti.com/articles/javascript-asyncawait-patterns-that-trip-up-senior-devs
- Published: 2023-07-31T00:00:00.000Z
- Updated: 2026-08-22T22:11:13.023Z
- Summary: A practical guide to async/await pitfalls in production JavaScript, including partial failures, cancellation, retries, and concurrency trade-offs.

## Node.js Streams: Why They Matter and When to Actually Use Them
- URL: https://brandonperfetti.com/articles/nodejs-streams-why-they-matter-and-when-to-actually-use-them
- Published: 2025-04-28T00:00:00.000Z
- Updated: 2026-08-22T22:11:06.310Z
- Summary: A practical Node.js streams guide that explains when streams are the right abstraction and how to use them reliably in production.
- Topics: Node.js Streams, Node.js Streams, Back-end Performance, Back-end Performance, File I/O, File I/O
- Keywords: Node.js Streams, Node.js Streams, Back-end Performance, Back-end Performance, File I/O, File I/O, Node.js, Node.js, Streams API, Streams API, HTTP, HTTP
- Tech: Node.js, Node.js, Streams API, Streams API, HTTP, HTTP

## MongoDB vs PostgreSQL: The Decision Framework I Actually Use
- URL: https://brandonperfetti.com/articles/mongodb-vs-postgresql-the-decision-framework-i-actually-use
- Published: 2024-07-01T00:00:00.000Z
- Updated: 2026-08-22T22:10:54.325Z
- Summary: A practical MongoDB vs PostgreSQL decision framework based on real production trade-offs: data shape, query complexity, team operations, and long-term maintenance.

## Optimistic UI Updates in React: Making Your App Feel Instant
- URL: https://brandonperfetti.com/articles/optimistic-ui-updates-in-react-making-your-app-feel-instant
- Published: 2025-03-03T00:00:00.000Z
- Updated: 2026-08-22T21:39:57.952Z
- Summary: A practical guide to optimistic UI patterns in React, including rollback, conflict handling, and feedback strategies for trustworthy fast-feeling apps.
- Topics: Optimistic UI, React, User Experience
- Keywords: Optimistic UI, React, User Experience, React, JavaScript, HTTP APIs
- Tech: React, JavaScript, HTTP APIs

## CSS Custom Properties: They're Not Just for Color Tokens
- URL: https://brandonperfetti.com/articles/css-custom-properties-theyre-not-just-for-color-tokens
- Published: 2024-04-01T00:00:00.000Z
- Updated: 2026-08-22T21:39:48.223Z
- Summary: A practical guide to using CSS custom properties beyond color tokens for theming, responsive systems, and component APIs.

## GSAP ScrollTrigger in React: The Patterns That Actually Work
- URL: https://brandonperfetti.com/articles/gsap-scrolltrigger-in-react-the-patterns-that-actually-work
- Published: 2023-10-09T00:00:00.000Z
- Updated: 2026-08-22T21:39:41.887Z
- Summary: A practical guide to GSAP ScrollTrigger patterns in React that actually hold up in production, including lifecycle, cleanup, and responsive behavior.
- Topics: Frontend, Web Development, Developer Experience, Performance
- Keywords: Frontend, Web Development, Developer Experience, Performance, React, JavaScript
- Tech: React, JavaScript

## Image Optimization for the Web: What Actually Makes a Difference
- URL: https://brandonperfetti.com/articles/image-optimization-for-the-web-what-actually-makes-a-difference
- Published: 2025-07-07T00:00:00.000Z
- Updated: 2026-08-22T21:39:35.332Z
- Summary: A practical image optimization checklist covering formats, responsive images, lazy loading, CLS prevention, and CDN delivery without overengineering.
- Topics: Performance, Web Development, Developer Experience
- Keywords: Performance, Web Development, Developer Experience, HTML, CSS, HTTP, Browser DevTools
- Tech: HTML, CSS, HTTP, Browser DevTools

## API Rate Limiting in Node.js: Protecting Your Backend Without Killing UX
- URL: https://brandonperfetti.com/articles/api-rate-limiting-in-node-js-protecting-your-backend-without-killing-ux
- Published: 2025-08-18T00:00:00.000Z
- Updated: 2026-08-22T21:39:29.030Z
- Summary: A practical Node.js rate limiting guide covering token bucket vs sliding window, express-rate-limit, Redis-backed limits, and how to protect APIs without punishing
- Topics: Web Development, Backend, Security, Performance, Developer Experience, Tips
- Keywords: Web Development, Backend, Security, Performance, Developer Experience, Tips, Node.js, Express, Redis, HTTP
- Tech: Node.js, Express, Redis, HTTP

## TypeScript: interface vs type — The Real Difference and When It Matters
- URL: https://brandonperfetti.com/articles/typescript-interface-vs-type-the-real-difference-and-when-it-matters
- Published: 2023-10-23T00:00:00.000Z
- Updated: 2026-08-22T21:39:22.325Z
- Summary: A practical guide to choosing between TypeScript interface and type based on extensibility, composition, and real-world maintainability.

## MongoDB Aggregation Pipeline: The Feature That Unlocks Real Queries
- URL: https://brandonperfetti.com/articles/mongodb-aggregation-pipeline-the-feature-that-unlocks-real-queries
- Published: 2024-02-12T00:00:00.000Z
- Updated: 2026-08-22T21:39:16.071Z
- Summary: A practical MongoDB aggregation pipeline guide with real production patterns for $match, $group, $lookup, $project, and performance-safe query design.
- Topics: Web Development, Web Development, Tips, Tips, Developer Experience, Developer Experience
- Keywords: Web Development, Web Development, Tips, Tips, Developer Experience, Developer Experience, Node.js, Node.js
- Tech: Node.js, Node.js

## Building a CLI Tool in Node.js: From Script to Publishable Package
- URL: https://brandonperfetti.com/articles/building-a-cli-tool-in-node-js-from-script-to-publishable-package
- Published: 2025-11-10T00:00:00.000Z
- Updated: 2026-08-22T21:04:46.008Z
- Summary: A practical Node.js CLI tutorial: structure commands, add prompts and color, wire the bin field, and publish a package people can actually install and use.
- Topics: Web Development, Backend, Developer Experience, Tools, Tips, Open Source
- Keywords: Web Development, Backend, Developer Experience, Tools, Tips, Open Source, Node.js, JavaScript, npm
- Tech: Node.js, JavaScript, npm

## Accessibility in React: The Quick Wins That Cover 80% of Issues
- URL: https://brandonperfetti.com/articles/accessibility-in-react-the-quick-wins-that-cover-80-percent-of-issues
- Published: 2024-09-16T00:00:00.000Z
- Updated: 2026-08-22T21:04:39.858Z
- Summary: A practical React accessibility guide with high-impact fixes for semantics, keyboard support, focus flow, and screen-reader usability.
- Topics: Accessibility, React, Frontend
- Keywords: Accessibility, React, Frontend, React, HTML, CSS, Browsers
- Tech: React, HTML, CSS, Browsers

## Designing a Design System in React: Tokens, Components, and What Actually Scales
- URL: https://brandonperfetti.com/articles/designing-a-design-system-in-react-tokens-components-and-what-actually-scales
- Published: 2025-09-01T00:00:00.000Z
- Updated: 2026-08-22T21:04:33.280Z
- Summary: A practical guide to building a React design system that scales: token strategy, component API design, governance, and rollout patterns that avoid UI entropy.
- Topics: Frontend Architecture, Design Systems, Developer Experience, Tips, Web Development
- Keywords: Frontend Architecture, Design Systems, Developer Experience, Tips, Web Development, React, TypeScript, CSS
- Tech: React, TypeScript, CSS

## Infinite Scroll vs Pagination: The Tradeoffs Nobody Tells You About
- URL: https://brandonperfetti.com/articles/infinite-scroll-vs-pagination-the-tradeoffs-nobody-tells-you-about
- Published: 2025-03-31T00:00:00.000Z
- Updated: 2026-08-22T21:04:27.333Z
- Summary: A practical comparison of infinite scroll and pagination across UX, SEO, analytics, and backend implementation tradeoffs.
- Topics: Infinite Scroll, Pagination, UX, SEO
- Keywords: Infinite Scroll, Pagination, UX, SEO, JavaScript, Intersection Observer API, Server-side Rendering (SSR), Keyset/Cursor Pagination
- Tech: JavaScript, Intersection Observer API, Server-side Rendering (SSR), Keyset/Cursor Pagination

## TypeScript Path Aliases: Clean Imports That Actually Work in Next.js
- URL: https://brandonperfetti.com/articles/typescript-path-aliases-clean-imports-that-actually-work-in-next-js
- Published: 2025-10-13T00:00:00.000Z
- Updated: 2026-08-22T21:04:20.296Z
- Summary: A practical guide to TypeScript path aliases in Next.js, including tsconfig setup, Jest and ESLint fixes, and the mistakes that cause alias imports to break.
- Topics: Web Development, Frontend, Developer Experience, Tips, TypeScript, Next.js
- Keywords: Web Development, Frontend, Developer Experience, Tips, TypeScript, Next.js, TypeScript, Next.js, Jest, ESLint
- Tech: TypeScript, Next.js, Jest, ESLint

## Building a Streaming AI Chat UI with AI SDK v5 and React
- URL: https://brandonperfetti.com/articles/building-a-streaming-ai-chat-ui-with-ai-sdk-v5-and-react
- Published: 2025-08-25T00:00:00.000Z
- Updated: 2026-08-22T21:04:13.428Z
- Summary: A practical guide to building streaming AI chat UIs with AI SDK v5, covering message lifecycle, tool-call rendering, and robust state handling.

## AI Tool Calls Explained: Giving Your LLM the Ability to Actually Do Things
- URL: https://brandonperfetti.com/articles/ai-tool-calls-explained-giving-your-llm-the-ability-to-actually-do-things
- Published: 2025-09-08T00:00:00.000Z
- Updated: 2026-08-22T21:04:07.113Z
- Summary: A practical guide to implementing AI tool calls with strong schemas, validation, retries, and production safety controls.
- Topics: AI, Developer Experience, Tools
- Keywords: AI, Developer Experience, Tools, AI SDK v5, function calling, Zod, Node.js
- Tech: AI SDK v5, function calling, Zod, Node.js

## TypeScript Strict Mode: Is the Extra Pain Worth It?
- URL: https://brandonperfetti.com/articles/typescript-strict-mode-extra-pain-worth-it
- Published: 2024-10-14T00:00:00.000Z
- Updated: 2026-08-22T20:36:11.377Z
- Summary: A practical rollout strategy for enabling TypeScript strict mode without freezing delivery, with high-ROI settings and migration sequencing.
- Topics: TypeScript, Type Safety, Developer Tooling, Code Migration, Static Analysis
- Keywords: TypeScript, Type Safety, Developer Tooling, Code Migration, Static Analysis, TypeScript, Node.js, React, ESLint
- Tech: TypeScript, Node.js, React, ESLint

## Zustand vs Redux vs Context: Choosing State Management That Won't Haunt You
- URL: https://brandonperfetti.com/articles/zustand-vs-redux-vs-context-choosing-state-management-that-wont-haunt-you
- Published: 2023-08-14T00:00:00.000Z
- Updated: 2026-08-22T20:36:04.604Z
- Summary: A practical comparison of Zustand, Redux, and React Context with real decision criteria, migration paths, and production pitfalls to avoid.
- Topics: Web Development, Tips, Developer Experience
- Keywords: Web Development, Tips, Developer Experience, React, Zustand (comparison)
- Tech: React, Zustand (comparison)

## Feature Flags in JavaScript: Ship Faster Without Breaking Things
- URL: https://brandonperfetti.com/articles/feature-flags-in-javascript-ship-faster-without-breaking-things
- Published: 2025-12-08T00:00:00.000Z
- Updated: 2026-08-22T20:35:58.559Z
- Summary: A practical guide to feature flags in JavaScript: safer releases, kill switches, gradual rollouts, and the implementation patterns that avoid long-term flag debt.
- Topics: Web Development, Developer Experience, Frontend, Backend, Tips
- Keywords: Web Development, Developer Experience, Frontend, Backend, Tips, JavaScript, Node.js, React, Next.js
- Tech: JavaScript, Node.js, React, Next.js

## Docker for Frontend Devs: Stop Being Scared of Containers
- URL: https://brandonperfetti.com/articles/docker-for-frontend-devs-stop-being-scared-of-containers
- Published: 2024-02-19T00:00:00.000Z
- Updated: 2026-08-22T20:35:52.024Z
- Summary: A practical Docker guide for frontend developers: build a clean Next.js container setup, run dev and prod confidently, and avoid common deployment traps.
- Topics: Web Development, Tips, Developer Experience, Frontend, Backend
- Keywords: Web Development, Tips, Developer Experience, Frontend, Backend, Docker, Next.js, Node.js
- Tech: Docker, Next.js, Node.js

## PostgreSQL Indexing Basics That Actually Matter for App Developers
- URL: https://brandonperfetti.com/articles/postgresql-indexing-basics-that-actually-matter-for-app-developers
- Published: 2024-04-15T00:00:00.000Z
- Updated: 2026-08-22T20:35:45.992Z
- Summary: A practical guide to PostgreSQL indexes for app developers: when to add them, how to read EXPLAIN ANALYZE, and how to avoid common indexing mistakes.
- Topics: Databases, Backend, Performance, Tips, Web Development
- Keywords: Databases, Backend, Performance, Tips, Web Development, PostgreSQL, SQL
- Tech: PostgreSQL, SQL

## Prisma + PostgreSQL: The Data Layer Setup I Use on Every Project
- URL: https://brandonperfetti.com/articles/prisma-postgresql-the-data-layer-setup-i-use-on-every-project
- Published: 2024-05-06T00:00:00.000Z
- Updated: 2026-08-22T20:35:39.726Z
- Summary: An opinionated Prisma + PostgreSQL setup guide covering schema design, migrations, seeding, service boundaries, validation, and production guardrails.
- Topics: Databases, Backend, Web Development, Tips, Developer Experience
- Keywords: Databases, Backend, Web Development, Tips, Developer Experience, Prisma, PostgreSQL, SQL, TypeScript, Node.js
- Tech: Prisma, PostgreSQL, SQL, TypeScript, Node.js

## PostgreSQL Full-Text Search: Good Enough to Replace Elasticsearch?
- URL: https://brandonperfetti.com/articles/postgresql-full-text-search-good-enough-to-replace-elasticsearch
- Published: 2025-02-03T00:00:00.000Z
- Updated: 2026-08-22T20:35:33.890Z
- Summary: A practical framework for deciding when PostgreSQL full-text search is enough and when Elasticsearch is actually worth the extra complexity.
- Topics: Backend, Databases, Developer Experience, Performance, Web Development
- Keywords: Backend, Databases, Developer Experience, Performance, Web Development, PostgreSQL, SQL
- Tech: PostgreSQL, SQL

## Reading Code You Didn't Write: Habits That Make It Faster
- URL: https://brandonperfetti.com/articles/reading-code-you-didnt-write-habits-that-make-it-faster
- Published: 2026-01-05T00:00:00.000Z
- Updated: 2026-08-22T20:12:44.137Z
- Summary: A practical guide to reading unfamiliar code faster: establish execution paths, map ownership boundaries, and make focused edits without introducing regressions.
- Topics: Web Development, Tips, Developer Experience, Productivity
- Keywords: Web Development, Tips, Developer Experience, Productivity, JavaScript, TypeScript, Git
- Tech: JavaScript, TypeScript, Git

## Strapi v4 Custom API: Building Endpoints Beyond the Generated CRUD
- URL: https://brandonperfetti.com/articles/strapi-v4-custom-api-building-endpoints-beyond-generated-crud
- Published: 2024-09-30T00:00:00.000Z
- Updated: 2026-08-22T20:12:35.733Z
- Summary: A hands-on guide to building custom Strapi v4 APIs with routes, controllers, policies, and middleware beyond generated CRUD.
- Topics: Strapi v4, Strapi v4, Custom APIs, Custom APIs, Backend, Backend
- Keywords: Strapi v4, Strapi v4, Custom APIs, Custom APIs, Backend, Backend, Strapi v4, Strapi v4, Node.js, Node.js, Koa, Koa
- Tech: Strapi v4, Strapi v4, Node.js, Node.js, Koa, Koa

## React 19 Actions: Finally a Clean Way to Handle Server Mutations
- URL: https://brandonperfetti.com/articles/react-19-actions-finally-a-clean-way-to-handle-server-mutations
- Published: 2024-12-09T00:00:00.000Z
- Updated: 2026-08-22T20:12:27.395Z
- Summary: A practical guide to React 19 Actions for cleaner server mutations, pending states, and optimistic UI without old loading-state boilerplate.
- Topics: React 19, Server Mutations, Optimistic UI
- Keywords: React 19, Server Mutations, Optimistic UI, React 19, React, Next.js 15, Hooks
- Tech: React 19, React, Next.js 15, Hooks

## Zod: The Validation Library That Changed How I Think About Data
- URL: https://brandonperfetti.com/articles/zod-the-validation-library-that-changed-how-i-think-about-data
- Published: 2025-06-23T00:00:00.000Z
- Updated: 2026-08-22T20:12:19.533Z
- Summary: A practical guide to Zod for API validation, forms, environment variables, transforms, and safer TypeScript workflows.

## Webhooks: Building Reliable Event Receivers in Node.js
- URL: https://brandonperfetti.com/articles/webhooks-building-reliable-event-receivers-in-node-js
- Published: 2025-10-27T00:00:00.000Z
- Updated: 2026-08-22T20:12:08.099Z
- Summary: A production-ready Node.js webhook guide covering signature verification, idempotency, queues, retries, and the patterns that keep event receivers reliable under real
- Topics: Web Development, Backend, Developer Experience, Tips, Security, Observability
- Keywords: Web Development, Backend, Developer Experience, Tips, Security, Observability, Node.js, Express, HTTP, crypto, BullMQ, ngrok
- Tech: Node.js, Express, HTTP, crypto, BullMQ, ngrok

## pgvector + PostgreSQL: Production-Ready Semantic Search Without a Vector DB
- URL: https://brandonperfetti.com/articles/pgvector-postgresql-production-ready-semantic-search-without-a-vector-db
- Published: 2026-02-28T00:00:00.000Z
- Updated: 2026-08-22T20:12:01.430Z
- Summary: A practical guide to shipping semantic search with pgvector in PostgreSQL, including schema design, indexing choices, retrieval quality controls, and production rollout
- Topics: AI, Backend
- Keywords: AI, Backend, TypeScript, Node.js, PostgreSQL, PGVector
- Tech: TypeScript, Node.js, PostgreSQL, PGVector

## Prisma Migrations in Production: The Zero-Downtime Playbook
- URL: https://brandonperfetti.com/articles/prisma-migrations-in-production-the-zero-downtime-playbook
- Published: 2025-08-04T00:00:00.000Z
- Updated: 2026-08-22T20:11:54.282Z
- Summary: A production-safe Prisma migration workflow for teams that need zero-downtime deploys, safer schema changes, and a repeatable rollback plan.
- Topics: Databases, Backend, Developer Experience, Deployment
- Keywords: Databases, Backend, Developer Experience, Deployment, Prisma, PostgreSQL, SQL, Node.js
- Tech: Prisma, PostgreSQL, SQL, Node.js

## Next.js 15 + Notion as CMS: Ditch the Git Deploy for Content Updates
- URL: https://brandonperfetti.com/articles/nextjs-15-notion-cms-ditch-git-deploy-content-updates
- Published: 2026-03-23T00:00:00.000Z
- Updated: 2026-08-22T20:11:46.966Z
- Summary: A practical guide to wiring Next.js 15 to Notion as a CMS so you can ship content updates without code deploys.
- Topics: Next.js, Web Development, Tools, Performance
- Keywords: Next.js, Web Development, Tools, Performance, Next.js, React, TypeScript, Node.js, Vercel
- Tech: Next.js, React, TypeScript, Node.js, Vercel

## Next.js App Router After a Year in Production: What I'd Tell My Past Self
- URL: https://brandonperfetti.com/articles/nextjs-app-router-after-a-year-in-production-what-id-tell-my-past-self
- Published: 2024-07-22T00:00:00.000Z
- Updated: 2026-08-22T20:11:39.743Z
- Summary: A practical year-in-production guide to Next.js App Router: what breaks, what scales, and the patterns that reduce incidents and rework.
- Topics: Web Development, Frontend, Developer Experience, Performance, Tips
- Keywords: Web Development, Frontend, Developer Experience, Performance, Tips, Next.js, React, TypeScript
- Tech: Next.js, React, TypeScript

## REST API Design Patterns That Make Your Node.js Backend a Joy to Work With
- URL: https://brandonperfetti.com/articles/rest-api-design-patterns-that-make-your-nodejs-backend-a-joy-to-work-with
- Published: 2023-08-28T00:00:00.000Z
- Updated: 2026-08-22T20:11:32.391Z
- Summary: A practical guide to REST API design patterns for Node.js that improve frontend developer experience, reliability, and long-term maintainability.
- Topics: REST API design, backend architecture, Developer Experience
- Keywords: REST API design, backend architecture, Developer Experience, Node.js, Express.js, TypeScript
- Tech: Node.js, Express.js, TypeScript

## Tailwind CSS v4: What Changed and How to Migrate
- URL: https://brandonperfetti.com/articles/tailwind-css-v4-what-changed-and-how-to-migrate
- Published: 2025-01-27T00:00:00.000Z
- Updated: 2026-08-22T20:11:25.281Z
- Summary: Tailwind CSS v4 migration guide for real projects: CSS-first config, token strategy, build updates, and a safe rollout plan that avoids regressions.
- Topics: Frontend, Web Development, Developer Experience, Tools, Tips
- Keywords: Frontend, Web Development, Developer Experience, Tools, Tips, JavaScript, TypeScript, Tailwind CSS
- Tech: JavaScript, TypeScript, Tailwind CSS

## Getting Started with Vercel AI SDK v5: The Patterns That Actually Stick
- URL: https://brandonperfetti.com/articles/getting-started-with-vercel-ai-sdk-v5-the-patterns-that-actually-stick
- Published: 2025-08-11T00:00:00.000Z
- Updated: 2026-08-22T20:11:17.937Z
- Summary: A practical introduction to Vercel AI SDK v5 patterns that hold up in production, from schemas and streaming to retries and observability.
- Topics: AI SDK v5, Developer Experience, Tool Integrations
- Keywords: AI SDK v5, Developer Experience, Tool Integrations, Vercel AI SDK v5, streamText, generateObject, tool calls
- Tech: Vercel AI SDK v5, streamText, generateObject, tool calls

## JavaScript Event Loop Demystified: What Senior Devs Know That Juniors Don't
- URL: https://brandonperfetti.com/articles/javascript-event-loop-demystified-what-senior-devs-know-that-juniors-dont
- Published: 2025-07-21T00:00:00.000Z
- Updated: 2026-08-22T20:11:10.991Z
- Summary: A practical mental model for the JavaScript event loop, microtasks, macrotasks, and why async code behaves differently than most developers expect.
- Topics: Web Development, Developer Experience, Performance
- Keywords: Web Development, Developer Experience, Performance, JavaScript, Browser, Node.js
- Tech: JavaScript, Browser, Node.js

## SQL Joins Explained Without the Venn Diagrams
- URL: https://brandonperfetti.com/articles/sql-joins-explained-without-the-venn-diagrams
- Published: 2025-11-24T00:00:00.000Z
- Updated: 2026-08-22T20:10:54.952Z
- Summary: A practical guide to SQL joins using real query patterns, performance tips, and debugging techniques that help joins finally click in production code.
- Topics: Databases, Backend, Tips, Web Development
- Keywords: Databases, Backend, Tips, Web Development, SQL, PostgreSQL
- Tech: SQL, PostgreSQL

Generated from live CMS data at https://brandonperfetti.com.