Multi-tenant sample app

[cuckoonuck]

I am new to Lianja and my first project is to create an app for multiple tenants. That is, a single database is to be shared between multiple organizations or tenants, but the data for one tenant will be invisible to the other tenants, and vice versa. Thus, when a user logs in, the system needs to identify the organization to which the user belongs, and allow the user to only view or edit data pertaining to that tenant.

Is there any existing documentation about best practices for multi-tenant apps? I would find a sample multi-tenant app to be most helpful.

Thanks,

Alan

[barrymavin]

Hi Alan,

Are you building a desktop, web or mobile app?

For desktop apps on a LAN the tenancy is determined by the --tenancy command line switch.

For web and mobile apps the tenancy is determined by the "domain" of the authenticated user.

http://www.lianja.com/community/show...ight=Tenancies

Seperate databases are used for each tenant to better enforce security.

[cuckoonuck]

Thanks for the explanation, Barry. That makes sense. I am looking to deploy a web app.

Does the Standard Lianja Cloud Server license have any limitation on the number of databases? I assume the limitation of 250 user connections is across all databases combined, is that correct?

Alan

[barrymavin]

Hi Alan,

No there is no database limit.

Correct any connection limits are not related to databases just TCP/IP connections.

[StevenH]

Hi Alan,

I'm trying to develop a multi tenant app like you in 2015.

Were you ever provided documentation or sample app? I can't find anything but comments that Lianja supports multi tenant apps but not anything on how to build one.

If there is any info you can share, I would greatly appreciate it.

Thanks,
Steve

[yvonne.milne]

Hi Steve,

Please see Database Tenancies on the Lianja Documentation wiki.

Regards,

Yvonne