Sign In Start Free Trial

Python for Google App Engine

By : Pippi

4.1 (10)

Python for Google App Engine

4.1 (10)

By: Pippi

Overview of this book

If you are a Python developer, whether you have experience in web applications development or not, and want to rapidly deploy a scalable backend service or a modern web application on Google App Engine, then this book is for you.

Preface

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Downloading the example code

Errata

Piracy

Questions

Free Chapter

1. Getting Started

1. Getting Started

The cloud computing stack – SaaS, PaaS, and IaaS

Google Cloud Platform

What Google App Engine does

Making our first Python application

Google Developer Console

Summary

2. A More Complex Application

2. A More Complex Application

Experimenting on the Notes application

Authenticating users

HTML templates with Jinja2

Handling forms

Persisting data in Datastore

Using static files

Summary

3. Storing and Processing Users' Data

3. Storing and Processing Users' Data

Uploading files to Google Cloud Storage

Transforming images with the Images service

Processing long jobs with the task queue

Scheduling tasks with Cron

Sending notification e-mails

Receiving users' data as e-mail messages

Summary

4. Improving Application Performance

4. Improving Application Performance

Advanced use of Datastore

Using Memcache

Breaking our application into modules

Summary

5. Storing Data in Google Cloud SQL

5. Storing Data in Google Cloud SQL

Creating a Cloud SQL instance

Connecting to the instance with the MySQL console

Connecting to the instance from our application

Loading and saving data

Using the local MySQL installation for development

Summary

6. Using Channels to Implement a Real-time Application

6. Using Channels to Implement a Real-time Application

Understanding how the Channel API works

Making our application real time

Implementing the server

Tracking connections and disconnections

Summary

7. Building an Application with Django

7. Building an Application with Django

Setting up the local environment

Rewriting our application using Django 1.7

Summary

8. Exposing a REST API with Google Cloud Endpoints

8. Exposing a REST API with Google Cloud Endpoints

Reasons to use a REST API

Designing and building the API

Implementing API endpoints

Testing the API with API Explorer

Protecting an endpoint with OAuth2

Summary

Index

Index

Customer Reviews

4.1 (10)

5 star

40%

4 star

40%

3 star

10%

2 star

10%

1 star

0

Chapter 5. Storing Data in Google Cloud SQL

Google Cloud SQL is a MySQL database server instance that lives in the Google cloud infrastructure; it can be used from outside Google Cloud Platform within applications that don't run on the App Engine platform. We will learn how to use it both ways: by adding code to our Notes application and creating a standalone script that runs on our workstation.

Google offers two billing plans for Cloud SQL, Packages and Per Use, without providing any free tier. This means we have to pay to execute the code in this chapter, though choosing the Per Use plan and running the instance for the sole purpose of going through the chapter should be extremely cheap.

In this chapter, we will cover the following topics:

How to create, configure, and run a Cloud SQL instance
How to manage a running instance
How to use Cloud SQL from App Engine
How to use Cloud SQL from outside App Engine

Search

Your notes and bookmarks