Podcasting 2.0 - Episode 271: Foot Terminal
Episode 1 hr 31 min

Podcasting 2.0 - Episode 271: Foot Terminal

From Godcaster 2 KGOR Radio

Podcasting 2.0 Episode 271 - "Foot Terminal"

Adam & Dave have their SCBA's on and go deep into index refactoring and ad loads!

ShowNotes

-------------------------------------------------------------------------------------------------------------------------------------

00 - STEP TWO OF THE SCARY STUFF — THE ENDPOINTS FLIP TO THE IDENTITY LAYER

Last week the table went in. This week the API started using it — one endpoint at a time, four days running.

Sat 12 Sep: "#api I'm running a script to sync up podcasts.id and newsfeeds.id so that when a new feed is born they are in sync. During the cutover to podcasts.id as the canonical form, there were about 11k feeds that drifted away from being in sync with their podcast because of a gap in the auto_increment values. This isn't strictly necessary, it just will make human review a little less cumbersome."

Mon night 14 Sep: "#api Making some final refinements to the new api endpoints before deploying. These will be the first ones using the new podcast identity layer. "

Tue 15 Sep — the first flip: "#api The podcasts/byfeedurl endpoint is deployed with the first changes to the new podcast identity layer. We will do these one at a time, watching for problems. You will see nothing different in the response shape under normal circumstances. The response 'feed' object's `id` property now means the podcast ID. The `feedId` property now means the underlying feeds table row that podcast is treating as canonical."

@dave — byfeedurl flips (15 Sep)

"It's not ideal to have the podcast id be represented as feeds.id in the new responses, but anything else would have broken existing apps. And, the meaning is still faithful to what it was before. That was always meant to be the ID of the podcasts. We just didn't have a way to logically express that."

Same day: "#api The new podcasts/byfeedid endpoint is deployed. That's all for today. Will watch the logs until tomorrow." · "#api First run of the itunes ID 404 reconciler under the new podcast identity regime. "

Thu 17 Sep: "#api The podcasts/byguid and podcasts/batch/byguid endpoints are now flipped to the new db schema." · Fri 18 Sep, this morning: "#api The new podcasts/byitunesid endpoint is live."

@dave — byitunesid live (18 Sep)

The app developers noticed. Mitch (Podverse): "listening to last week's P2.0... the nextgen Podverse schema (and ogen) relies heavily on the Podcast Index IDs as basically the authority on feed uniqueness. It sounds like we may need/want to do a substantial rewrite to account for how Podcast Inde

Community discussion