If we use the supertokens connection uri, we wouldn't be able to modify the database to create new t...

chunkygoo.

09/23/2022, 4:22 PM

If we use the supertokens connection uri, we wouldn't be able to modify the database to create new tables etc. This means that I have to "copy" the user id and email to my app's database, resulting in redundant information and possibly out of sync. What is the recommended action here? Why wouldn't ST let us have the db connection for prod just like for dev?

rp_st

09/23/2022, 4:33 PM

Hey!

rp_st

09/23/2022, 4:33 PM

The db connection in dev is meant as a way of of just debugging and deleting stuff. You shouldn’t really rely on that

rp_st

09/23/2022, 4:34 PM

Copying over the info into your db is fine. Though you would only need to copy over the userId and not email (since you can get email from the user if fairly easily using our backend SDK )

chunkygoo.

09/23/2022, 5:33 PM

Yes but that would require an extra db call everytime, no?

chunkygoo.

09/23/2022, 5:34 PM

1. Need to get the user_id for the session,

chunkygoo.

09/23/2022, 5:34 PM

2. Then use that id to get the email

chunkygoo.

09/23/2022, 5:34 PM

So everytime I need the email, an extra db call is required

rp_st

09/23/2022, 5:37 PM

Well, you can put the email in the access token payload

chunkygoo.

09/23/2022, 5:39 PM

Sounds good. Goes back to this issue https://discord.com/channels/603466164219281420/1022709639177056306

chunkygoo.

09/23/2022, 5:39 PM

Thanks

4 Views

Previous Next

SuperTokens.com

SuperTokens is an open source authentication solution offering features like: Different types of login: Email / password, Passwordless (OTP or Magic link based).