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.
  • Book Overview & Buying Python for Google App Engine
  • Table Of Contents Toc
  • Feedback & Rating feedback
Python for Google App Engine

Python for Google App Engine

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

Python for Google App Engine

4.1 (10)
By: Pippi
Buy this Book

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
close
Preface
Icon
Preface
Icon
What this book covers
Icon
What you need for this book
Icon
Who this book is for
Icon
Conventions
Icon
Reader feedback
Icon
Customer support
Icon
Downloading the example code
Icon
Errata
Icon
Piracy
Icon
Questions
Free Chapter
1
1. Getting Started
Icon
1. Getting Started
Icon
The cloud computing stack – SaaS, PaaS, and IaaS
Icon
Google Cloud Platform
Icon
What Google App Engine does
Icon
Making our first Python application
Icon
Google Developer Console
Icon
Summary
2
2. A More Complex Application
Icon
2. A More Complex Application
Icon
Experimenting on the Notes application
Icon
Authenticating users
Icon
HTML templates with Jinja2
Icon
Handling forms
Icon
Persisting data in Datastore
Icon
Using static files
Icon
Summary
3
3. Storing and Processing Users' Data
Icon
3. Storing and Processing Users' Data
Icon
Uploading files to Google Cloud Storage
Icon
Transforming images with the Images service
Icon
Processing long jobs with the task queue
Icon
Scheduling tasks with Cron
Icon
Sending notification e-mails
Icon
Receiving users' data as e-mail messages
Icon
Summary
4
4. Improving Application Performance
Icon
4. Improving Application Performance
Icon
Advanced use of Datastore
Icon
Using Memcache
Icon
Breaking our application into modules
Icon
Summary
5
5. Storing Data in Google Cloud SQL
chevron up
Icon
5. Storing Data in Google Cloud SQL
Icon
Creating a Cloud SQL instance
Icon
Connecting to the instance with the MySQL console
Icon
Connecting to the instance from our application
Icon
Loading and saving data
Icon
Using the local MySQL installation for development
Icon
Summary
6
6. Using Channels to Implement a Real-time Application
Icon
6. Using Channels to Implement a Real-time Application
Icon
Understanding how the Channel API works
Icon
Making our application real time
Icon
Implementing the server
Icon
Tracking connections and disconnections
Icon
Summary
7
7. Building an Application with Django
Icon
7. Building an Application with Django
Icon
Setting up the local environment
Icon
Rewriting our application using Django 1.7
Icon
Summary
8
8. Exposing a REST API with Google Cloud Endpoints
Icon
8. Exposing a REST API with Google Cloud Endpoints
Icon
Reasons to use a REST API
Icon
Designing and building the API
Icon
Implementing API endpoints
Icon
Testing the API with API Explorer
Icon
Protecting an endpoint with OAuth2
Icon
Summary
9
Index
Icon
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

Unlock full access

Continue reading for free

A Packt free trial gives you instant online access to our library of over 7000 practical eBooks and videos, constantly updated with the latest in tech
Start a 7-day FREE trial
End of Section 1
Next Section

Create a Note

Modal Close icon
You need to login to use this feature.
notes
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

Delete Note

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

Edit Note

Modal Close icon
Write a note (max 255 characters)
Cancel
Update Note

Confirmation

Modal Close icon
claim successful
Order Page Read Now

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY