Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id A69549FA10E for ; Mon, 24 Sep 2007 12:37:56 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 35723-09 for ; Mon, 24 Sep 2007 12:37:52 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from smtp145.iad.emailsrvr.com (smtp145.iad.emailsrvr.com [207.97.245.145]) by postgresql.org (Postfix) with ESMTP id 3ABCD9FA11D for ; Mon, 24 Sep 2007 12:37:52 -0300 (ADT) Received: by relay4.r5.iad.mlsrvr.com (Authenticated sender: erik-AT-myemma.com) with ESMTP id 15063F29D; Mon, 24 Sep 2007 11:37:50 -0400 (EDT) In-Reply-To: <5254D9CA-E60E-4E51-ADEF-74154984F747@myemma.com> References: <5254D9CA-E60E-4E51-ADEF-74154984F747@myemma.com> Mime-Version: 1.0 (Apple Message framework v752.3) Content-Type: text/plain; charset=ISO-8859-1; delsp=yes; format=flowed Message-Id: Cc: Stefan Arentz , "Hiltibidal, Robert" , pgsql-sql@postgresql.org Content-Transfer-Encoding: quoted-printable From: Erik Jones Subject: Re: Many databases Date: Mon, 24 Sep 2007 10:37:27 -0500 To: Erik Jones X-Mailer: Apple Mail (2.752.3) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/151 X-Sequence-Number: 29364 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 =20 >> 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 =20 > problem with multiple databases is keeping global meta data for all =20= > of your customers together in a simple way. Oh, yeah, I forgot to mention separate schemas as well. 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