I would suggest you use a different database (a different connection
string) for each hospital depending on the hostname.
<hospital>.domain.com
import re; regex = re.compile('.*\://(.*?)/.*
db = DAL('postgresq://..../%s' %
regex.match(request.env.http_host).group(1))
In this way you keep your data separate (which is better for security) and
will allow you scale horizontally by setting up multiple db server
instances.
On Wednesday, 27 June 2012 18:07:44 UTC-5, Ovidio Marinho wrote:
>
> I am making an application to control government medical appointments
> in more than fifty hospitals all use a single postgres database, but
> each hospital must have administrator access, Operator and User, and
> each access must be made with the view of their unique data .
>
> is this.
>
>
>
