[integration] Slack integration

[Logannford]

MVP

everyday at let's say 10am, the daily question will get posted into a slack channel and can be answered by all the user's in that channel.
Then after (maybe 2 hours (?) - will be configurable eventually) the fastest user's get posted in a leaderboard

what does this require?

• New stripe plan (team)
• a slack bot to post the questions.

Investigations

Done some digging into this, looking around and I think it can be achieve via the following:

• Deno + slack combo
• Hitting a supabase edge function
• could also use https://trigger.dev/ instead of pg_cron as I will (eventually) need to allow a org to set what time they would like the msg to be posted. trigger supports setting in different timezones

Example repo here: https://github.com/supabase-community/supa-jam (by the supabase team)
Video here: https://www.youtube.com/watch?v=vJfPZyP4GGQ&ab_channel=Supabase

what do you think @jakemackie ?

[jakemackie]

Yooo that's a huge idea. Slack docs are pretty awful from what I remember but this would really be sick