Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 4A59F9F9A2B for ; Mon, 24 Sep 2007 01:56:51 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 58509-04 for ; Mon, 24 Sep 2007 01:56:41 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from smtp115.iad.emailsrvr.com (smtp115.iad.emailsrvr.com [207.97.245.115]) by postgresql.org (Postfix) with ESMTP id C61E29F9A17 for ; Mon, 24 Sep 2007 01:56:42 -0300 (ADT) Received: by relay1.r1.iad.emailsrvr.com (Authenticated sender: erik-AT-myemma.com) with ESMTP id 849F744C0FA; Mon, 24 Sep 2007 00:56:41 -0400 (EDT) In-Reply-To: References: Mime-Version: 1.0 (Apple Message framework v752.3) Content-Type: text/plain; charset=ISO-8859-1; delsp=yes; format=flowed Message-Id: <5254D9CA-E60E-4E51-ADEF-74154984F747@myemma.com> Cc: "Hiltibidal, Robert" , pgsql-sql@postgresql.org Content-Transfer-Encoding: quoted-printable From: Erik Jones Subject: Re: Many databases Date: Sun, 23 Sep 2007 23:56:24 -0500 To: Stefan Arentz X-Mailer: Apple Mail (2.752.3) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/148 X-Sequence-Number: 29361 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 =20 with multiple databases is keeping global meta data for all of your =20 customers together in a simple way. Erik Jones Software Developer | Emma=AE 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