Creating a public release of SQL Scrolls on GitHub
This thesis created a new open-source release of the SQL Scrolls learning game by merging two advanced feature branches, modernizing and unifying the frontend and backend stack, and improving documentation to enhance accessibility for institutions and external contributors.
Philipp Hutter, 2025
Art der Arbeit Bachelor Thesis
Auftraggebende Fachhochschule Nordwestschweiz
Betreuende Dozierende Richards, Bradley
Views: 15
SQL Scrolls, an FHNW-developed SQL learning game, existed in two separate code branches: one with leaderboard-based gamification, another with AI-driven adaptive task recommendations. Both had new features but suffered from an outdated, complex architecture and were split into separate repositories, requiring manual combination for deployment.
Using an agile-inspired hybrid project management approach, both branches were merged into a single repository. Modernization included ES6+ syntax, npm-managed dependencies, Docker container orchestration, and updated documentation. Student feedback guided usability improvements, and additional books and tasks were integrated.
The project delivered a full-stack, modernized public release of SQL Scrolls on GitHub, unifying gamification and AI-driven task recommendation features. The repository quality improved through refactoring, dependency upgrades, and removal of legacy components. Deployment was simplified via a unified architecture, enhanced documentation, and quick-start guides for multiple platforms. The overhauled structure integrates improvements from previous feature branches and supports long-term maintainability. Educational content was expanded with new themed books and 25 additional tasks. This release is ready for community contributions and adoption.
Studiengang: Business Information Technology (Bachelor)
Keywords SQL Scrolls, Docker, Javascript, Repository, GitHub, Public Release
Vertraulichkeit: öffentlich