2 ms·
Let's say I'm building a CRM and I want to have an "industry" or "cities" table that is the same across all tenants. I want a copy of cities in each tenant for
by rsweeney21 3y ago
Let's say I'm building a CRM and I want to have an "industry" or "cities" table that is the same across all tenants. I want a copy of cities in each tenant for referential integrity, but I also need to update it periodically across all tenants.
- infra_dev 3y agoGreat question. Nile supports shared tables for this purpose. Shared tables are regular tables that can be shared across all the tenants in another table. We have example use cases and how this works in Nile here https://www.thenile.dev/docs/tenant-sharing https://www.thenile.dev/docs/tenant-sharing. Let me know if this works for you.
- rsweeney21 3y agoThat sounds like exactly what I was looking for. Impressive!