CGMDB
The definitive open digital archive, relational database, and discovery platform for Chhattisgarhi cinema (Chhollywood) and folk media.
Overview
CGMDB (Chhattisgarhi Movie Database) is an open-source, comprehensive digital archive and relational catalog dedicated to preserving and organizing the cinema, talent, and cultural media of Chhattisgarh (Chhollywood). It acts as a single source of truth indexing hundreds of films, thousands of artist profiles, folk music categories, and multimedia assets.
The Problem
Regional cinema in India—particularly Chhollywood—often lacks structured, accessible metadata on global platforms like IMDb or TMDb. Critical filmographies, lyrics, crew credits, and traditional folk song archives remain scattered across legacy forums, outdated blogs, and unindexed web pages, risking digital decay.
Technical Solution & Pipeline
- Automated Data Extraction & ETL: Engineered high-throughput web crawlers and scraping pipelines in Python using
requests,BeautifulSoup, and regex-based fuzzy extractors to parse and normalize unstructured legacy content into clean schema objects. - Relational Data Modeling: Built a normalized PostgreSQL schema managed with Prisma ORM to map complex many-to-many relationships (actors, directors, producers, singers, movies, and tracklists).
- Modern Web Architecture: Designed a fast, SEO-optimized web application utilizing Next.js (App Router, Server Components) with dynamic OpenGraph generation and JSON-LD structured data for discovery.
Key Features
- Bi-Directional Talent Mapping: Connects film titles directly to artist filmographies and crew roles.
- Cultural & Folk Archival: First-class indexing of regional music traditions (Panthi, Jas Geet, Karma Geet, Sua Geet).
- Multimedia Integration: Direct cataloging of embedded trailers, video IDs, and high-resolution production stills.
- Taxonomy & Discovery: Multi-faceted filtering across release years, genres, traditional audio formats, and artist occupations.
Tech Stack
- Frontend & API: Next.js, React, Tailwind CSS
- Database & ORM: PostgreSQL, Prisma ORM
- Data Engineering: Python, BeautifulSoup4, Requests, Regex