Audio Submission & Community Campaign Platform

The client needed a reliable platform to collect audio submissions for a national music competition, alongside the ability to track and analyse campaign engagement across their community network - without manual database access.

We built a full-stack application on Cloudflare Workers with R2 for audio file storage and D1 as the relational database for entrant data. The upload endpoint handled form data with server-side validation of the users input, before streaming files into R2 and persisting submission metadata to D1.

Alongside the platform, we built a reporting toolkit using Wrangler and Python that queried the live D1 database via npm scripts, producing structured CSVs around the users engagement with the site.

• Integrated a system to store audio files in Cloudflare R2 and entrant data in Cloudflare D1, while using Cloudflare workers to process submissions
• On-demand access to engagement metrics via CSVs

In partnership with Hotseat Agency