If we use the supertokens connection uri, we would...
# support-questions-legacyc
chunkygoo.
09/23/2022, 4:22 PMIf 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?
r
rp_st
09/23/2022, 4:33 PMHey!
rp_st
09/23/2022, 4:33 PMThe 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 PMCopying 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 )
c
chunkygoo.
09/23/2022, 5:33 PMYes but that would require an extra db call everytime, no?
chunkygoo.
09/23/2022, 5:34 PM1. Need to get the user_id for the session,
chunkygoo.
09/23/2022, 5:34 PM2. Then use that id to get the email
chunkygoo.
09/23/2022, 5:34 PMSo everytime I need the email, an extra db call is required
r
rp_st
09/23/2022, 5:37 PMWell, you can put the email in the access token payload
c
chunkygoo.
09/23/2022, 5:39 PMSounds good. Goes back to this issue https://discord.com/channels/603466164219281420/1022709639177056306
chunkygoo.
09/23/2022, 5:39 PMThanks
5 Views