From: | Hannu Krosing <hannu(at)krosing(dot)net> |
---|---|
To: | Rodrigo Gonzalez <rjgonzale(at)estrads(dot)com(dot)ar> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Michael Nolan <htfoot(at)gmail(dot)com>, "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: What Would You Like To Do? |
Date: | 2011-09-14 12:40:09 |
Message-ID: | 1316004009.9523.4.camel@hvost |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Tue, 2011-09-13 at 17:02 -0300, Rodrigo Gonzalez wrote:
> On 09/13/2011 04:52 PM, Tom Lane wrote:
> > Rodrigo Gonzalez<rjgonzale(at)estrads(dot)com(dot)ar> writes:
> >>> In a perfect world, it would be nice if one could do combined queries
> >>> linking a PostgreSQL database with an Oracle one, or a MySQL one,
> >> Can't you do that with FDW that is present in 9.1?
> > FDW provides the structure within which that will eventually be
> > possible, but there's no Oracle or MySQL wrapper today ... and there are
> > a lot of FDW restrictions that need to be worked on, too.
> >
> > regards, tom lane
> >
> They are both listed at wiki
> I know there are a lot of limitations....but OP message says "Even
> something that is several hundred times slower is going to be faster
> than merging the databases together. When I do this today, I have to
> write a program (in perl or php) that accesses both databases and merges
> it by hand."
> Am I wrong that this is currently possible using FDW?
Yes, to some extent.
And before FDW it was also possible (to some extent) using pl/python or
pl/perl to turn remote tables into set returning functions (and if
really needed then you could put a view over this function and almost
get "a remote view")
> Thanks
>
> Rodrigo Gonzalez
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | David Fetter | 2011-09-14 14:12:55 | Re: Sponsored development |
Previous Message | Hannu Krosing | 2011-09-14 12:12:33 | Re: What Would You Like To Do? |