Git backend for Music Blocks Part 2
Music Blocks students have no ownership of the projects they create. When a project is saved it lands in a MySQL database they can never see, with no version history and no guarantee it will exist next year. This project completes the migration from that aging PHP and MySQL stack to a modern system backed by GitHub and SQLite, making the transition completely invisible to students while giving every project a permanent, version-controlled home. The work happens in four phases. First, setting up the migration environment with a read-only database connection, GitHub App credentials, and a SQLite database that will power the new backend. Second, running a streaming migration pipeline that processes all 10,000+ existing Planet projects one at a time, pushing each one to GitHub as a repository with full metadata and thumbnail, while skipping duplicates using SHA-256 content hashing. Third, building the seven API endpoints the Planet frontend needs to browse, search, like, and load projects, all backed by SQLite for sub-millisecond response times. Fourth, connecting the frontend to the new backend through a single drop-in adapter file, overhauling the UI with proper modals, a clean commit history timeline, and an interactive Git onboarding walkthrough that teaches students how to save versions, go back in time, and fork projects using Music Blocks language with no Git jargon.
Project details
Technologies
Not listed in the archive