districtr-v2

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

Layer stack, sources, map types (district vs COI), style expressions, shatter filters

Map data lifecycle - imports, shatter setup, edges, graph linkage

MapLibre interaction model, feature-state, paint/shatter behavior

Tiles/tabular/transforms pipeline contracts and toolchain requirements

IDB/server sync, optimistic concurrency, and conflict resolution

GeometryWorker/ParquetWorker contracts and performance guardrails