122 karma · joined June 22, 2020
Playful stance is ok as long as it covers fundamental questions but a business should err on the side of caution. Maybe I am old.
The architecture is dead simple. Multiple times a week IMDb publishes bare bones datasets. I've a bash script to download them, format and load into MySQL from which I export two types of json files:
1) a file with all the TV shows names, id, ratings etc (shows.json) - this is what's used for search. It weighs 2MB compressed and I could certainly optimize but considering the low traffic I've stashed it for later time.
2) A file for every tv show with all the ratings and votes for its episodes. Based on your search, the specific file will be fetched to display ratings. This one file per show could also be optimized but looks premature at this stage.
You can see them here: https://github.com/dvnlgls/theshowgrid/tree/gh-pages/assets
Strictly speaking, a database is also not necessary but it serves 2 purposes: 1) I could query easily to satisfy some curious show related questions. 2) The datasets include a ton of stale data (like shows w/o episodes and vice versa), so I find it easier to cleanup through SQL.
I built it mainly for personal use. I know IMDb ratings aren't perfect but it's a decent measure of mass opinion.
However, I'd be down to see ads if they're, say, relevant (things I'm actually interested in) 90% of the time. I thought about having a system where I could voluntarily say what I'd like to see in ads (obviously stuff I'm comfortable letting others know eg: sw, t-shirts, etc) - sort of like subscribing to RSS feed. Maybe advertisers could have a button on their site that I could click to let them know I'm interested in promotions, new releases etc. I imagine those advertisers could be part of an ad network I'd whitelist. I could see this as a win-win, though I don't want to think I'm the only one to think of this. Maybe those in the industry feel status quo is the best at scale.
I know, how something _sounds_ is subjective but I was thinking something along the lines of how Shazam app does. If they can compute a song signature and compare it against a library, it should be possible(?) to find top 10 closest neighbors.
BTW, I'd love to test your app if that's possible.