Let’s say I want to build ToDo app with Okta authentication.
I need to store users’ tasks in the relational database.
The user has to have the ability to query only his tasks.
What user property should I use as a user identifier in my database?
In access token, I can see claims like uid and sub which seems to be suitable for my needs.
Unfortunately, both of them are strings instead of numeric values.
Using them as tables’ primary key seems like a very inefficient idea.
Could you recommend a better way of achieving my goal?