Pacilflix was a streaming-service-style web application built in a team of four using Django and PostgreSQL. I owned the tayangan module, covering catalog browsing, title and episode details, search, reviews, watch history, downloads, and favorite-list interactions.
I implemented parameterized raw SQL using joins, common table expressions, aggregation, and window ranking. This connected the user-facing features to the relational schema, including popularity rankings calculated over rolling seven-day viewing windows.