On GAE or Postgre SQL you can have MultiTenance and Namespaces (I am not sure how DAL deal with that)
I am developing a multitenant app, I am using the company_id approach -- Bruno Rocha [ About me: http://zerp.ly/rochacbruno ] On Fri, Apr 29, 2011 at 9:30 PM, villas <[email protected]> wrote: > Hi All, > > I would like to use a single web2py app for many companies using a > single DB. For simplicity, I would prefer to use just one set of > tables too. > > My planned strategy is: > 1. Define a 'company' table to have the basic company info. > 2. Add a company_id field to all other tables to keep data separate. > 3. Set a 'global' company_id variable when users access the app (I > could for example set this according to the sub-domain used). > > I am concerned about auth. I know that I can add the company_id field > to auth_users, but what about groups? Is there any way of making > them work? > > Are there any other considerations. Maybe someone might have a few > tips? > > Thanks, D >
