SQLAlchemy-first DB patterns, Alembic migrations, ParentChildEdges partition handling, and UDF policy
FastAPI + SQLModel conventions, request dependencies, transaction safety, and backend architecture
Next.js best practices - RSC boundaries, data patterns, async APIs, error handling, route handlers, directives, runtime selection
Upgrade Next.js to the latest version following official migration guides and codemods
Auth0 scopes, recaptcha verification, and share/edit token security patterns
CMS editing/review workflows, TipTap extensions, and comment moderation
docker-compose topology, env files, local container workflows, and quality-gate commands
Frontend architecture, Zustand stores, map-first conventions, and subscription model