PostgREST
Bring back the Integrations section
Could include:
- The old timescale doc https://postgrest.org/en/v5.2/integrations/timescaledb.html.
- The pgbouncer section: https://postgrest.org/en/v8.0/admin.html#using-external-connection-poolers
- Greenplum: https://github.com/PostgREST/postgrest/issues/2021#issuecomment-977693580
I think we could remove the Nginx parts from https://postgrest.org/en/v8.0/admin.html into an integration page for "Reverse proxies" as well, that way we could include other alternatives like HAProxy or Caddy in the same page and turn "Administration" into a reference.
Yugabyte also works https://dev.to/yugabyte/rest-data-service-on-yugabytedb-postgresql-5f2h
It needs disabling the db-channel though PGRST_DB_CHANNEL_ENABLED=false.
I disabled the "DB Channel" because LISTEN/NOTIFY is not enabled in YugabyteDB (this mecanism is not appropriate for a distributed database).
Not sure if a /reload endpoint on the admin server would help as an alternative way to reload the schema cache, pg and postgrest might be on different machines.
So I tried to bring back timescale and many of the links are broken. Making the postgrest-docs-linkcheck fail.
And when I tried to repair them. I noticed that somehow the timescale pages show as blank: https://docs.timescale.com/api/latest/hypertable/create_hypertable/
(it renders then reloads and goes blank)
Now that timescale is a pg extension I guess it doesn't make much sense to add it. It also adds maintenance burden.
I did add a mention for Greenplum since it's a fork of pg.