Vote

Audience vote for the Indie Awards of Stunfest, the video game festival in Rennes, France. Visitors at the stand scan a QR code on a big screen and vote for their favourite games in the competition.

• Voting needs physical presence: the QR code on the Host Screen changes every 10 s and only works for 20 s after it is shown. Opening it grants a Ballot good for one Vote within 3 minutes (why).
• Approval voting: each Vote picks up to 5 games the visitor liked; Results count Picks per game (why).
• Organisers open and close voting, follow live Results, and Reveal them publicly at the ceremony.
• Interface in French and English (from the phone's language, with a FR/EN switch).

The look follows the festival's 2026 identity on stunfest.com; colours and fonts are defined once in src/layouts/Base.astro. Domain vocabulary is in CONTEXT.md. Built with Astro on Cloudflare Workers and D1 (why).

Pages

Path	Who	What
/	Public	Holding page, then Results after the Reveal
/vote/<token>	Visitors	Target of the QR code: exchanges a fresh code for a Ballot
/vote	Visitors	Pick a game and vote
/login	Organisers	Shared organiser password
/host	Organisers	Host Screen with the rotating QR code
/admin	Organisers	Voting Status, Reveal, live Results

Development

npm install
cp .dev.vars.example .dev.vars
npm run db:migrate:local
npm run dev

Log in at http://localhost:4321/login with the ORGANISER_SECRET from .dev.vars, open voting on /admin, then open /host. In development the Host Screen shows a clickable vote link under the QR code.

npm test         # unit tests
npm run check    # type check

New edition

1. Add src/data/editions/<year>.json (copy the previous one). Each Game needs a unique kebab-case id; exactly one Category has "voting": true.
2. Put each Game's image at public/<year>/<id>.jpg.
3. Set ACTIVE_EDITION in wrangler.jsonc to <year>.
4. Change the organiser password: npx wrangler secret put ORGANISER_SECRET.

Votes are stored per Edition, so previous Results are kept.

Votes cast while rehearsing count towards the active Edition. Before the festival opens, clear them:

npx wrangler d1 execute DB --remote --command "DELETE FROM votes WHERE edition = '2026'"

Deployment (Cloudflare)

The Worker runs on the Indie Collective Cloudflare account (account_id in wrangler.jsonc) with a D1 database stunfest-vote (Western Europe). Secrets are set with:

npx wrangler secret put ORGANISER_SECRET
npx wrangler secret put SIGNING_KEY    # long random string, e.g. `openssl rand -base64 48`

Every push to master is built and deployed by Cloudflare Workers Builds (configured in the Cloudflare dashboard, not in this repo). Its settings should be:

Setting	Value
Build command	npm run build
Deploy command	npx wrangler d1 migrations apply DB --remote && npx wrangler deploy
Root directory	/

The deploy command applies any new files in migrations/ before the new code goes live. Migrations must stay backwards compatible with the version still running (add columns or tables, don't rename or drop them in the same release).

To deploy by hand instead (e.g. a hotfix):

npm run db:migrate:remote
npm run deploy

The app is served at https://vote.indieco.xyz (a Cloudflare Custom Domain on the Worker), with https://stunfest-vote.indiecollective.workers.dev kept as a fallback address.

Changing SIGNING_KEY logs out all organisers and invalidates open Ballots.