Skip to content

Deployment: D1 database, DNS routing, leaderboard API #10

@scottmccarrison

Description

@scottmccarrison

Description

Production infrastructure: D1 database, worker deployment, DNS routing, leaderboard.

Acceptance Criteria

  • D1 database minigolf created via wrangler
  • Schema: scores table with name, score (total strokes), course_par, created_at
  • GET /api/leaderboard - top 10 scores (lowest strokes)
  • POST /api/score - submit { name, score, coursePar }
  • Worker deployed via npx wrangler deploy
  • Static assets rsynced to /var/www/mini-golf
  • Cloudflare routes mccarrison.me/golf and mccarrison.me/golf/* to golf-api worker
  • Dev environment at mccarrison.me/golfdev with separate D1
  • Client-side leaderboard on gameover screen (js/leaderboard.js)
  • Auto-submit score after completing all 9 holes (if name set)
  • Feedback endpoint POST /api/feedback

Files

worker/src/index.js, worker/schema.sql, js/leaderboard.js, deploy.sh

Dependencies

Issues #1, #6, #7

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or request

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions