Re: Many databases - Mailing list pgsql-sql

From Erik Jones
Subject Re: Many databases
Date
Msg-id AE22AA35-EA55-4B05-9012-FE07EBD70D56@myemma.com
Whole thread Raw
In response to Re: Many databases  (Erik Jones <erik@myemma.com>)
List pgsql-sql
On Sep 23, 2007, at 11:56 PM, Erik Jones wrote:

>
> On Sep 21, 2007, at 6:16 PM, Stefan Arentz wrote:
>
>> Well I'm just toying with an idea. The problem I'm facing is that I
>> would like clients to only see the tuples that they have created and
>> own. I guess I'll just skip direct sql access to the db and write
>> some
>> API on top of it that manages the data. Not a big deal but it
>> complicates things :-)
>>
>
> You could do the same thing with views on those tables.  One
> problem with multiple databases is keeping global meta data for all
> of your customers together in a simple way.

Oh, yeah, I forgot to mention separate schemas as well.

Erik Jones

Software Developer | Emma®
erik@myemma.com
800.595.4401 or 615.292.5888
615.292.0777 (fax)

Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com




pgsql-sql by date:

Previous
From: ivan marchesini
Date:
Subject: foreign key problem
Next
From: chester c young
Date:
Subject: problems with copy