Please give us your opinion on how to improve the convenience of development.

[Emily]

Please give us your opinion on how to improve the convenience of development.

I am developing an app using Cloud SQL on GCP.
After developing with the application for development, upgrade to the application for production. However, when upgrading, the following work will occur because the development application and the production application will be temporarily the same.
・Change the data source of all tables
・Change the document ID of the task template
・Change of brand image URL

Also, during development, it is difficult to see the difference between current development and production.
Is there any way to know the difference?

[Aurelien · Accepted solution]

Hi @Emily 

As far as I know, there is no such tool.

How do you proceed for updating your app ? 

Basically you can either:

- use the Manage>Versions>Stable Version > Make Stable or show the Latest version buttons

- similarly, use the Manage>Versions>Version History> Get version history > View button

- create a copy of the app (same or different datasource) and use this one to update the app in production, using the Manage>Versions>/App Upgrade app > Upgrade app button

If you are using the 2nd or 3rd option, you can compare visually the two editors, but in either case you won't have an automatic comparison tool.

[Aurelien · Accepted solution]

Hi @Emily 

As far as I know, there is no such tool.

How do you proceed for updating your app ? 

Basically you can either:

- use the Manage>Versions>Stable Version > Make Stable or show the Latest version buttons

- similarly, use the Manage>Versions>Version History> Get version history > View button

- create a copy of the app (same or different datasource) and use this one to update the app in production, using the Manage>Versions>/App Upgrade app > Upgrade app button

If you are using the 2nd or 3rd option, you can compare visually the two editors, but in either case you won't have an automatic comparison tool.

[Emily]

Thank you for your reply.
I remember that Stable ver can be used with Enterprise or higher license.
I would like to try the app copy.

[Steve · Accepted solution]

There's really no good way to do it; no matter what, you're going to have to reconfigure all of those things. Consider this procedure:

1. Copy Development to Staging.
2. Development may continue with the Development copy.
3. Note version of Staging in case roll-back is needed.
4. Reconfigure Staging for production.
5. Confirm Staging works properly when configured as production.
6. Note version of Production in case a roll-back is needed.
7. Copy Staging to Production.
8. Change Staging app short name.

[Emily]

Thank you for your reply.

Even if we copy the app initially, if the Google Cloud SQL database is separate for development and production environments, we also need to reselect the data source.

I would love to be able to do diff-only upgrades.

[SkrOYC]

---

@Emily wrote:

I remember that Stable ver can be used with Enterprise or higher license.

---

As well as SQL

[Steve]

---

@Emily wrote:

we also need to reselect the data source

---

True.

You could use partitions to choose the development or production data sources as appropriate.