Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 0BB181337EF8 for ; Mon, 21 Mar 2011 16:33:44 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 62485-02-2 for ; Mon, 21 Mar 2011 19:33:37 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from cdptpa-omtalb.mail.rr.com (cdptpa-omtalb.mail.rr.com [75.180.132.123]) by mail.postgresql.org (Postfix) with ESMTP id 5DE281337C40 for ; Mon, 21 Mar 2011 15:45:38 -0300 (ADT) X-Authority-Analysis: v=1.1 cv=r4yJ8ACLDmU9N8MfnU6qGSvboKzSN9UnPAeXToqJDNE= c=1 sm=0 a=YOqqrsh--ucA:10 a=r6Jiw2x_onsA:10 a=8nJEP1OIZ-IA:10 a=qCTYjJJ2g1SgQhsHZAUATw==:17 a=pGLkceISAAAA:8 a=epTmVMiNAAAA:8 a=HjYBxie0M1rm7r0VM04A:9 a=Kg5k_ADc8ylYZVRJYj-uysvFersA:4 a=wPNLvfGTeEIA:10 a=p2bXo2kYDEUA:10 a=MSl-tDqOz04A:10 a=qCTYjJJ2g1SgQhsHZAUATw==:117 X-Cloudmark-Score: 0 X-Originating-IP: 98.27.48.207 Received: from [98.27.48.207] ([98.27.48.207:56637] helo=[192.168.10.104]) by cdptpa-oedge01.mail.rr.com (envelope-from ) (ecelerity 2.2.3.46 r()) with ESMTP id 28/86-09483-1DC978D4; Mon, 21 Mar 2011 18:45:37 +0000 Message-ID: <4D879CD0.5030803@dunslane.net> Date: Mon, 21 Mar 2011 14:45:36 -0400 From: Andrew Dunstan User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.2.13) Gecko/20101209 Fedora/3.1.7-0.35.b3pre.fc13 Lightning/1.0b3pre Thunderbird/3.1.7 MIME-Version: 1.0 To: Selena Deckelmann CC: Zheng Yang , pgsql-students@postgresql.org Subject: Re: foreign data wrappers References: <690867AB-C50B-4354-91D0-8A0811639C4C@gmail.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201103/6 X-Sequence-Number: 147 On 03/21/2011 12:57 PM, Selena Deckelmann wrote: > Hi! > > On Mon, Mar 21, 2011 at 5:17 AM, Zheng Yang wrote: > >> in the GSOC wiki, there is a potential project idea mentioning "Write >> Foreign Data Wrappers >> for several external data sources (ODBC, SQL Server, Oracle, MySQL, >> CouchDB, Redis, etc.)" >> Can anyone help explain how these wrapper are going to be like? > Have a look at http://wiki.postgresql.org/images/4/4c/SQLMED-FOSDEM2009.pdf > for starters. See if you can review that and come back with more > specific questions. > > There are a few community members interested in seeing this move > forward, so this project is likely a great one for GSoC. > > My suggestion would be to pick just one or two for this summer's project. > Yes, but 9.1 *has* actual FDWs. The best thing to do (other than attending my talk on Thursday :-) ) is to look at the file_fdw module in git head, to see an actual working example. cheers andrew