Steve Chavez

Change the api reference http blocks to curl calls

1

This might be particularly helpful in the function section: http://postgrest.org/en/latest/api.html#stored-procedures This: ``` curl http://localhost:3000/rpc/add_them \ -X POST -H "Content-Type: application/json" \ -d '{"a": 3,"b":2}' ``` Is more useful than: ```...

Under http://postgrest.org/en/v7.0.0/api.html#http-logic. Related to https://github.com/PostgREST/postgrest/issues/1642. Recommend to add a wrapper function as in https://github.com/PostgREST/postgrest/issues/1642#issuecomment-720566013.

Add logging enhancements

1

Recommend using `log_line_prefix` and `application_name` as mentioned in https://github.com/PostgREST/postgrest/issues/540#issuecomment-540649767. In http://postgrest.org/en/v6.0/admin.html#database-logs.

This would help newcomers understand what PostgREST does and avoid thinking it's "too magic". It could contain examples of the generated queries, the flow of the request(parser combinators -> statement)...

Add this on http://postgrest.org/en/v7.0.0/admin.html. Useful for load balancing. See http://postgrest.org/en/v7.0.0/admin.html. Related to https://github.com/PostgREST/postgrest/issues/1565#event-3625223607.

Configuration for keycloak

5

Follow the guideline in https://github.com/PostgREST/postgrest/issues/1191

Warn about out of schema types error on SECURITY DEFINER

1

In http://postgrest.org/en/v7.0.0/schema_structure.html#schema-isolation. Functions don't find types outside of the api schema. Unless a `search_path` is added to them(see https://www.postgresql.org/docs/13/sql-createfunction.html#SQL-CREATEFUNCTION-SECURITY). This can show a: `ERROR: permission denied for schema `. This...

This would make exploring pgrst features easier. Instead of creating a new db, the references examples could be changed to be based off our [fixtures schema](https://github.com/PostgREST/postgrest/blob/master/test/fixtures/schema.sql).

Clarify http://postgrest.org/en/v7.0.0/how-tos/providing-images-for-img.html. Some feedback on https://gitter.im/begriffs/postgrest?at=5eccf5282c49c45f5aa197b4. Not clear that nginx sets the correct headers. Also maybe add a note with a link to https://wiki.postgresql.org/wiki/BinaryFilesInDB. And mention CDN as an alternative...

Include https://github.com/monacoremo/postgrest-sessions-example in the docs. Linked issue: https://github.com/monacoremo/postgrest-sessions-example/issues/19.