Perfect project, part two

Along with the nifty new features for the public-facing web site, ably explained by Patrick Cooper, last week we also pushed out a major update to the database schema that represents stories and their audio, along with their relationships to programs and their individual episodes. In radio-speak, the ordered segments of a broadcast are called the rundown, and the remodeling of how a rundown is stored was at the core of this past project. We can now handle rebroadcasts for shows like TED Radio Hour (like here, here, and here) without behind-the-curtain hackery.

We also caught up on MySQL versions, and enabled limited concurrent editing of stories by multiple editors.

This was the biggest effort since the massive redesign of 2009, and I am proud to have been a part of it.