I'd like to implement emote tracking into the bot. For both streamer-specific and twitch-wide emotes. This should be stored in a database table, but I'm unsure how to do it. Options are:
- One row in the table per emote, and simply increment.
- Add a column to the
chat_messages table to list which emotes were used per message.
The former seems like I would be losing some granularity as far as who is using the emotes and which streams see the most emote use. But I'm unclear on the implementation of the latter. I would have to pass something like a list into a single column and that would make future analysis much more difficult and slower.
If anyone has insights, feel free to drop them!
I'd like to implement emote tracking into the bot. For both streamer-specific and twitch-wide emotes. This should be stored in a database table, but I'm unsure how to do it. Options are:
chat_messagestable to list which emotes were used per message.The former seems like I would be losing some granularity as far as who is using the emotes and which streams see the most emote use. But I'm unclear on the implementation of the latter. I would have to pass something like a list into a single column and that would make future analysis much more difficult and slower.
If anyone has insights, feel free to drop them!