Firebase Data Connect lets you create connectors for your PostgreSQL instances managed with Google Cloud SQL, combining schemas, queries and mutations for using your data.
The Get started guide introduced an email app schema for PostgreSQL, but this guide takes a deeper look at how to design Data Connect schemas for PostgreSQL, now using a movie review database as the motivating example.
This guide pairs Data Connect queries and mutations with schema examples. Why do we discuss queries (and mutations) in a guide about Data Connect schemas? Like other GraphQL-based platforms, Firebase Data Connect is a query-first development platform, so as a developer, in your data modeling you'll be thinking about the data your clients need, which will greatly influence the data schema you develop for your project.
We'll start with a new schema for movie reviews, then cover the queries and mutations derived from that schema, and lastly provide a SQL listing equivalent to the core Data Connect schema.
This is an excerpt from the Data Connect documentation. When you sign up for the Data Connect preview, you'll have full access to this guide, which covers:
- A sample GraphQL schema for a movie review app
- Supported data types in Data Connect GraphQL
- GraphQL language extensions provided by Data Connect
- Numerous example queries and mutations for the movie review app.