[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-general
Subject: Re: PL/java
From: David Goodenough <david.goodenough () btconnect ! com>
Date: 2020-12-08 10:46:28
Message-ID: 4280243.LvFx2qVVIh () continuum
[Download RAW message or body]
As of Java-16 there is a replacement for JNI which allows direct calling of native interfaces
without the need for hand coded stub code.
On Monday, 7 December 2020 22:10:01 GMT Martin Gainty wrote:
> Nota Bene:
> Almost all official interfaces to/from Oracle are coded in Java
> FWIK google's implementations are 95% python
> (although you would need to understand JSON formatting for import/export
> requirements) for those reasons i tread lightly before disparaging either
> language
>
> Going Forward:
> try to implement PL/SQL that rob/joshua mentioned
> if you're calling no-joy after implementing PL/SQL
> then we can take a look at interfacing to Postgres ETL binaries with a JNI
> interface provided the JNI is spot on with signatures for each referenced
> function
>
> Un Saludo
> m
>
> ________________________________
> From: Rob Sargent <robjsargent@gmail.com>
> Sent: Monday, December 7, 2020 11:16 AM
> To: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
> Subject: Re: PL/java
>
> On 12/7/20 8:25 AM, Adrian Klaver wrote:
> > On 12/7/20 7:18 AM, Hemil Ruparel wrote:
> >> I want to say this. I never liked any extension language. It's like
> >> Java is not meant to interact with databases.
> >
> > The JDBC folks might disagree.
>
> That interaction is strictly sql to db, data to app. As it should be.
[Attachment #3 (unknown)]
<html><head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
</head>
<body><p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">As of \
Java-16 there is a replacement for JNI which allows direct calling of native \
interfaces without the need for hand coded stub code.</p> <br><p \
style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">On Monday, 7 \
December 2020 22:10:01 GMT Martin Gainty wrote:</p> <p \
style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> Nota \
Bene:</p> <p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> \
Almost all official interfaces to/from Oracle are coded in Java</p> <p \
style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> FWIK google's \
implementations are 95% python</p> <p \
style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> (although you \
would need to understand JSON formatting for import/export</p> <p \
style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> requirements) \
for those reasons i tread lightly before disparaging either</p> <p \
style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> language</p> \
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> </p> <p \
style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> Going \
Forward:</p> <p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> \
try to implement PL/SQL that rob/joshua mentioned</p> <p \
style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> if you're \
calling no-joy after implementing PL/SQL</p> <p \
style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> then we can \
take a look at interfacing to Postgres ETL binaries with a JNI</p> <p \
style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> interface \
provided the JNI is spot on with signatures for each referenced</p> <p \
style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> function</p> \
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> </p> <p \
style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> Un Saludo</p> \
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> m</p> <p \
style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> </p> <p \
style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> \
________________________________</p> <p \
style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> From: Rob \
Sargent <robjsargent@gmail.com></p> <p \
style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> Sent: Monday, \
December 7, 2020 11:16 AM</p> <p \
style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> To: \
pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org></p> <p \
style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> Subject: Re: \
PL/java</p> <p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> \
</p> <p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> On \
12/7/20 8:25 AM, Adrian Klaver wrote:</p> <p \
style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > On \
12/7/20 7:18 AM, Hemil Ruparel wrote:</p> <p \
style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> >> I \
want to say this. I never liked any extension language. It's like</p> <p \
style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> >> Java \
is not meant to interact with databases.</p> <p \
style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > </p> <p \
style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > The JDBC \
folks might disagree.</p> <p \
style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> </p> <p \
style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> That \
interaction is strictly sql to db, data to app. As it should be.</p> \
<br><br></body> </html>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic