PostgreSQL 15+ revokes CREATE from non-superusers in public schema by default.
Child 1's migration created the tables as postgres superuser, leaving the
txt_game_scores app user with no privileges — causing "permission denied"
on every request in production.
Adds a numbered provision migration to GRANT SELECT/INSERT/UPDATE on players
and games, plus USAGE/SELECT on games_id_seq, to the app user.
Task: d1c49d59-57bd-4eba-9e22-f25a04157ad4
Introduces a long-lived `pid` cookie (365 d) as persistent player identity
alongside the existing 24 h `sid` session cookie.
On first visit, a player row is upserted into `players`. On round end, a
transaction inserts into `games` and updates aggregates (best_attempts on wins
only, streak counters, last_played_at). DB failures are caught and logged —
the game keeps serving.
Adds a 3×2 'Your best' stats panel and a public top-10 scoreboard (fewest
best_attempts ASC, earliest last_played_at as tie-breaker; identifiers
truncated to 8 chars; current player highlighted).
Infrastructure: adds `pg` dependency, Dockerfile now installs npm deps before
copying server.mjs, docker-compose forwards all provisioned TXT_GAME_DB_*
vars and joins the postgres_postgres network for container-to-container reach.
Task: d1c49d59-57bd-4eba-9e22-f25a04157ad4
Wire in the txt_game_scores database provision and create the
players/games tables via a provision-scoped migration so Child 2
can implement the server-side score persistence.
- module.yml: requires postgres database (txt_game_scores) with
env_map for host/port/user/password/name; empty env keys added
so env-sync populates them after provisioning
- migrations/package.json: ESM, pg + typescript devdeps
- migrations/provision/postgres/000-init-scores.ts: creates
players and games tables with idempotent IF NOT EXISTS guards
and two supporting indexes (scoreboard sort, history lookup)
Server code, Dockerfile, and docker-compose.yml are unchanged —
server integration is deferred to the follow-on child task.
Task: 3dab55e3-9792-47a0-a4a6-ba7757517314
- Fix module.yml docker: section from object to list format so
the builder actually builds and pushes the image
- Replace build: . with registry image reference in compose
- Fix certresolver name from letsencrypt to le
- Add explicit container_name, remove unused default network
Number guessing game (1-100, 7 attempts) as a HAL custom-app module.
Serves HTML form UI with per-session state via cookie, no npm deps.
Traefik labels for txt.${DOMAIN} on websecure with letsencrypt TLS.
jschoubben
Warre (hal-developer)
HAL