page:blueprints:sports clubs:event registration:next js

Sports clubs: event registration using Next.js

Summary

A event registration blueprint for sports clubs built with Next.js on Ample. Domain schema: course_groups (team_or_class, season, age_group): teams and classes; memberships (course_group_id, member_reference, guardian_reference, role): players, guardians and coaches; sessions (course_group_id, starts_at, venue, type): training and fixtures; materials (course_group_id, title, object_key, visibility): schedules and coaching resources; events (seq, record_type, record_id, kind, at): application-owned history written in the same transaction. Public information: teams, seasons and fixtures, venues, membership fees. Kept out of scope until handling is reviewed: minor members and medical notes, safeguarding records. Medical and safeguarding records are sensitive; only schedules and coaching materials are modeled. Technical basis verified on Next.js: an optimistic version check and an event row written in the same transaction, a stale update rejected, and a history query over the application-owned events (history=2 conflict=rejected).

Representative Queries

Resource Requirements

Infrastructure Requirements

  1. Compute
    • Status: verified
    • Summary: Apps run in isolated x86_64 Firecracker microVMs that auto-pause when idle and wake on request; sizes are the priced VM sizes.
  2. Postgres
    • Status: verified
    • Summary: Managed PostgreSQL 16 runs in its own microVM and is auto-provisioned when an app needs a database and no DATABASE_URL is supplied.
  3. S3-compatible object storage
    • Status: verified
    • Summary: Buckets are S3-compatible with issued credentials; PutObject and GetObject are verified by canary. Other S3 operations are not verified.

Workflow Steps

  1. Model the sports clubs domain
    Create the tables course_groups, memberships, sessions, materials, events. Teams and classes lives in course_groups; keep the sensitive classes (minor members and medical notes, safeguarding records) out of this schema.
  2. Workflow step 1
    Model sessions with capacity and registrations with status.
  3. Workflow step 2
    Register transactionally with a capacity check and an event per registration.
  4. Workflow step 3
    Reject stale concurrent updates.
  5. Workflow step 4
    Deploy and verify history and conflict handling.
  6. Deploy
    Run the synchronous deploy once and read the result. Re-running with no change is a no-op.
  7. Verify
    Run the pattern self-test(s) from the example (/p/transactional-workflows) and your own acceptance checks for the sports clubs workflow.

Limitations

Cost Estimate

Evidence Summary

Next Actions