search

podverse / podverse-api

Data API, database migration scripts, and backend services for all Podverse apps
https://podverse.fm/about
GNU Affero General Public License v3.0
27 stars 15 forks source link

Drop Subtitle parsing #745

Open suorcd opened 3 months ago

suorcd commented 3 months ago

Sounds like the Apple podcast index does not parse this information. Reducing what is parsed would help with our load.

Once the field is not parsed we could drop the column in the episodes table.

mitchdowney commented 3 months ago

Ok...a couple years ago someone actually requested we put subtitle support in. If a subtitle is not available, our apps fallback to use description. Even though Apple and PI have deprecated it, I'm not entirely sure I want to drop it as long as some podcasts are using it. The idea is a subtitle is a shorter "description" which gets used in list views. I queried our database and there are ~37 million episodes with a value in the subtitle column.