Migrating development to production
Hi
Thank you for building a great and relatively easy to use system. One thing that I think is sorely missing is resources, scripts or commands to dump a schema, seed data, and also settings (that are configured using the UI) so that it can be exported and pushed to another environment.
I have seen some commands for dumping using PSQL and also some CLI migration commands and different articles here and there but there is no comprehensive functionality to move schema and settings from one environment to another. For example it would be nice to have a command that dumps all the various settins from the UI into a JSON or YAML file that can be loaded into a newly launched project to go from a development system to a production system.
Also these scripts can be used during a code update to keep the environments in sync after release. It can
- Pull and Push migrations from one env to another. Or Development to local and local to production.
- Sync up secrets
- Sync up edge functions
- Sync up Storage buckets
- Sync up settings such as Authentication/SMTP etc.
Does anybody have any code or examples for doing this?
Thanks!
Thank you for building a great and relatively easy to use system. One thing that I think is sorely missing is resources, scripts or commands to dump a schema, seed data, and also settings (that are configured using the UI) so that it can be exported and pushed to another environment.
I have seen some commands for dumping using PSQL and also some CLI migration commands and different articles here and there but there is no comprehensive functionality to move schema and settings from one environment to another. For example it would be nice to have a command that dumps all the various settins from the UI into a JSON or YAML file that can be loaded into a newly launched project to go from a development system to a production system.
Also these scripts can be used during a code update to keep the environments in sync after release. It can
- Pull and Push migrations from one env to another. Or Development to local and local to production.
- Sync up secrets
- Sync up edge functions
- Sync up Storage buckets
- Sync up settings such as Authentication/SMTP etc.
Does anybody have any code or examples for doing this?
Thanks!
