Re: Many databases - Mailing list pgsql-sql

From Erik Jones
Subject Re: Many databases
Date
Msg-id 5254D9CA-E60E-4E51-ADEF-74154984F747@myemma.com
Whole thread Raw
In response to Re: Many databases  ("Stefan Arentz" <stefan.arentz@gmail.com>)
Responses Re: Many databases
List pgsql-sql
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.

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: "Filip Rembiałkowski"
Date:
Subject: Re: How pull
Next
From: "Matt Magoffin"
Date:
Subject: Re: How pull