01
Google Summer of Code '26
Sugar Labs · Music Blocks · Remote
Building a Git-based backend for Music Blocks so thousands of creative coding projects can move from a legacy MySQL store into durable, searchable GitHub-backed repositories with ownership, history, and room to grow.
- Designed the migration path for 10,000+ user projects from MySQL to GitHub with persistent version history and ownership.
- Built a streaming migration pipeline that processes projects in under 5 seconds each with in-memory transformation and resumable checkpointing.
- Engineered a SQLite + REST API layer that brings search and retrieval latency from roughly 200ms via GitHub API reads to under 1ms locally.
- Designed around GitHub's 5,000 req/hr API limits by offloading read-heavy browsing and search to SQLite across 10K+ repositories.
- Implemented SHA-256 deduplication to eliminate redundant storage and improve migration efficiency.
- Developed 7+ production-grade endpoints for search, browse, like, and publish flows while preserving legacy feature parity.