YouTube Video Indexer

Rationale

Keep a lightweight local DB table of metadata about our YouTube videos for quick searchability. This could become partially integrated into the CMS's overall content view.

Trigger

Whenever a new video is uploaded to YT, log in to Ubyssey site and hit button to auto-update this database? Can we automate this with some kind of hook?

API Fields

Fields needed from each videos resource retrieved from the YouTube Data API v3:

• id (unique video ID; should be the ID param in YT video URLs as well)
• snippet.publishedAt (ISO 8601 YYYY-MM-DDThh:mm:ss.sZ)
• snippet.channelId (include this in case we want to add videos from a non-Ubyssey channel in future?)
• snippet.title
• snippet.description