This is derived from Nate B Jones Open Brain. I've made some minor improvements, but the initial work of laying it out cleanly was done by him and if this is saving you time, you should toss some resources his way.

Directories:

• supabase - edge functions for Supabase
• public-site - contents of the Supabase storage bucket named public-site

To update the RPC Functions (AKA stored procedures),

1. Ensure you've set SUPABASE_DB_PASSWORD
2. Create a new migration (e.g., for match_thoughts)

   supabase migration new update_match_thoughts

3. Edit the file it created e.g., supabase/migrations/<timestamp>_update_match_thoughts.sql Paste your updated CREATE OR REPLACE FUNCTION statement.
4. Deploy

   supabase db push

   OR

   deploy_all.sh