gqlgen-pg-todo-example icon indicating copy to clipboard operation
gqlgen-pg-todo-example copied to clipboard

Multi-tenancy table/column based

Open frederikhors opened this issue 5 years ago • 2 comments

It would be great to see how you solve the multi-tenancy problem, perhaps with one of the most comfortable ways for startups, the one with the tenant_id column in tables.

On the topic:

  • https://github.com/ErwinM/acts_as_tenant
  • https://github.com/influitive/apartment
  • https://github.com/go-pg/pg/issues/1179
  • https://stackoverflow.com/questions/60109795/auto-table-based-multi-tenancy-where-clause-in-postgresql

Thanks for your work.

frederikhors avatar Feb 10 '20 01:02 frederikhors

I'll add a bit of logic. The issue here is that typically multi tenancy involves database segregation and I kind of lean away from adding that much complexity as it will totally confuse newer folks

oshalygin avatar Feb 29 '20 20:02 oshalygin

typically multi tenancy involves database segregation

Not with tenant_id column in tables, right?

frederikhors avatar Mar 01 '20 17:03 frederikhors