Add how to install watch fixtures yourself to the docs

[jcgsville]

When setting grafserv: { watch: true } and omitting makePgService's superUserConnectionString, Postgraphile errors with the following text:

Installing watch fixtures requires superuser privileges; have you correctly configured a 'superuserConnectionString'?
You may also opt to configure 'installWatchFixtures: false' and install them yourself.

(Great error message, btw! Clear, helpful errors are an underrated part of UX 🙂)

When using Postgraphile myself, I want to install watch fixtures as a part of my db setup so that the server running postgraphile does not need access to super user db creds. I went to check the docs on how to do this, and noticed it wasn't in the docs anywhere. We should add how and why to do this to the docs.

I found the queries here: https://github.com/graphile/crystal/blob/36c41e80bfe312f584af42545688fb78d3adaf3f/graphile-build/graphile-build-pg/src/watchFixtures.ts

A quick 👍 to make sure we're aligned, and I'm happy to make the PR for this addition myself.

[jcgsville]

Relatedly, as I'm adding these watch fixtures to my migrations, I'm realizing that I need to keep an eye on them any time I update PostGraphile to be sure they aren't changing. While I highly doubt these will change much, if ever, I think it may make sense to have a way to do "watch fixture migrations only" via postgraphile, such that the schema is updated automatically. I think Graphile Worker has similar functionality, though worker's schema changes far more regularly, of course, so it's more useful

[benjie]

Yes please, though we should tell people how to output the SQL to a file and tell them to check it hasn’t changed on each update since it’s not the supported approach.

[jcgsville]

I don't know off the top of my head how to do that, but I'm sure I can figure it out. Will report back

[benjie]

I'm not sure we can currently; but adding an export seems reasonable:

1. add another endpoint to graphile-build-pg to export the watch fixtures file, like this:

   crystal/graphile-build/graphile-build-pg/package.json

   Lines 13 to 17 in fa9fbb3

   	"./pg-introspection": {
   	"types": "./fwd/pg-introspection/index.d.ts",
   	"node": "./fwd/pg-introspection/index.js",
   	"default": "./fwd/pg-introspection/index.js"
   	}

2. Run node scripts/fwd.mjs to create the forwards in the relevant packages
3. Add to docs something like:

import { watchFixtures } from "postgraphile/graphile-build-pg/watchFixtures";
import * as fs from "node:fs/promises";

const __dirname = import.meta.dirname; // Or whatever it is; I forget.

await fs.writeFile(`${__dirname}/watchFixtures.sql`, watchFixtures);

I'm not bothered about making this too easy since it's not a supported interface - no need to create a CLI for it.