Re: tables, where

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: tables, where
Дата
Msg-id 00cc01c0b86a$42c49ec0$1001a8c0@archonet.com
обсуждение исходный текст
Ответ на tables, where  (Martín Marqués <martin@bugs.unl.edu.ar>)
Ответы Re: tables, where
Список 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 по дате отправления:

Предыдущее
От: Alvar Freude
Дата:
Сообщение: Re: Inserting possible dublicate unique keys
Следующее
От: "Vilson farias"
Дата:
Сообщение: Re: VARCHAR and TEXT