pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedMany databases
5+ messages / 3 participants
[nested] [flat]
* Many databases
@ 2007-09-21 22:39 Stefan Arentz <stefan.arentz@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: Stefan Arentz @ 2007-09-21 22:39 UTC (permalink / raw)
To: pgsql-sql
I'm in a strange situation where it makes more sense to give each user
it's own database instead of having a single database with users and
permissions. How does PG deal with that? Is it a problem to have have
say a thousand small databases?
S.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Many databases
@ 2007-09-21 23:16 Stefan Arentz <stefan.arentz@gmail.com>
parent: Stefan Arentz <stefan.arentz@gmail.com>
0 siblings, 2 replies; 5+ messages in thread
From: Stefan Arentz @ 2007-09-21 23:16 UTC (permalink / raw)
To: Hiltibidal, Robert <Robert.Hiltibidal@argushealth.com>; +Cc: pgsql-sql
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 :-)
S.
On 9/22/07, Hiltibidal, Robert <Robert.Hiltibidal@argushealth.com> wrote:
> How is this possible?
>
> It smacks of a security issue which there are many proven solutions to
> that.
>
> Would you elaborate?
>
> -----Original Message-----
> From: pgsql-sql-owner@postgresql.org
> [mailto:pgsql-sql-owner@postgresql.org] On Behalf Of Stefan Arentz
> Sent: Friday, September 21, 2007 5:39 PM
> To: pgsql-sql@postgresql.org
> Subject: [SQL] Many databases
>
> I'm in a strange situation where it makes more sense to give each user
> it's own database instead of having a single database with users and
> permissions. How does PG deal with that? Is it a problem to have have
> say a thousand small databases?
>
> S.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>
>
> PRIVILEGED AND CONFIDENTIAL
> This email transmission contains privileged and confidential information intended only for the use of the individual or entity named above. If the reader of the email is not the intended recipient or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any use, dissemination or copying of this email transmission is strictly prohibited by the sender. If you have received this transmission in error, please delete the email and immediately notify the sender via the email return address or mailto:postmaster@argushealth.com. Thank you.
>
>
>
>
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Many databases
@ 2007-09-21 23:33 Richard Broersma Jr <rabroersma@yahoo.com>
parent: Stefan Arentz <stefan.arentz@gmail.com>
1 sibling, 0 replies; 5+ messages in thread
From: Richard Broersma Jr @ 2007-09-21 23:33 UTC (permalink / raw)
To: Stefan Arentz <stefan.arentz@gmail.com>; +Cc: pgsql-sql
--- Stefan Arentz <stefan.arentz@gmail.com> 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 :-)
The veil project already does this.
Regards,
Richard Broersma Jr.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Many databases
@ 2007-09-24 04:56 Erik Jones <erik@myemma.com>
parent: Stefan Arentz <stefan.arentz@gmail.com>
1 sibling, 1 reply; 5+ messages in thread
From: Erik Jones @ 2007-09-24 04:56 UTC (permalink / raw)
To: Stefan Arentz <stefan.arentz@gmail.com>; +Cc: Hiltibidal, Robert <Robert.Hiltibidal@argushealth.com>; 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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Many databases
@ 2007-09-24 15:37 Erik Jones <erik@myemma.com>
parent: Erik Jones <erik@myemma.com>
0 siblings, 0 replies; 5+ messages in thread
From: Erik Jones @ 2007-09-24 15:37 UTC (permalink / raw)
To: Erik Jones <erik@myemma.com>; +Cc: Stefan Arentz <stefan.arentz@gmail.com>; Hiltibidal, Robert <Robert.Hiltibidal@argushealth.com>; 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
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2007-09-24 15:37 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-09-21 22:39 Many databases Stefan Arentz <stefan.arentz@gmail.com>
2007-09-21 23:16 ` Stefan Arentz <stefan.arentz@gmail.com>
2007-09-21 23:33 ` Richard Broersma Jr <rabroersma@yahoo.com>
2007-09-24 04:56 ` Erik Jones <erik@myemma.com>
2007-09-24 15:37 ` Erik Jones <erik@myemma.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox