Multi-tenancy
Hey, we are trying to implement an use-case in our project and I need help on how to do it.
We have an app that needs a environment for each user (a schema). And this schema has multiple (more than 20) tables. The authentication is made by an config schema that has a table that stores user credentials and his schema name. All user-enviroments are the same, so I need that every change that I do, will propagate to all of them.
My problem is, how can I achieve this?
We used to use Prisma, but it looks like it doesnt support this use-case, so we are studying to see if we can use Drizzle, but it seems like it cant support it either :/
We have an app that needs a environment for each user (a schema). And this schema has multiple (more than 20) tables. The authentication is made by an config schema that has a table that stores user credentials and his schema name. All user-enviroments are the same, so I need that every change that I do, will propagate to all of them.
My problem is, how can I achieve this?
We used to use Prisma, but it looks like it doesnt support this use-case, so we are studying to see if we can use Drizzle, but it seems like it cant support it either :/
