Storing long JSON for each user

Hello,

I want each of my users to store a list of links and other relative information in JSON format. I originally thought of adding this JSON as a user attribute but when it gets too big I get a Value too long for column error.

Which would be the best approach to do this?

Hi,

without knowing the full scope of you use case I can provide you with the following tips.

Take a look at the following repo https://github.com/zonaut/keycloak-extensions, especially the provider-domain example which you could use to create an extra table to store the data and the spi-resource example to possibly access that data.

My suggestion though is to store this data somewhere else if it’s not related to a security context.