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

Re: foreign data wrappers

From: Zheng Yang <zhengyang4k(at)gmail(dot)com>
To: Shiv <rama(dot)theone(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 02:07:11
Message-ID: 603812A0-F464-44AE-8A90-DF9BD1DC2DB9@gmail.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-students
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

Responses

pgsql-students by date

Next:From: ShivDate: 2011-03-25 04:56:40
Subject: Re: foreign data wrappers
Previous:From: ShivDate: 2011-03-25 00:53:10
Subject: Re: foreign data wrappers

pgsql-general by date

Next:From: Adrian KlaverDate: 2011-03-25 02:09:18
Subject: Re: Default permissions for CREATE SCHEMA/TABLE?
Previous:From: Yang ZhangDate: 2011-03-25 01:10:32
Subject: Re: Default permissions for CREATE SCHEMA/TABLE?

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