Keep a record of how many times each sound effect is played

[clarkio]

This issue is for a: (mark with an x)

• [ ] bug report -> please search issues before submitting
• [x] feature request
• [ ] documentation issue or request
• [ ] regression (a behavior that used to work and stopped in a new release)

Expected/desired behavior

use some kind of database to keep track of the count send a message when a user activates a sound effect that's never been played before send a message when a user activates a sound effect and hits a certain count milestone (such as played 100 times)

[clarkio]

As suggested by DaymeTV on Twitch, keep track of how many times incorrect sound effects are used.

Maybe when a sound effect command is misspelled it automatically plays a different sound effect in response (like an error horn or something)

[ToeFrog]

@clarkio - Looking at this. @MichaelJolley is using FaunaDB for his awesum.io app for DB storage. That may be an option here or something like CosmosDB if you want to keep it all in Azure.

[clarkio]

Link to Fauna to check out further: https://fauna.com/

[michaeljolley]

I'll give a 👍 for FaunaDB. @clarkio knows I'm very pro-Azure, and actually started with CosmosDB, but its pricing model is not very welcoming for smaller projects. Same can be done in FaunaDB for free and it was very easy to get rolling.

[ToeFrog]

Looked at FaunaDB. After reviewing and discussing in Discord i'm probably going to go with CosmosDB to keep it all in Azure. This can be expanded to include the other commands to keep track of how many times they are used as well as which !bulb color gets used the most, which was referenced in Issue #92 and it can also be used for Issue #93 .