+1 for Leonel

On Wednesday, January 25, 2017 at 7:51:49 PM UTC-6, Dave S wrote:
>
>
>
> On Wednesday, January 25, 2017 at 4:31:20 PM UTC-8, Leonel Câmara wrote:
>>
>> web2py permissions not enough?
>>
>> If not, I guess you could make 2 applications which had 2 different 
>> users/roles in the same database, the user on the public facing application 
>> would have all privileges  revoked and then you would give it only exactly 
>> what you want to be public.
>>
>> See:
>>
>> https://support.chartio.com/knowledgebase/limit-postgresql-user-access-using-schema
>>
>> Make sure that the public application has migrate=False as that would 
>> probably go very wrong and be careful to define your models according to 
>> the views.
>>
>> Do understand that your requirement to have the public facing data be 
>> realtime makes it almost impossible for the public facing application to 
>> not influence the private one's performance. It would be much better if you 
>> could make it "near" realtime.
>>
>
>
> Exporting the public data to a second DB seems like a reasonable way to 
> deal with this, but is likely to be "near realtime" rather than "realtime". 
>  I've read about such things before, but haven't tried it anywhere.
>
> /dps
>
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
For more options, visit https://groups.google.com/d/optout.

Reply via email to