Podcasting 2.0 - Episode 272: "Is this Y'all?"

00 - ️ THE SCHEMA IS LIVE — AND THEN THE AGGREGATORS PICKED A FIGHT

Dave has already told us this one is his: "Will explain in the board meeting tomorrow."

Mon 22 Sep — the cutover lands: "#api All api endpoints are now live with the new database schema. Bug reports welcome. I'm tired. "

@dave — all endpoints live on the new schema

Tue 23 Sep — and now the real work: "Now comes the post-deploy quality testing of the Index as a whole. Now that we have an audit trail for every feed we will need to walk every podcast in the Index to see where it stands and what metadata needs reconciling."

New tables in the dump: "@js There are new tables in the ndjson dump now. " · "@js You're the guinea pig. Let me know if anything looks off."

On breakage, to Mitch (Podverse): "Any additional parameters should be additive. The overall shape of the response should not change. There *shouldn't* be any breakage unless the client is doing a Rust style strict type coercion. But, I wouldn't expect that to be common since JSON is fragile."

Thu 24 Sep — the brawl, in four posts:

12:10 — "#api Adding 2 new indexes on the feeds table. Expect the api to choke for a few minutes until this completes."

14:38 — "#api All out brawl with the feed aggregators this morning. I'm about to win though."

17:08 — "Battle is over. The war is ongoing."

20:02 — "#api I fixed a huge problem with the feed aggregators. Based on this snapshot of our database metrics, can you guess at roughly what time that happened?" · 20:03 — "Network throughput up. CPU and disk rate down. It's a win-win."

The question for Dave: what were the aggregators actually doing — hammering the feeds, or something subtler that the new audit trail made visible for the first time? And what did the two indexes fix?

19:13 — the bug he flagged for today: "#api There was a problem with search ranking in the search/byterm endpoint after switching the db schema. This should be fixed now. Will explain in the board meeting tomorrow."

Loose end: @ChadF, 24 Sep — "@dave looks like podcaster wallet is returning the old node address." Not visibly answered yet.

Also closed this week: docs-api #160, "BUG: Wrong season number in some episodes" — season 14 coming back as 4.

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

01 - GUEST: SAM SETHI — TRUEFANS, A