Skip site navigation (1) Skip section navigation (2)

Re: foreign data wrappers

From: Shiv <rama(dot)theone(at)gmail(dot)com>
To: Zheng Yang <zhengyang4k(at)gmail(dot)com>
Cc: Selena Deckelmann <selena(at)chesnok(dot)com>, Andrew Dunstan <andrew(at)dunslane(dot)net>, Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Guillaume Lelarge <guillaume(at)lelarge(dot)info>, pgsql-students <pgsql-students(at)postgresql(dot)org>
Subject: Re: foreign data wrappers
Date: 2011-03-25 04:56:40
Message-ID: AANLkTikfdekrOf9CeT07qgg5jc9f326FmaQSLszb+RhB@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-students
Haha.. that's great! Geographical proximity is always nice!

The Flickr example is a good question. I would be interested to know if that
is allowable (under the specifications for FDW)
Regards,
Shiv


On Fri, Mar 25, 2011 at 10:07 AM, Zheng Yang <zhengyang4k(at)gmail(dot)com> wrote:

> Thanks for the slides! As what's mentioned on one of the slides, the
> datasource of FDW can be virtually everything.
>
> So if there were a FDW for flickr API, the examples will be something like:
>
> 1) CREATE FOREIGN TABLE flickr_table (photo_id INT, ownerid INT, photo
> BLOB, text TEXT) SERVER flick_fdw OPTIONS (api_key 'AAAA');
> p.s. the text field is used as the keyword for free text search.
>
> when query from the table:
> 2) SELECT photo FROM flickr_table WHERE text = 'panda' LIMIT 0, 10;
>
> This will return top ten photos relevant to 'panda'. Is my understanding
> correct?
>
>
> I've briefly gone through the slides. Regarding the 6 callbacks, is that
> correct to say that a full table scan will always be performed irregardless
> of the sql statement,
> the FDW is blind to the sql query performed, right?
>
> And can anyone help explain what a planner is? What does this "provide cost
> estimates to planner" mean? Thanks!
>
> Hi Shiv, I am also from National University of Singapore!
>
> cheers,
> ZY
>
>
> On 25-Mar-2011, at 8:53 AM, Shiv wrote:
>
> Thank you for the slides. And yes FDW seems like a good project to get
> involved in especially if one (and by one I mean me) is knew to the Postgres
> codebase.
> Regards,
> Shiv
>
>
> On Fri, Mar 25, 2011 at 4:59 AM, Selena Deckelmann <selena(at)chesnok(dot)com>wrote:
>
>> And, Andrew's slides from his talk today are now available:
>> http://people.planetpostgresql.org/andrew/uploads/fdw2.pdf
>>
>> We really think the FDW projects would be great ones for GSoC. I know
>> we said that already. :)
>>
>> -selena
>>
>> --
>> Sent via pgsql-students mailing list (pgsql-students(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-students
>>
>
>
>

In response to

pgsql-students by date

Next:From: Selena DeckelmannDate: 2011-03-25 15:38:01
Subject: Re: foreign data wrappers
Previous:From: Zheng YangDate: 2011-03-25 02:07:11
Subject: Re: foreign data wrappers

pgsql-general by date

Next:From: Erik HesselinkDate: 2011-03-25 08:26:16
Subject: Re: Deadlock in libpq
Previous:From: Scott MarloweDate: 2011-03-25 04:04:30
Subject: Re: Out of memory

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group