pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Thomas Good <tomg@admin.nrnet.org>
To: Josh Berkus <josh@agliodbs.com>
Cc: Horst Herb <hherb@malleenet.net.au>
Cc: pgsql-sql@postgresql.org
Subject: Re: Diferent databases on same query...
Date: Fri, 26 Oct 2001 13:41:55 -0400 (EDT)
Message-ID: <Pine.LNX.4.05.10110261332490.11428-100000@admin.nrnet.org> (raw)
In-Reply-To: <web-492833@davinci.ethosmedia.com>

On Fri, 26 Oct 2001, Josh Berkus wrote:

> Horst,
> 
> > There are many more good reasons to do so. Example from my own
> > domain, 
> > medicine:
> > Thus, we have multiple databases on multiple servers all depending on
> > each 
> > other. 
> 
> Your reasons all make sense.  What you need is not inter-database
> queries but a robust middleware layer, such as J2EE.   Your sort of
> situation is why middleware exists.

Josh,

I'm pretty sure Horst does this already - check out GNU Med.
(Hallo Horst, Viele Grüsse aus New York.  ;-)
I guess the problem is that the procedural language mentioned in
the original post has a few hurdles yet to manage.

BTW, I do this (within the context of very small scripts) using
perl DBI.  It is cake with Perl.  And - your code is relatively
portable.  Aside from certain Oracle idiosyncracies of course
(NVL, DECODE, SYSDATE...)

> If GreatBridge was still around, I'd reccommend you contact them, as I
> knwo they implemented a solution for your sort of situation.  However, I
> don't know who'd do it now.

What about RedHat?  Are they working on this?

Dieter (Simader) of SQL Ledger also does this sort of thing within
his product (which uses perl dbi): www.sql-ledger.org

Cheers
--------------------------------------------------------------------
              Saint Vincent Catholic Medical Centers                
--------------------------------------------------------------------
Thomas Good                          tomg@ { admin | q8 } .nrnet.org
Programmer/Analyst                              Phone:  718-818-5528 
Behavioral Health Services                      Fax:    718-818-5056  
Residential Services                            Mobile: 917-282-7359  
--------------------------------------------------------------------
/*         Rekordmeister ist nur der FC Bayern München!           */
--------------------------------------------------------------------




view thread (9+ messages)

Message-ID: <Pine.LNX.4.05.10110261332490.11428-100000@admin.nrnet.org>
Permalink:  ../Pine.LNX.4.05.10110261332490.11428-100000@admin.nrnet.org/
Also on:    postgresql.org/message-id/Pine.LNX.4.05.10110261332490.11428-100000@admin.nrnet.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: tomg@admin.nrnet.org, josh@agliodbs.com, hherb@malleenet.net.au
  Subject: Re: Diferent databases on same query...
  In-Reply-To: <Pine.LNX.4.05.10110261332490.11428-100000@admin.nrnet.org>
  References: <web-492833@davinci.ethosmedia.com> <Pine.LNX.4.05.10110261332490.11428-100000@admin.nrnet.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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