How to identify an episode and podcast?

openpodcast / roadmap

🗺🎙 Project Roadmap and Milestones for Open Podcast

0 stars 0 forks source link

How to identify an episode and podcast? #80

Open woolfg opened 1 year ago

woolfg commented 1 year ago

We have to map the apple and spotify episode id to an internal unique id. All RSS fields can change.

woolfg commented 1 year ago

discussion between @mre and @woolfg

we just need to map the IDs once when there is no mapping, afterwards the ID shouldn't change again
the inital mapping can be done based on common fields (such as release time, title), which should be the same
this matching can be done in the API when an episode is received the first time

mre commented 1 year ago

Example implementation: https://gist.github.com/mre/48dff9ab3c846b692c35fce600baae7f

mre commented 1 year ago

As mentioned by @woolfg in https://github.com/openpodcast/api/issues/10, we should also change the naming form account_id to podcast_id. We can do this together with the rest of the tasks in this issue.

woolfg commented 1 year ago

current match algorithm using names is not working with account_id = 3, we have to look into it. it would be also good to store the last valid date in a table to be able to quickly access the latest valid data.