Parse and store emote use in chat.

[MitchellHarrison]

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!

[MitchellHarrison]

Found helpful reference here.

[MitchellHarrison]

The bot currently gets emote use by emote ID using Regex, but converting emote ID's to text/image is still in the works with #31