Wisdom

Proper handling of incoming data is on you, even after years

Quote

Now, proper handling of incoming data is, I mean, this is purely on me for the second time in about three weeks, I've, I've completely borked in my responsibilities as a pro as, as a diligent, uh, RSS aggregator developer

Episode 233: Daniel J Lewis in a Can (episode page, opens in a new tab) 00:22:28 (play audio from this timestamp, opens in a new tab)

Voice-matched

Summary

An iTunes author tag over 2,048 characters broke ingestion in code that had run fine for years. Dave takes full blame: for the second time in three weeks (after a missing index on the soundbites table), he'd failed as a diligent aggregator developer by not truncating incoming data. Never trust that it 'has never happened'.

Also said

  1. Episode 229: DataBase Story Time (episode page, opens in a new tab) 01:18:27 (play audio from this timestamp, opens in a new tab)

    I, I was, I was blaming him for like three months on this and it was my problem the whole time.

    Voice-matched

  2. Episode 233: Daniel J Lewis in a Can (episode page, opens in a new tab) 00:22:59 (play audio from this timestamp, opens in a new tab)

    This time I did not restrict the size limit of the iTunes author tag to be less than, to be truncated to less than

    Voice-matched