I know this has been a discussion in several threads before, but with the new Supabase integration via personal access token, I wonder what the best release process for the following setup would be:
We are using different Supabase projects for Dev, Staging and Production
We also query different API endpoints in Dev, Staging and Production
While I can bind the URL for an API endpoint based on the value provided in the Browser.environment property, I am not able to “bind” the Supabase project based on that property.
So this means, I would manually have to select the correct Supabase project before each deployment.
However - when I deploy the app to Staging and want to push this app later from Staging to Production, I am not able to change the Supabase project from Staging to Production anymore (considering that I already continued working in Dev environment, it’s also not possible to deploy from Dev straight to Production).
What is a reliable approach to solve this problem?