Joe Nelson comments

Results 213 comments of


                                            Joe Nelson

Query Grammer

Thanks @amirsaber, that looks accurate to me. @steve-chavez can you confirm? If it's all good I'll add it to docs.

Return Full object from INSERT Trigger

@Mithrandir21 are you interested in sending a PR to document this tip?

[Request] Add compelling example of impressive functionality(Resource Embedding)

If you've read through https://postgrest.com/en/v0.4/api.html#resource-embedding then here's one such query: ``` /films?select=*,actors{*} ``` Postgrest will find the connection through the Roles table. Is this the kind of thing you're wondering...

Note how to protect JWT secret at rest in the db

@deinspanjer any update on this?

Note how to protect JWT secret at rest in the db

I believe this documentation, once written, will address the concerns in https://github.com/begriffs/postgrest/issues/809

Note how to protect JWT secret at rest in the db

Note to self: we also want to give an example of hiding the jwt functions themselves in a separate schema from the public api schema.

Note how to protect JWT secret at rest in the db

Thanks for that.

How to hook on operations aka Where goes business logic?

Hi @devotis, you can use a postgresql [trigger](https://www.postgresql.org/docs/9.6/static/trigger-definition.html) to perform actions before/after certain db operations. Inside the trigger you can emit a sql [NOTIFY](https://www.postgresql.org/docs/9.6/static/sql-notify.html) command and have an external bridge...

Provide auth example with app users + row level security

Note to self, also include example of read-only or invisible fields based on user permissions as @sqwishy requested in the chat. > I guess in my case I'd want to...

Provide auth example with app users + row level security

Also @daurnimator poses another scenario we might want to model: > you can see all friends details; some friends of friends details; and anyone else visibility is determined by privacy...