Using Structured Data with PHP

On this page of the PHP Bookshelf tutorial, you choose a database for storing structured data. The Bookshelf sample app uses a structured data model for storing information about books. You can explore the sample by using one of four different backing databases: Google Cloud SQL for MySQL, Google Cloud SQL for PostgreSQL, Google Cloud Datastore, or MongoDB.

This page is part of a multi-page tutorial. To start from the beginning and see instructions for setting up, go to PHP Bookshelf App.

To get started with the Bookshelf tutorial, choose choose one of the following options:

Database Why use this? Configuration
Google Cloud SQL for MySQL
Managed MySQL
Use MySQL >
Choose this option if you're familiar with MySQL or if you are interested in a managed relational database.

Benefits:

  • Create and configure your databases. Cloud SQL handles all other management tasks like replication and patch management.
  • Access your data in Cloud SQL databases using all the tools and applications already built for MySQL.
  • Use your favorite MySQL tools and apps because Cloud SQL is MySQL in the cloud.
Create a Cloud SQL instance and configure access.
Google Cloud SQL for PostgreSQL
Managed PostgreSQL
Use PostgreSQL >
Choose this option if you're familiar with PostgreSQL or if you are interested in a managed relational database.

Benefits:

  • Create and configure your databases. Cloud SQL handles all other management tasks like replication and patch management.
  • Access your data in Cloud SQL databases using all the tools and applications already built for PostgreSQL.
  • Use your favorite PostgreSQL tools and apps because Cloud SQL is PostgreSQL in the cloud.
Create a Cloud SQL instance and configure access.
Google Cloud Datastore
Managed NoSQL database
Use Cloud Datastore >
Choose this option if you want a zero-configuration, fully-managed, highly-scalable, non-relational database.

Benefits:

  • Automatically scales based on your application's users and traffic, so you don't have to worry about provisioning or load anticipation.
  • Query your data with SQL-like queries that support filtering and sorting.
No additional configuration needed.
MongoDB
Run MongoDB on Google Compute Engine
Use MongoDB >
Choose this option if you are familiar with MongoDB or if you want to learn how to run your own database on Compute Engine.

Benefits:

  • Deploy a MongoDB cluster on virtual machines that you provision and control. Alternatively, you can use a managed service like mLab
  • Take advantage of the MongoDB knowledge you have.
  • Get support from MongoDB's rapidly growing community.
Deploy and configure a MongoDB cluster.

Send feedback about...