How martinl5/sqlwak works
SQLwak is a client-side SQL learning game: players choose progressively harder banking and maritime challenges, write and run read-only SQL against a seeded SQLite database, then submit queries for grading and persistent progression. The game shell coordinates the editor, schema and results views, navigation, onboarding, and harbour visuals. Challenge content spans four tiers; progression calculations and persisted game state support ranks, XP, and the ship-themed display. Relationships reflect the README and indexed imports; unsampled validator and UI internals are not inferred beyond those references.
Main entry points: GameProvider.tsx Game shell · useGameStore.ts Game state · index.ts Challenge catalog · progression.ts XP and rank rules
Components 24
Game experience
- Game shell
src/components/GameProvider.tsx - SQL editor
src/components/SQLPanel.tsx - Schema viewer
src/components/SchemaViewer.tsx - Results preview
src/components/DataPreview.tsx - Level navigator
src/components/LevelNavigator.tsx - Progress map
src/components/LevelProgressMap.tsx - Onboarding
src/components/OnboardingOverlay.tsx - Level-up display
src/components/LevelUpModal.tsx - Rank banner
src/components/RankPromotionBanner.tsx - Harbour visuals
src/components/FlockCanvas.tsx - Harbour status
src/components/FlockStatus.tsx
SQL challenges
- Foundational levels
src/data/levels/foundational.ts - Intermediate levels
src/data/levels/intermediate.ts - Advanced levels
src/data/levels/advanced.ts - Expert levels
src/data/levels/expert.ts - Challenge catalog
src/data/levels/index.ts
Query runtime
- Query validator
src/lib/validator.ts - SQLite database
src/lib/db.ts - Bank data seeder
src/lib/seed.ts - Read-only runner
src/lib/sqlRunner.ts
Progression state
- XP and rank rules
src/lib/progression.ts - Game state
src/store/useGameStore.ts - Shared types
src/types/index.ts
Other components
- Player
Connections 37
- Player → Game shell: starts game
README.md - Game shell → SQLite database: initializes
src/components/GameProvider.tsx - Game shell → SQL editor: renders
src/components/GameProvider.tsx - Game shell → Schema viewer: renders
src/components/GameProvider.tsx - Game shell → Results preview: renders
src/components/GameProvider.tsx - Game shell → Level navigator: renders
src/components/GameProvider.tsx - Game shell → Progress map: renders
src/components/GameProvider.tsx - Game shell → Onboarding: renders
src/components/GameProvider.tsx - Game shell → Level-up display: renders
src/components/GameProvider.tsx - Game shell → Rank banner: renders
src/components/GameProvider.tsx - Game shell → Harbour visuals: loads
src/components/GameProvider.tsx - Game shell → Harbour status: renders
src/components/GameProvider.tsx - SQL editor → Challenge catalog: selects challenge
src/components/SQLPanel.tsx - SQL editor → SQLite database: executes query
src/components/SQLPanel.tsx - SQL editor → Query validator: grades query
src/components/SQLPanel.tsx - SQLite database → Bank data seeder: seeds tables
src/lib/db.ts - SQLite database → Read-only runner: runs statement
src/lib/db.ts - SQLite database → SQL editor: returns results
src/components/SQLPanel.tsx - Results preview → Game state: reads results
src/components/DataPreview.tsx - Challenge catalog → Foundational levels: combines tiers
src/data/levels/index.ts - Challenge catalog → Intermediate levels: combines tiers
src/data/levels/index.ts - Challenge catalog → Advanced levels: combines tiers
src/data/levels/index.ts - Challenge catalog → Expert levels: combines tiers
src/data/levels/index.ts - XP and rank rules → Challenge catalog: derives rank rules
src/lib/progression.ts - Game state → XP and rank rules: calculates XP
src/store/useGameStore.ts - Level navigator → Game state: updates level
src/components/LevelNavigator.tsx - Level navigator → Challenge catalog: lists levels
src/components/LevelNavigator.tsx - Progress map → Game state: reads progress
src/components/LevelProgressMap.tsx - Progress map → XP and rank rules: uses ranges
src/components/LevelProgressMap.tsx - Level-up display → Game state: reads progress
src/components/LevelUpModal.tsx - Level-up display → XP and rank rules: uses rank rules
src/components/LevelUpModal.tsx - Onboarding → Game state: reads state
src/components/OnboardingOverlay.tsx - Onboarding → XP and rank rules: uses progression
src/components/OnboardingOverlay.tsx - Harbour visuals → Game state: reads fleet
src/components/FlockCanvas.tsx - Harbour visuals → XP and rank rules: uses ship rules
src/components/FlockCanvas.tsx - Harbour status → Game state: reads status
src/components/FlockStatus.tsx - Harbour status → XP and rank rules: uses rank rules
src/components/FlockStatus.tsx