Hey, As I understand, users are creating and signi...
# support-questions-legacyw
weboux
01/27/2023, 11:16 AMHey, As I understand, users are creating and signing in to superTokens's table, not to my table?
So to change this, I need override like there is write : https://supertokens.com/docs/thirdpartyemailpassword/common-customizations/handling-signinup-success ?
I use Nestjs and Prisma.
weboux
01/27/2023, 2:02 PMDo some admin or someone else know?
weboux
01/27/2023, 3:19 PM@porcellus I mean is that I want email verification and user creation to my table, as I understand users are created in some SuperTokens table and not in my table, so according to the above tutorial I will have duplicated data in the db. Is there a way to achieve this without duplication?
p
porcellus
01/27/2023, 3:20 PMhi
porcellus
01/27/2023, 3:22 PMyou could only achieve this by basically replacing and re-implementing the entire user handling code.
porcellus
01/27/2023, 3:22 PMwhy do you want to store that data in your own table? or what do you mean by your own table?
porcellus
01/27/2023, 3:22 PMyou can change which DB supertokens connects to and you can change the table names as well
w
weboux
01/27/2023, 3:33 PMDo you mean I would have to give up SuperTokens? (first answer)
I have a table relationship for users with other tables. I keep all the user data there (I have more fields than emailpassword_users). I have the whole CRUD prepared for this table. I don't know yet how to cache the data.
I only found information about adding a prefix for table names and renaming the db schema.
p
porcellus
01/27/2023, 3:45 PMWell, not all of it, but if you want to store users only in custom tables, then only the session handling would be useful to you I think.
porcellus
01/27/2023, 3:46 PMItd be easier to normalize your data and use the super tokens user id as a key
porcellus
01/27/2023, 3:47 PMBasically supertokens would store the necessary data in it's own tables and you could store whatever else you need in your own tables
w
weboux
01/27/2023, 3:55 PMIf only session recipe , it would use your email verification and I need to do social login myself?
weboux
01/27/2023, 3:57 PMSo I need to create relation (your) emailpassword_users to my tables?
p
porcellus
01/27/2023, 6:07 PMThis is what I'd recommend.
porcellus
01/27/2023, 6:09 PMThe session recipe only handles session management, there is a separate recipe for email verification.
w
weboux
01/27/2023, 6:21 PMWhere? I cannot find in session management recipe.
And then I need create my own social login?
weboux
01/27/2023, 6:23 PMI see. And did I write well with which table from you I need to create a relationship with my one?
weboux
01/27/2023, 6:26 PMand out of curiosity, "Well, not all of it" so what would I need to replacing and re implementating?
p
porcellus
01/27/2023, 9:00 PMhere it is: https://supertokens.com/docs/thirdpartyemailpassword/common-customizations/email-verification/about but it's not really intended to be used without an auth (emailpassword, thirdparty, etc) recipe.
if you are only using the session recipe then it only handles session management. you'd need to implement everything else basically - sign in/up, user management, etc.
porcellus
01/27/2023, 9:01 PMyep. You can check this page to see how our DB is set up: https://supertokens.com/docs/thirdpartyemailpassword/pre-built-ui/setup/database-setup/postgresql
w
weboux
01/27/2023, 9:51 PMaa because I wasn't finding. I understood wrong.
so it would be too much work, especially I already have a lof done.
weboux
01/27/2023, 9:53 PMI see. It'll be the most easy to do 🤔🙂
weboux
01/27/2023, 9:55 PMCould you write back on this question?
It's just out of curiosity.
weboux
01/27/2023, 9:56 PMMaybe I'll understand better your service too 🙂
p
porcellus
01/27/2023, 10:30 PMI think I've answered this above: we could handle session management and you'd have to implement basically everything else.
w
weboux
01/27/2023, 11:02 PMI meant this 🙂
p
porcellus
01/28/2023, 9:31 AMthat is the answer. you'd have to do everything besides session management.
porcellus
01/28/2023, 9:35 AMI don't really get why you need to store data in that specific table. If you have any specific issues I'll try to answer them, most likely they can be solved without modifying the users table supertokens interacts with.
w
weboux
01/28/2023, 10:03 AMI meant theoretically. In this way I learn too.
weboux
01/28/2023, 10:07 AMI like catalogue so all about something, I like have in 1 place. Because it would be nice if in the future, you could add during configuration a selection for the user table with the required tables and relations 🙂
p
porcellus
01/28/2023, 11:27 AMI'm not sure what you mean by theoretically.
porcellus
01/28/2023, 11:31 AMAs for using entirely custom tables to store our user data and making it configurable: I don't this is a strong enough use-case. It'd involve too much work and many non-obvious configuration options.
w
weboux
01/28/2023, 11:49 AMI mean this. I won't do, because I just want to know theoretically.
weboux
01/28/2023, 11:49 AM:)
weboux
01/28/2023, 11:53 AMAnd Thanks for your help :)
p
porcellus
01/28/2023, 12:25 PMno problem. 🙂
5 Views