Building Google Cloud Platform Solutions

Trying it out

Suppose we want to build a library management system that tracks information about books, members, and which books are checked out by which members. A simple database to track this information might look something like the following:

A simple library management database (diagram created using MySQL Workbench)

Let's use the Cloud SQL Proxy to connect to our hello-cloud-sql instance and execute a script to generate some tables that we can use in later examples. First, use gcloud to create a new database called library:

gcloud sql databases create library --instance=hello-cloud-sql

We'll use this database to manage library books ...