This handler allows you to use GraphQL schema created by PostGraphile, based on a PostgreSQL database schema.
To get started, install the handler library from NPM:
Now, you can use it directly in your Mesh config file:
You can check out our example that uses schema stitching with a PostgreSQL datasource. Click here to open the example on GitHub
You can add PostGraphile plugins for example FederationPlugin. You can install it using npm or yarn like below;
and add those in your configuration file;
Federation plugin converts your Postgraphile schema into a federated schema that can also be recognized by Stitching and this brings Automatic Type Merging. So you can install
@graphile/federation package like above and add it under
If you want to have automatic many-to-many mapping across your entities. You can install
yarn add @graphile-contrib/pg-many-to-many and add it under
If you use
PostGIS in your PostgreSQL database, you need to install
@graphile/postgis package and add it under
See more plugins to improve the experience!
String) - A connection string to your Postgres database
Array of String, required) - An array of strings which specifies the PostgreSQL schemas that PostGraphile will use to create a GraphQL schema. The default schema is the public schema.
Any) - Connection Pool instance or settings or you can provide the path of a code file that exports any of those
Array of String) - Extra Postgraphile Plugins to append
Array of String) - Postgraphile Plugins to skip (e.g. "graphile-build#NodePlugin")
options- - Extra Postgraphile options that will be added to the postgraphile constructor. It can either be an object or a string pointing to the object's path (e.g. "./my-config#options"). See the postgraphile docs for more information. One of:
Boolean) - Enable GraphQL websocket transport support for subscriptions (default: true)
Boolean) - Enables live-query support via GraphQL subscriptions (sends updated payload any time nested collections/records change) (default: true)