ayoub/nerdware
1
0
Fork 0
Code Issues Pull requests Projects Releases Packages Wiki Activity Actions

feat(server): Drizzle + PostgreSQL schema + Open Trivia DB seed #5

Merged
ayoub merged 1 commit from feature/quiz-db into dev 2026-06-10 10:34:05 +00:00
Conversation 0 Commits 1 Files changed 18 +950 -26
ayoub commented 2026-06-10 10:33:43 +00:00
Owner
Copy link
  • Drizzle (postgres-js) setup: schema (quiz_category, quiz_question,
    quiz_played, game_history), client (nullable — no DATABASE_URL → null),
    drizzle.config, initial migration, migrate script
  • Open Trivia DB seed: curated geek categories, mcq + truefalse, base64
    decode (incl. type/difficulty), 1 req/5s rate limit, idempotent
    (prompt unique); also seeds the FR in-code bank as source 'manual'
  • quiz wired to the DB: per-room pool preloaded at game start (loadQuizPool
    excludes already-played), records quiz_played for cross-session
    anti-repeat; falls back to the in-code bank when no DB
  • docker-compose for local Postgres; db:* scripts; DATABASE_URL in env

Roadmap V1 step 5. Verified against a real Postgres: migrate + seed (270
OpenTDB + 10 manual), DB-backed game serves OpenTDB questions and fills
quiz_played; no-DB fallback still serves the in-code bank.

Co-Authored-By: Claude Opus 4.8 (1M context) noreply@anthropic.com

- Drizzle (postgres-js) setup: schema (quiz_category, quiz_question, quiz_played, game_history), client (nullable — no DATABASE_URL → null), drizzle.config, initial migration, migrate script - Open Trivia DB seed: curated geek categories, mcq + truefalse, base64 decode (incl. type/difficulty), 1 req/5s rate limit, idempotent (prompt unique); also seeds the FR in-code bank as source 'manual' - quiz wired to the DB: per-room pool preloaded at game start (loadQuizPool excludes already-played), records quiz_played for cross-session anti-repeat; falls back to the in-code bank when no DB - docker-compose for local Postgres; db:* scripts; DATABASE_URL in env Roadmap V1 step 5. Verified against a real Postgres: migrate + seed (270 OpenTDB + 10 manual), DB-backed game serves OpenTDB questions and fills quiz_played; no-DB fallback still serves the in-code bank. Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
ayoub added 1 commit 2026-06-10 10:33:44 +00:00 
- Drizzle (postgres-js) setup: schema (quiz_category, quiz_question,
  quiz_played, game_history), client (nullable — no DATABASE_URL → null),
  drizzle.config, initial migration, migrate script
- Open Trivia DB seed: curated geek categories, mcq + truefalse, base64
  decode (incl. type/difficulty), 1 req/5s rate limit, idempotent
  (prompt unique); also seeds the FR in-code bank as source 'manual'
- quiz wired to the DB: per-room pool preloaded at game start (loadQuizPool
  excludes already-played), records quiz_played for cross-session
  anti-repeat; falls back to the in-code bank when no DB
- docker-compose for local Postgres; db:* scripts; DATABASE_URL in env

Roadmap V1 step 5. Verified against a real Postgres: migrate + seed (270
OpenTDB + 10 manual), DB-backed game serves OpenTDB questions and fills
quiz_played; no-DB fallback still serves the in-code bank.

Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
ayoub self-assigned this 2026-06-10 10:33:53 +00:00
ayoub merged commit 0c940fd447 into dev 2026-06-10 10:34:05 +00:00
ayoub deleted branch feature/quiz-db 2026-06-10 10:34:05 +00:00
Sign in to join this conversation.
Reviewers
No reviewers
Labels
Clear labels
No items
No labels
Milestone
Clear milestone
No items
No milestone
Projects
Clear projects
No items
No project
Assignees
Clear assignees
No assignees
ayoub
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference: ayoub/nerdware#5
No description provided.
Delete branch "feature/quiz-db"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?