How psukawala-art/cinematch-movie-recommendation works
CineMatch is a learning prototype for recommending movies from a selected user’s highly rated genres. The user selects a sample account in the Streamlit app; on request, the app queries MySQL for unrated matching movies and displays the results. SQL files define and populate the database and provide queries. A separate Python module contains cosine-similarity and rated-movie exclusion helpers, but the sampled app does not call it; the README describes linear algebra as an extension. Connections shown are limited to those supported by the excerpts or README.
Main entry points: app.py Streamlit app · db.py MySQL access · 01_schema.sql Data schema · 02_sample_data.sql Sample data
Components 10
User interface
- Streamlit app
app.py
Recommendation logic
- Genre-based suggestions
app.py - Cosine similarity
src/recommender.py - Rated-movie exclusion
src/recommender.py
Data and storage
- MySQL access
src/db.py - MySQL database
- Data schema
sql/01_schema.sql - Sample data
sql/02_sample_data.sql - SQL queries
sql/03_queries.sql
Other components
- Movie viewer
Connections 7
- Movie viewer → Streamlit app: selects user
app.py - Movie viewer → Streamlit app: requests recommendations
app.py - Streamlit app → MySQL access: fetches rows
app.py - MySQL access → MySQL database: executes SQL
src/db.py - Streamlit app → Genre-based suggestions: runs query
app.py - Data schema → MySQL database: sets up schema
README.md - Sample data → MySQL database: loads sample data
README.md