From: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
---|---|
To: | Dave Cramer <pg(at)fastcrypt(dot)com> |
Cc: | Atri Sharma <atri(dot)jiit(at)gmail(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>, pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: [JDBC] Regarding GSoc Application |
Date: | 2012-04-09 15:55:15 |
Message-ID: | CAHyXU0z+JL+PBSpi8hf+=EsxcYFwUeAhKsVcrW6JVrmq+r-B3A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-jdbc |
On Mon, Apr 9, 2012 at 10:47 AM, Dave Cramer <pg(at)fastcrypt(dot)com> wrote:
> How will the user access this? Will it be a normal query through the
> existing API ? Will it be a private postgresql API ?
>
> How will they set it up ? It appears complicated as you have to setup
> PL/Java as well
Yeah -- it will run through pl/java (at least, that's the idea). What
pl/java brings to the table is well thought out integration of the JVM
to postgres so that you can invoke java as functions from postgres.
PL/java of course is a heavy dependency and non-trivial to set up and
install. But to access the jdbc from postgres I think it's the
easiest way forward. Straight JNI to the JVM from FDW might be a
better/cleaner route but we haven't done the research to see exactly
what's involved there. I suspect that invoking java from postgres is
non trivial any way you slice it and that's not a wheel worth
re-inventing.
In other words, the basic idea is to do two things: a dblink-ish
wrapper for JDBC via pl/java and a FDW wrapper through that via SPI.
Better ideas and criticism are welcome of course.
merlin
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Cramer | 2012-04-09 16:14:02 | Re: [JDBC] Regarding GSoc Application |
Previous Message | Dave Cramer | 2012-04-09 15:47:19 | Re: [JDBC] Regarding GSoc Application |
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Cramer | 2012-04-09 16:14:02 | Re: [JDBC] Regarding GSoc Application |
Previous Message | Dave Cramer | 2012-04-09 15:47:19 | Re: [JDBC] Regarding GSoc Application |