Guidance on Creating a Multi-Tenant Application with PostgreSQL Schemas
Hi friends,
I’m working on creating a multi-tenant application where each tenant is assigned a separate PostgreSQL schema. I have a few questions and would greatly appreciate your insights:
What is the best approach to implement this kind of multi-tenancy?
I’m considering using an environment variable to manage the list of tenants. My goal is to ensure that when I run drizzle push, it modifies the schemas for all tenants automatically.
Is this approach feasible? Unfortunately, I couldn’t find much information online, so any advice or resources you could share would be immensely helpful.
Thank you very much for your time and support!
Best regards,
Montgomery Burns
I’m working on creating a multi-tenant application where each tenant is assigned a separate PostgreSQL schema. I have a few questions and would greatly appreciate your insights:
What is the best approach to implement this kind of multi-tenancy?
I’m considering using an environment variable to manage the list of tenants. My goal is to ensure that when I run drizzle push, it modifies the schemas for all tenants automatically.
Is this approach feasible? Unfortunately, I couldn’t find much information online, so any advice or resources you could share would be immensely helpful.
Thank you very much for your time and support!
Best regards,
Montgomery Burns
