Re: tables, where - Mailing list pgsql-general

From Richard Huxton
Subject Re: tables, where
Date
Msg-id 00cc01c0b86a$42c49ec0$1001a8c0@archonet.com
Whole thread Raw
In response to tables, where  (Martín Marqués <martin@bugs.unl.edu.ar>)
Responses Re: tables, where  (Rich Shepard <rshepard@appl-ecosys.com>)
List pgsql-general
From: "Martín Marqués" <martin@bugs.unl.edu.ar>

> Hi
> Is it a bad idea to put tables of different aplications, even if they have
> somethings in comun, in the same database?
>
> Saludos... :-)

Plus points :

+ If you need to join between tables you will *need* to do this

Minus points :

- You will need to make sure tables for application aa and bb don't have the
same name (so aa_contacts and bb_contacts)

- Security: make sure each application runs as a different user and only has
access to the tables is is supposed to.

- It is harder to back up individual applications' data

HTH

- Richard Huxton


pgsql-general by date:

Previous
From: Alvar Freude
Date:
Subject: Re: Inserting possible dublicate unique keys
Next
From: "Vilson farias"
Date:
Subject: Re: VARCHAR and TEXT