orchestral / tenanti

[Package] Multi-tenant Database Schema Manager for Laravel
MIT License
587 stars 53 forks source link

Single database Multiple Schemas #40

Closed gabrielbuzziv closed 7 years ago

gabrielbuzziv commented 7 years ago

Is possible o manage the migrations in a single db multi schemas?

crynobone commented 7 years ago

I don't understand the question

gabrielbuzziv commented 7 years ago

In Postgree, i can have a single database with a lot of schemas. So i was thinking if is possible to manage this with this package.

You can read about this approach in this article http://www.summa.com/blog/2013/09/17/approaches-to-multi-tenancy

SEPARATE SCHEMA PER TENANT

crynobone commented 7 years ago

If someone submit a PR to handle this, shouldn't be a problem. I don't have the time to implement this on my own.

gabrielbuzziv commented 7 years ago

No problem, i was just asking if have support for this, thanks :P

crynobone commented 7 years ago

We have single database with "namespaced" table name, such as user_1_posts (formatting is optional). but not per postgres schema (not using Postgres).