Finding and rearranging scheduled tracks.
Give curators more control over their selections.
Where this work fits
A song can still be playing when an advert or prayer is due. The player needs to know what takes priority, where to stop, and where to resume. Station changes and the venue’s local time add more boundaries to that same day.
I built tempo filtering and tools for placing tracks in a schedule. Filters could accept values and ranges. When two track positions were swapped, transactional updates kept the exchange together while preserving the surrounding schedule positions.
Find the records that need attention
Start on time without losing the song.
Giving an interruption priority solves only half the problem. I also had to preserve how much of the track had played, resolve conflicts between interruptions, and align what came next. Time-zone handling kept those decisions tied to the venue’s day.
The skills behind the work
- SQL
- Query and update relational data, with clear rules about which records a result represents.
- Transactions
- Save related changes together, or roll them back together when a step fails.
- Query filtering
- Narrow records to the information a person is trying to find.
Scheduling errors fell, and interrupted tracks could continue from their saved position. Operators gained more control over when content played and how it fit into the rest of the schedule.