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
0 Replies