Project Design?

[RayRCaringal]

Let's sort out how we're doing this for everyone, I'm making an issue since I keep having to repeat myself in the chat. We've established we're using C#, .NET, and PostgresSQL. I believe we're also making this a plugin/extension correct? It could also function as a website so let's decide that.

Anyways, how are we doing this, do we just tell the user whenever they come to a playlist like. "Yo this got deleted, it was titled [This Video]". Or do we just let them ask for specific videoes, like have them copy and paste the deleted video link into a field and then tell them "It was [This Video]"

If we take the 1st approach we could store a copy of the list and get what's difference right, but if we do the 2nd approach we don't need to store a copy of each playlist to see which is deleted, cause we're given the link so if the user uses multiple playlists, we can just store the video ID which is unique and then the title.

There's also the possibility that we might not even need to store anything in a DB, someone is exploring that tomorrow. I will get back with the results.

[austinbaccus]

We will be using the diff approach for this. If someone wants to keep track of their public playlist, they enter in the URL into our web app. If something from their playlist is deleted, they come back to our website and re-enter the URL. Our web app will bring up the old playlist and compare it with the current one. It will then make a list of all the missing videos and tell you the title of the ones that were deleted Get Outlook for iOS<https://aka.ms/o0ukef>

…

________________________________ From: RayRCaringal <[email protected]> Sent: Friday, March 20, 2020 10:19:59 PM To: covidterns/youtube-deleted-videos <[email protected]> Cc: Subscribed <[email protected]> Subject: [covidterns/youtube-deleted-videos] Project Design? (#1) Let's sort out how we're doing this for everyone, I'm making an issue since I keep having to repeat myself in the chat. We've established we're using C#, .NET, and PostgresSQL. I believe we're also making this a plugin/extension correct? It could also function as a website so let's decide that. Anyways, how are we doing this, do we just tell the user whenever they come to a playlist like. "Yo this got deleted, it was titled [This Video]". Or do we just let them ask for specific videoes, like have them copy and paste the deleted video link into a field and then tell them "It was [This Video]" If we take the 1st approach we could store a copy of the list and get what's difference right, but if we do the 2nd approach we don't need to store a copy of each playlist to see which is deleted, cause we're given the link so if the user uses multiple playlists, we can just store the video ID which is unique and then the title. There's also the possibility that we might not even need to store anything in a DB, someone is exploring that tomorrow. I will get back with the results. — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fcovidterns%2Fyoutube-deleted-videos%2Fissues%2F1&data=02%7C01%7C%7Cf4e0054cbd754642274308d7cd578134%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637203648021095521&sdata=dsZRT5iGINpw08Gp%2BcPu0Awn5OfLL%2Be5pjuZeZyaHNw%3D&reserved=0>, or unsubscribe<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FACO522T2QAGKX24EBJEJI2TRIRE77ANCNFSM4LQZOGKA&data=02%7C01%7C%7Cf4e0054cbd754642274308d7cd578134%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637203648021105526&sdata=zlZALnSbjVdvAlSSby7TdZoJDygb9tphVKynPy3Ngv8%3D&reserved=0>.

[saffaura]

If this were a browser extension, it would be cool if a user could just enter their youtube channel and the plugin would automatically scan their playlists and start mapping video ids to titles.

YouTube's api allows you to get the playlists for a channel or authenticated user:
https://developers.google.com/youtube/v3/docs/playlists/list

There's also more info about PlayListItems that contain the video title and video id:
https://developers.google.com/youtube/v3/docs/playlistItems

This could also be done server-side if it's just going to be a separate webpage.

Either way, the approach would be

• Determine if the api can retrieve all playlists for a given user
• Retrieve all PlayListItems from each playlist
• For each PlayListItem, insert the video id and video title pair into the database

I believe that the PlayListItem object can be explored further. There might be some flag in the object that indicates whether or not the video resource was deleted. If that is the case, and the videoId is still present in the object, it would be trivial to scan a playlist for deleted items and then retrieve the title mapping from the database.

Since the data being stored is fairly small (video ids are a max of 11 characters, video titles are a max of 100 characters), there shouldn't be much scalability required for a small pilot. If storage is a concern, we can limit the maximum playlist size and inform the user if their playlist exceeds the limit.