summaryrefslogtreecommitdiff
path: root/schema/schema.sql
AgeCommit message (Collapse)AuthorFilesLines
34 hoursfeat: fetch Wikipedia article titles via Wikidata SPARQLdev1-1/+0
- Query Wikidata SPARQL in batches of 30 for entries missing wiki_article - Store wiki_article title in imdb table - Respect rate limits with configurable delay and retry on 5xx/429 - Skip entries that have no Wikipedia article - Removed unique constraint on wiki_article (multiple entries can share one)
3 daysfeat: adapt genre code for n:m relation via imdb_genredev1-6/+44
- genre table: (id, name) with unique name constraint - imdb_genre table: (id, imdb_id, genre_id) junction table - Upsert genres via INSERT ... ON DUPLICATE KEY UPDATE - Link via imdb_genre using LAST_INSERT_ID - Check missing genres via LEFT JOIN imdb_genre
3 daysInitial commitdev1-0/+113