PakTV Guide — TV Schedule & EPG

Full-Stack (Next.js + MySQL)

About

Electronic Program Guide (EPG) for Pakistani TV channels with automated web scraping — Next.js 14 frontend displaying weekly schedules aggregated from multiple channel websites via Cheerio and Puppeteer.

My Role

Built the full platform: Next.js 14 frontend with responsive schedule grid, MySQL backend for program data, and automated scraping pipeline using Cheerio + Puppeteer to aggregate schedules from channel websites.

Core Capabilities

• Automated web scraping of TV channel schedules
• Weekly program grid with time-based navigation
• Multi-channel schedule aggregation in one place
• Search and filter by channel, show, or time
• Responsive design for mobile and desktop
• Scheduled scraping jobs for data freshness

Architecture

• Next.js 14 with React 18 and TypeScript
• MySQL database for program schedule storage
• Cheerio for HTML parsing of channel websites
• Puppeteer for JavaScript-rendered page scraping
• Cron jobs for automated schedule updates

Tech Stack