On 17.04.2006, at 5:18 Uhr, Michael Fuhr wrote:
Which way is "better" depends on your access patterns. PostgreSQL doesn't support cross-database queries (except via functions like dblink), so if you need to join tables in one database with tables in another then you'll probably want make A, B, and C schemas in the same database. But if A, B, and C have no relationship with one another then you might want to isolate them as separate databases.
This is also dependant on the tool you use for accessing the databases. E.g. Apple WebObjects has no problems in working with relationships over severals databases, even if these databases are from different vendors. I have an application running, that joins information from a PostgreSQL, a FrontBase and an Oracle db in one "fetch" without any special voodoo going on on the database side. Only thing to have is that primary and foreign keys are in a compatible format.
I think this question can't be answered correctly without specific knowledge about the whole environment.
cug -- PharmaLine, Essen, GERMANY Software and Database Development
Attachment:
smime.p7s
Description: S/MIME cryptographic signature
