Creating Production, Staging and Development instances of Supabase.
Hey! I am almost ready to launch my website, but before I do I would like to create Staging and Development instances of my existing Supabase instance.
My ideas is to clone the current Production database to a Development instance. I can then make changes to this Development instance. Once I am happy, I can push these changes to the Staging instance. I think it would be useful if each time I push changes to the Staging instance, the Staging instance is first turned into a complete clone of the Production instance. Then, changes made to the Development database can be applied to the Staging instance. This way, if the changes work well on the Staging instance, then it can be safely assumed that the same changes can be applied to the Production instance.
I am wondering if my solution is overcomplicated, I would love feedback of any kind, including how others approach this same idea!
My ideas is to clone the current Production database to a Development instance. I can then make changes to this Development instance. Once I am happy, I can push these changes to the Staging instance. I think it would be useful if each time I push changes to the Staging instance, the Staging instance is first turned into a complete clone of the Production instance. Then, changes made to the Development database can be applied to the Staging instance. This way, if the changes work well on the Staging instance, then it can be safely assumed that the same changes can be applied to the Production instance.
I am wondering if my solution is overcomplicated, I would love feedback of any kind, including how others approach this same idea!
