Hey, there is a way to append ST tables to existing database? I used prisma ORM and im not sure how ...

damian_w

11/18/2022, 1:40 PM

Hey, there is a way to append ST tables to existing database? I used prisma ORM and im not sure how can i update my migration to append ST tables

rp_st

11/18/2022, 1:41 PM

hey @damian_w

rp_st

11/18/2022, 1:42 PM

the tables are added to your database automatically via the supertokens core

rp_st

11/18/2022, 1:42 PM

but either way, here is the schema we use: https://supertokens.com/docs/thirdpartyemailpassword/pre-built-ui/setup/database-setup/mysql

rp_st

11/18/2022, 1:42 PM

and for postgresql: https://supertokens.com/docs/thirdpartyemailpassword/pre-built-ui/setup/database-setup/postgresql

damian_w

11/18/2022, 2:34 PM

Hmm..i filled connectionURI with my postgres URI and when try to signIn i get

Copy code

[Nest] 7372  - 18.11.2022, 15:33:05   ERROR [ExceptionsHandler] getaddrinfo ENOTFOUND postgresql
Error: getaddrinfo ENOTFOUND postgresql
    at GetAddrInfoReqWrap.onlookup [as oncomplete] (node:dns:69:26)

damian_w

11/18/2022, 2:35 PM

i use my own, clean postgre instalation

rp_st

11/19/2022, 3:29 AM

What’s the connection uri you added? Also, are you using docker for supertokens and for PostgreSQL?

12/03/2023, 3:52 AM

damian_w , if you're using prisma, you can create your tables in database, and run prisma db pull to populate the schema.

49 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).