Simple Google Cloud SQL trial guide (1)

Datastore has become a nightmare for many developers who are familiar with relational databases and want to try Google App Engine. The biggest problem to port existing applications to Google App Engine is Datastore. I tried to create a Google Cloud SQL database and import data to it. It is not difficult to operate, and it feels good!

Most traditional applications use relational databases for data storage. However, since relational databases often require a lot of modifications for system expansion, such systems will initially increase performance by upgrading system hardware, however, the higher the hardware upgrade, the lower the cost-effectiveness. Therefore, it is very difficult to expand the system.

The Datastore of Google App Engine is a NoSQL Database. This Database expansion system is relatively simple. For example, you can buy 10 intermediate machines to form an advanced system. If not, you can add more machines, theoretically, the system can be extended infinitely. NoSQL databases do not have syntax such as Join tables. You can only implement Join tables at the application level. Of course, this will increase the difficulty of program development to some extent.

Datastore has become a nightmare for many developers who are familiar with relational databases and want to try Google App Engine. The biggest problem to port existing applications to Google App Engine is Datastore, many people are discouraged.

However, everything will be improved because of the launch of Google Cloud SQL. Last time I introduced the main features and functional limitations of google cloud SQL and introduced the application steps. after about three days of waiting, after the application is approved, I tried to create a Google Cloud SQL database and import data to it. The operation is not difficult, and it feels good!

1. the main interface of the Google Cloud SQL Console is like this. You will find that there are two more links on the left navigation bar than before: Google Cloud SQL and Google Cloud Storage

2. There are three types of Google Cloud SQL instance capacities: 1 GB, 5 GB, and 10 GB. The maximum capacity is 10 GB. the main features and functional limitations of Google Cloud SQL have been described in the article.

3. added a MySQL instance. Currently, only Google App Engine can be accessed. Enter the gae id of the instance in the input box below.