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
Art der Arbeit
Bachelor Thesis
Auftraggebende
Fachhochschule Nordwestschweiz, Brugg-Windisch
Autorinnen und Autoren
Philipp Hutter
Betreuende Dozierende
Richards, Bradley
Publikationsjahr
2025
Sprache der Arbeit
Englisch
Vertraulichkeit
öffentlich
Studiengang
Business Information Technology (Bachelor)
Standort Studiengang
Basel
Keywords
SQL Scrolls, Docker, Javascript, Repository, GitHub, Public Release