News for hackers. Stuff that matters.
Re:“Codeless” backend using PostgreSQL, PostgREST and Keycloak by mathieupassenau on Friday February 05, 2021 @08:12AM (#26035911)
Hi,

In this case, we use this procedure from the frontend app. When a user registers on Keycloak, this user is only stored on Keycloak.

Keycloak is used as an authentication provider, a "login with". The user is registered in the app on first use, even if the account already exists in Keycloak.

so, calling "api.add_user_if_not_exists" can be used on every request, only the first has an effect.

The field request.jwt.claim.sub is called "subject", this is a unique identifier for the user (a GUID with Keycloak). This field is provisionned by Keycloak, the JWT token has been verified by Postgrest with all informations (Keys).

Re:“Codeless” backend using PostgreSQL, PostgREST and Keycloak by runeks on Tuesday February 09, 2021 @05:27AM (#26075840)
I'm not sure how you found my question, but thank you very much for your answer, Mathieu!