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

Re: [HACKERS] Regarding GSoc Application

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: [HACKERS] Regarding GSoc Application
Date: 2012-04-11 06:01:59
Message-ID: 4F851E57.5060802@hogranch.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-jdbc
On 04/10/12 10:44 PM, Atri Sharma wrote:
> We plan to call SQL through SPI from the FDW,which in turn would call
> >  the Pl/Java routine.

that seems overly complex.   SPI is an internal mechanism used by C 
functions that are called from SQL

why not just implement it as....

user application -> SQL -> PLjava FDW functions -> pljava code -> JDBC 
-> foreign database

(and of course, back to return the data from said foreign database)

this would look to the user very much like dblink looks now, and have 
similar security issues and mitigations.


-- 
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast


In response to

Responses

pgsql-hackers by date

Next:From: Atri SharmaDate: 2012-04-11 06:09:27
Subject: Re: [HACKERS] Regarding GSoc Application
Previous:From: Atri SharmaDate: 2012-04-11 05:44:13
Subject: Re: [HACKERS] Regarding GSoc Application

pgsql-jdbc by date

Next:From: Atri SharmaDate: 2012-04-11 06:09:27
Subject: Re: [HACKERS] Regarding GSoc Application
Previous:From: Atri SharmaDate: 2012-04-11 05:44:13
Subject: Re: [HACKERS] Regarding GSoc Application

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