Google App Engine

Prerequisites#

• Google Cloud Project
• BigQuery API Enabled
• Mapbox Token

In this guide you will create:

• Cloud SQL DB
• Cloud Storage Bucket
• App Engine App (Flexible environment)
• Configure Access to specific Google Accounts with Google IAP

Steps#

1. Create db instance

gcloud sql instances create ${DB_INSTANCE_NAME} \
    --database-version=POSTGRES_12 \
    --tier=db-f1-micro\
    --region=europe-west1

2. Create database

gcloud sql databases create dekart --instance=${DB_INSTANCE_NAME}

3. Set password; can be not secret, because there is one more layer of encryption and authorization in Cloud SQL

gcloud sql users set-password postgres --instance=${DB_INSTANCE_NAME} --password=dekart

4. Create storage

gsutil mb -b on -l europe-west1 gs://${BUCKET}/

5. Create App Engine App

gcloud app create --region=europe-west

6. Create Dockerfile

7. Create app.yaml

8. Deploy app

gcloud app deploy app.yaml

9. Configure Google IAP (works only with web console)

Example#

• All gcloud commands in Makefile
• Full example
• Configuration details

Edit this page on GitHub