Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Advanced Search Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Python for Google App Engine
  • Toc
  • feedback
Python for Google App Engine

Python for Google App Engine

By : Pippi
4.1 (10)
close
Python for Google App Engine

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.
Table of Contents (10 chapters)
close
close
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
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
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
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
4. Improving Application Performance
4. Improving Application Performance
Advanced use of Datastore
Using Memcache
Breaking our application into modules
Summary
5
5. Storing Data in Google Cloud SQL
chevron up
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
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
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
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
9
Index
Index

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
End of Section 1
Next Section
bookmark search playlist download
font-size

Change the font size

margin-width

Change margin width

day-mode

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Delete Bookmark

Modal Close icon
Are you sure you want to delete it?
Cancel
Yes, Delete