pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
which is the best
4+ messages / 4 participants
[nested] [flat]

* which is the best
@ 2006-04-17 02:42 slackman@unika.ac.id
  2006-04-17 03:18 ` Re: which is the best Michael Fuhr <mike@fuhr.org>
  0 siblings, 1 reply; 4+ messages in thread

From: slackman@unika.ac.id @ 2006-04-17 02:42 UTC (permalink / raw)
  To: pgsql-admin; +Cc: tim@proximity.com.au

hii all,
Now I have 3 database A,B,C is working in Interbase v 5.6,
but Interbas v 5.6 is no longger can hold what the client wants,
I will conver it in Postgresql, I need your advice which is the
bertter result: 

(1):
 unika (schema)
    |
    |------ A
    |------------ B
    |------------------- C

(2) create database A, create database B, create database C 

thank you all 




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: which is the best
  2006-04-17 02:42 which is the best slackman@unika.ac.id
@ 2006-04-17 03:18 ` Michael Fuhr <mike@fuhr.org>
  2006-04-17 10:00   ` Re: which is the best Guido Neitzer <guido.neitzer@pharmaline.de>
  2006-04-17 10:28   ` Re: which is the best Juan Miguel <juanmime@ono.com>
  0 siblings, 2 replies; 4+ messages in thread

From: Michael Fuhr @ 2006-04-17 03:18 UTC (permalink / raw)
  To: slackman@unika.ac.id; +Cc: pgsql-admin

On Mon, Apr 17, 2006 at 09:42:59AM +0700, slackman@unika.ac.id wrote:
> Now I have 3 database A,B,C is working in Interbase v 5.6,
> but Interbas v 5.6 is no longger can hold what the client wants,
> I will conver it in Postgresql, I need your advice which is the
> bertter result: 
> 
> (1):
> unika (schema)
>    |
>    |------ A
>    |------------ B
>    |------------------- C
> 
> (2) create database A, create database B, create database C 

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.

-- 
Michael Fuhr



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: which is the best
  2006-04-17 02:42 which is the best slackman@unika.ac.id
  2006-04-17 03:18 ` Re: which is the best Michael Fuhr <mike@fuhr.org>
@ 2006-04-17 10:00   ` Guido Neitzer <guido.neitzer@pharmaline.de>
  1 sibling, 0 replies; 4+ messages in thread

From: Guido Neitzer @ 2006-04-17 10:00 UTC (permalink / raw)
  To: Michael Fuhr <mike@fuhr.org>; +Cc: slackman@unika.ac.id; pgsql-admin

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

Attachments:

  smime.p7s (application/pkcs7-signature, 2.4K) download

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: which is the best
  2006-04-17 02:42 which is the best slackman@unika.ac.id
  2006-04-17 03:18 ` Re: which is the best Michael Fuhr <mike@fuhr.org>
@ 2006-04-17 10:28   ` Juan Miguel <juanmime@ono.com>
  1 sibling, 0 replies; 4+ messages in thread

From: Juan Miguel @ 2006-04-17 10:28 UTC (permalink / raw)
  To: pgsql-admin

Michael Fuhr escribió:

>On Mon, Apr 17, 2006 at 09:42:59AM +0700, slackman@unika.ac.id wrote:
>  
>
>>Now I have 3 database A,B,C is working in Interbase v 5.6,
>>but Interbas v 5.6 is no longger can hold what the client wants,
>>    
>>
Sure ?
Before thinking to change the database, have you test firebird database 
? visit "http://www.firebirdsql.org/";.
I tested it two years ago on linux. Postgres offers me better things 
than Interbase/Firebird, but if you have a 5.6 Interbase database, 
perhaps you should try Interbase before, because it's the natural open 
source evolution of Interbase.
You should investigate what you can loose and win when you change the 
database (application code, SQL queries, DB drivers, triggers, stored 
procedures, OS plataform, DB utilities and administation tools, etc), 
before doing it.

Luck.



^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2006-04-17 10:28 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-04-17 02:42 which is the best slackman@unika.ac.id
2006-04-17 03:18 ` Michael Fuhr <mike@fuhr.org>
2006-04-17 10:00   ` Guido Neitzer <guido.neitzer@pharmaline.de>
2006-04-17 10:28   ` Juan Miguel <juanmime@ono.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