Lab
Things I've built outside work just because it seemed fun.
Automated extraction and summarisation of lengthy YouTube podcasts using OpenAI Whisper, making long-form audio content easy to consume.
Problem
Long-form podcasts (1hr+) are hard to scan — most people give up before finding the parts they care about.
Solution
Transcribe with Whisper, identify the top 5 key segments, summarise — cutting ~8,000 words to ~1,250.
Result
84% reduction in OpenAI token usage; cost dropped from $0.21 to $0.03 per podcast.
PythonOpenAIWhisperNLPSummarisationA full-stack open-source issue tracker inspired by JIRA, built with Next.js and PostgreSQL, with Google OAuth and interactive dashboards.
Problem
Internal teams needed a lightweight, self-hosted issue tracker without JIRA's overhead and licensing cost.
Solution
Full-stack Next.js + PostgreSQL app with Google OAuth, interactive charts, and a clean issue management workflow.
Result
Fully functional, open-source, and deployable in minutes — production-quality auth and data visualisation included.
Next.jsPostgreSQLGoogle OAuthTypeScript