Re: [GENERAL] PL/Java (was: stored procedures)

> Function in Postgres can be written in PL/pgSQL (similar to PL/SQL),
> PL/Perl, PL/Tcl, PL/Python, PL/sh, PL/R (similar to S-Plus statistical
> language), and I think there might be a PL/Java available somewhere.

I searched the list archives and Google - came up with some extensive discussions about PL/Java in August 2001, but it doesn't look like it ever got going. I would be very interested in contributing to a PL/Java project - is there anything happening right now?

Roman

Roman Fail wrote:
> I searched the list archives and Google - came up with some extensive
> discussions about PL/Java in August 2001, but it doesn't look like it
> ever got going. I would be very interested in contributing to a
> PL/Java project - is there anything happening right now?

I'm not really sure -- that thread is probably the one I remembered.
Maybe someone else can chime in...

Joe

On Thu, 2003-03-13 at 13:31, Joe Conway wrote:
> I'm not really sure -- that thread is probably the one I remembered.
> Maybe someone else can chime in...

http://pljava.sourceforge.net/

BTW, you can also write stored procedures in Ruby, C, and SQL.

Cheers,

Neil

--
Neil Conway <neilc(at)samurai(dot)com> || PGP Key ID: DB3C29FC

Neil Conway wrote:
> http://pljava.sourceforge.net/

Interesting -- I did a quick search on sourceforge, but I guess it was a
bit too quick.

> BTW, you can also write stored procedures in Ruby, C, and SQL.

I wasn't aware of Ruby, but I don't know how I could possibly have
forgotten to mention C and SQL!

I wonder if we shouldn't have a spot on techdocs with links to all of
the Postgres PLs all in one place? It makes for an impressive list; for
the record:

Available PostgreSQL Procedural Languages
==========================================
C
http://www.us.postgresql.org/users-lounge/docs/7.3/postgres/xfunc-c.html

SQL
http://www.us.postgresql.org/users-lounge/docs/7.3/postgres/xfunc-sql.html

PL/pgSQL
http://www.us.postgresql.org/users-lounge/docs/7.3/postgres/plpgsql.html

PL/Perl
http://www.us.postgresql.org/users-lounge/docs/7.3/postgres/plperl.html

PL/Tcl
http://www.us.postgresql.org/users-lounge/docs/7.3/postgres/pltcl.html

PL/Python
http://www.us.postgresql.org/users-lounge/docs/7.3/postgres/plpython.html

PL/sh
http://webmail.postgresql.org/~petere/plsh.html

PL/R
http://www.joeconway.com/plr/

PL/Java
http://pljava.sourceforge.net/

PL/Ruby
http://raa.ruby-lang.org/list.rhtml?name=pl-ruby

==========================================

Joe

Neil,

> I wonder if we shouldn't have a spot on techdocs with links to all of
> the Postgres PLs all in one place? It makes for an impressive list; for
> the record:

I'd put this up, but TECHDOCS/GUIDES appears to be down. Justin?

--
Josh Berkus
Aglio Database Solutions
San Francisco

Since people didn't like referencing all of these in the postgresql
docs, I used to add a notes at the bottom of the idocs, but I guess it
slipped off my radar. That being the case, I've added a page for this on
the techdocs site, available at
http://techdocs.postgresql.org/guides/Pgplmeta

If the language maintainers would be willing to look over the
information and make any corrections that would be great.

Robert Treat

On Thu, 2003-03-13 at 14:04, Joe Conway wrote:
> Neil Conway wrote:
> > http://pljava.sourceforge.net/
>
> Interesting -- I did a quick search on sourceforge, but I guess it was a
> bit too quick.
>
> > BTW, you can also write stored procedures in Ruby, C, and SQL.
>
> I wasn't aware of Ruby, but I don't know how I could possibly have
> forgotten to mention C and SQL!
>
> I wonder if we shouldn't have a spot on techdocs with links to all of
> the Postgres PLs all in one place? It makes for an impressive list; for
> the record:
>
> Available PostgreSQL Procedural Languages
> ==========================================
> C
> http://www.us.postgresql.org/users-lounge/docs/7.3/postgres/xfunc-c.html
>
> SQL
> http://www.us.postgresql.org/users-lounge/docs/7.3/postgres/xfunc-sql.html
>
> PL/pgSQL
> http://www.us.postgresql.org/users-lounge/docs/7.3/postgres/plpgsql.html
>
> PL/Perl
> http://www.us.postgresql.org/users-lounge/docs/7.3/postgres/plperl.html
>
> PL/Tcl
> http://www.us.postgresql.org/users-lounge/docs/7.3/postgres/pltcl.html
>
> PL/Python
> http://www.us.postgresql.org/users-lounge/docs/7.3/postgres/plpython.html
>
> PL/sh
> http://webmail.postgresql.org/~petere/plsh.html
>
> PL/R
> http://www.joeconway.com/plr/
>
> PL/Java
> http://pljava.sourceforge.net/
>
> PL/Ruby
> http://raa.ruby-lang.org/list.rhtml?name=pl-ruby
>
> ==========================================
>
> Joe
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html

Robert Treat wrote:
> http://techdocs.postgresql.org/guides/Pgplmeta
>
> If the language maintainers would be willing to look over the
> information and make any corrections that would be great.

Looks good to me. One minor note -- the URLs that I gave in the original
email (and replicated on the above page) are to one specific mirror site:

http://www.us.postgresql.org/users-lounge/docs/7.3/postgres/<whatever>

It would probably be better to have them point to the corresponding
idocs pages.

Joe

>>>>> "R" == Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> writes:

R> http://techdocs.postgresql.org/guides/Pgplmeta

plruby is available for PostgreSQL >= 6

Guy Decoux

Thanks Guy. I've updated that info and swapped the links to the idocs
version instead of the mirror site as Joe suggested. Please note that if
you guys ever want to make a change there is an "edit this page" link at
the top so you don't have to wait on anyone.

Robert Treat

On Tue, 2003-03-25 at 05:49, ts wrote:
> >>>>> "R" == Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> writes:
>
> R> http://techdocs.postgresql.org/guides/Pgplmeta
>
> plruby is available for PostgreSQL >= 6
>
>
>
> Guy Decoux
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly

Hi!

I think we should not use the word "pl/java" since java is a trademark
of sun.
PL/pgJ is going to be distributed under Apache license. It is compatible
with 7.2+

Thanks,
Laszlo Hornyak

Joe Conway wrote:

> Robert Treat wrote:
>
>> http://techdocs.postgresql.org/guides/Pgplmeta
>>
>> If the language maintainers would be willing to look over the
>> information and make any corrections that would be great.
>
>
> Looks good to me. One minor note -- the URLs that I gave in the
> original email (and replicated on the above page) are to one specific
> mirror site:
>
> http://www.us.postgresql.org/users-lounge/docs/7.3/postgres/<whatever>
>
> It would probably be better to have them point to the corresponding
> idocs pages.
>
> Joe
>
>
>
>
> .
>