Keycloak integration

[magick93]

Hello

I'm interested in learning more about the keycloak integration.

Specifically, is keycloak using the same prostges database, is a separate database?

Does the uid() still work (as it does with supabase) or is then looking up in the keycloak database / tables?

Does the jwt contain (custom) roles from keycloak?

[noctarius]

Keycloak uses the system database but individual reals per branch. uid() doesn't work right now, but we're working on a solution. Since Keycloak uses the global system database, not the branch database, just querying from the database isn't possible.

For the roles, at the moment, we're not using roles in Keycloak. The roles aren't yet available in the JWT.