strapi · pwizla · Jan 13, 2022 · Jan 9, 2022 · Jan 9, 2022 · Jan 12, 2022
@@ -93,8 +93,6 @@ Create another database, named `strapi` for example. It may be useful to delete
 
 Create the `app.yaml` file in the project root.
 
-Add `app.yaml` to `.gitignore`.
-
 The instance identifier looks like `myapi-123456:europe-west1:myapi`.
 
 The `myapi-123456` part is the project identifier. (The number is automatically added to short project names).
@@ -106,15 +104,15 @@ The following is an example config for `Standard Environment` or `Flexible Envir
 ::: tab Standard Environment
 
 ```yaml
-runtime: nodejs14
+runtime: nodejs16
 
 instance_class: F2
 
 env_variables:
   HOST: '0.0.0.0'
   NODE_ENV: 'production'
   DATABASE_NAME: 'strapi'
-  DATABASE_USERNAME: 'postgres'
+  DATABASE_USER: 'postgres'
   DATABASE_PASSWORD: '<password>'
   INSTANCE_CONNECTION_NAME: '<instance_identifier>'
 
@@ -135,7 +133,7 @@ env_variables:
   HOST: '0.0.0.0'
   NODE_ENV: 'production'
   DATABASE_NAME: 'strapi'
-  DATABASE_USERNAME: 'postgres'
+  DATABASE_USER: 'postgres'
   DATABASE_PASSWORD: '<password>'
   INSTANCE_CONNECTION_NAME: '<instance_identifier>'
 
@@ -150,18 +148,25 @@ beta_settings:
 Create `.gcloudignore` in the project root.
 
 ```
-app.yaml
 .gcloudignore
 .git
 .gitignore
 node_modules/
 #!include:.gitignore
+!.env
 ```
 
 In the case of Strapi, the admin UI will have to be re-built after every deploy,
 and so we don't deploy local build artifacts, cache files and so on by including
 the `.gitignore` entries.
 
+### Adding `.gitkeep` to database folder
+Google App Engine does not give `mkdir` permissions and the `database/migrations` folder is required for deployments. Make sure `git` keeps track of the `database/migrations` folder by adding a `.gitkeep` file to the folder. Use the following command:
+
+```bash
+touch .gitkeep
+```
+
 ### Configure the database
 
 The `PostgreSQL` database will need the `pg` package.
@@ -170,26 +175,19 @@ The `PostgreSQL` database will need the `pg` package.
 yarn add pg
 ```
 
-[Google App Engine requires](https://cloud.google.com/sql/docs/postgres/connect-app-engine) to connect to the database using the unix socket path, not an IP and port.
-
-Edit `database.js`, and use the socket path as `socketPath`.
-
-`Path: ./config/env/production/database.js`.
+Adding the production database configuration for connect to GCP SQL.
 
 ```js
+// path: ./config/env/production/database.js
+
 module.exports = ({ env }) => ({
-  defaultConnection: 'default',
-  connections: {
-    default: {
-      connector: 'bookshelf',
-      settings: {
-        client: 'postgres',
-        socketPath: `/cloudsql/${env('INSTANCE_CONNECTION_NAME')}`,
+  connection: {
+    client: 'postgres',
+    connection: {
+        host: `/cloudsql/${env('INSTANCE_CONNECTION_NAME')}`,
         database: env('DATABASE_NAME'),
-        username: env('DATABASE_USERNAME'),
+        user: env('DATABASE_USER'),
         password: env('DATABASE_PASSWORD'),
-      },
-      options: {},
     },
   },
 });