Exactly what I was referring to. A user should only be able to choose a game that his stream belongs to from a list of games that is already set by the twitch administrators. Unless the current “string” design was done for some particular reason (such as k/v storage), I must say that it is really horrible and could potentially be abused.
RDB wise, a game is not unique anymore. “Dota2” and “Dota 2” are completely different database records. So from a relational perspective, the DB records will inevitably miss-match. I am not really sure what DB engine twitch uses, which could be the reason for this particular behavior. My concern is that in case this type of behavior is existent across twitch, that means that the platform is pretty much wide open for potential future errors due to no-data restrictions.
This is what I expected to be in running in the BG, but it seems like so is not the case.
With all of that being said, how can I get a list of all Dota2 streams?