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 read the setup instructions, go to PHP Bookshelf app.

To get started, 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.
Was this page helpful? Let us know how we did:

Send feedback about...