docs: add a guide on multi-tenant modelling with hasura

[coco98]

We should talk about the different approaches, how-to with hasura and their trade-offs:

1. Different databases
2. Different schemas
3. tenant_id (shard column) type modelling

[richardgirges]

Really interested to see how we can do this with different databases. Is there any existing information already out there on that?

[mnlbox]

@coco98 very interesting. Any plan for this?

[bjensen]

I would like to know about this as well..

[undefinedExpert]

Any plans to support this? Would be really helpful to have that!

[petecorreia-appital]

This would be massively helpful. Is this stalled?

[marionschleifer]

@petecorreia-appital no this is not stalled. We'll work on this in the next weeks and hope to publish soon 🙂

[petecorreia-appital]

@marionschleifer that's amazing! thank you all at hasura for the hard work and please remember to take it easy, all this can wait in light of the pandemic. stay safe!

[mubaidr]

Looking forward to it, especially the 3. tenant_id (shard column) type modelling, this will add support for citus data: https://www.citusdata.com/use-cases/multi-tenant-apps

[GavinRay97]

I wrote a gist summarized from a conversation with @leoalves and another Discord member about how to do Organization-based/Multi-tenant permissions modeling without the use of X-Hasura-Organization-Id or other session variables that some may find useful:

https://gist.github.com/GavinRay97/d7b8805078a47e00001e58eb8b1027b9

[tirumaraiselvan]

Hey folks,

This blogpost covers multi-tenancy using Hasura Authz quite comprehensively (also include Gavin's gist above): https://hasura.io/blog/authorization-rules-for-multi-tenant-system-google-cloud/

Hope this helps.

[MarcusBondezan]

I'm currently defining an app architecture. A documentation like that would help me a lot! I'm looking forward to study it! :clap: :smiley: