Обсуждение: pl/java status
is pl/java kind of dead? I don't see much activity since years ago. I note the pgfoundry page, http://pgfoundry.org/projects/pljava/?readme the link to the project home page http://wiki.tada.se/display/pljava/Home is broken this page seems quite out of date, talking about 1.1.0b1 released, but the foundry has 1.4.0 from 2008 that supports 8.3. only
John R Pierce wrote: > is pl/java kind of dead? I don't see much activity since years ago. > this page seems quite out of date, talking about 1.1.0b1 released, but > the foundry has 1.4.0 from 2008 that supports 8.3. only The last set of commits there was about 9 months ago, so it's not quite as dead as it appears. The code in CVS supports 8.4, there just hasn't been an official release in a while: http://pgfoundry.org/tracker/?func=detail&atid=335&aid=1010695&group_id=1000038 There are a couple of bugs to note at http://pgfoundry.org/tracker/?atid=334&group_id=1000038&func=browse like lack of support for JDK 1.6 and some known complier issues. -- Greg Smith 2ndQuadrant US Baltimore, MD PostgreSQL Training, Services and Support greg@2ndQuadrant.com www.2ndQuadrant.us
Greg Smith wrote: > John R Pierce wrote: >> is pl/java kind of dead? I don't see much activity since years ago. >> this page seems quite out of date, talking about 1.1.0b1 released, >> but the foundry has 1.4.0 from 2008 that supports 8.3. only > > The last set of commits there was about 9 months ago, so it's not > quite as dead as it appears. The code in CVS supports 8.4, there just > hasn't been an official release in a while: > http://pgfoundry.org/tracker/?func=detail&atid=335&aid=1010695&group_id=1000038 > > > There are a couple of bugs to note at > http://pgfoundry.org/tracker/?atid=334&group_id=1000038&func=browse > like lack of support for JDK 1.6 and some known complier issues. k. the guys who asked me are probably fine with java 1.5, but they definately want to use 8.4. on solaris 10 sparc :) does the package contain a test suite so I'm sure its functional if I build it?
John R Pierce wrote: > is pl/java kind of dead? I don't see much activity since years ago. I've been a bit worried about that myself. With OpenJDK and a GPL java, it makes a lot of sense to make Java a first-class PL in PostgreSQL. There's a fair bit of activity from Java-using users, and there's not really much reason Java should be restricted to the client side when the same language can work well server-side too. Not to mention all those Oracle users out there who're hooked on the stuff. Of course, Java is extremely thread-happy and PostgreSQL is extremely *not*, so perhaps there are reasons it doesn't seem to see much work. If it's anything like working on an embedded Python interpreter... -- Craig Ringer
On Wed, 2010-04-14 at 13:41 +0800, Craig Ringer wrote: > John R Pierce wrote: > > is pl/java kind of dead? I don't see much activity since years ago. > > I've been a bit worried about that myself. With OpenJDK and a GPL java, > it makes a lot of sense to make Java a first-class PL in PostgreSQL. > There's a fair bit of activity from Java-using users, and there's not > really much reason Java should be restricted to the client side when the > same language can work well server-side too. > > Not to mention all those Oracle users out there who're hooked on the stuff. > > Of course, Java is extremely thread-happy and PostgreSQL is extremely > *not*, so perhaps there are reasons it doesn't seem to see much work. If > it's anything like working on an embedded Python interpreter... Mostly, I think you will find that the back end developers aren't fond of Java and thus, it doesn't get much love. There is a reason that plPerl is king in this community (and I don't even like Perl). Joshua D. Drake > > -- > Craig Ringer > -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development, Engineering
Joshua D. Drake wrote:
> Mostly, I think you will find that the back end developers aren't fond
> of Java and thus, it doesn't get much love.
>
> There is a reason that plPerl is king in this community (and I don't
> even like Perl).
>
yeah, understood. I'm getting the request 2nd hand, from someone in a
TZ 14 hours different than my own (big company, many left hands)... so
info is trickling to me.
apparently the requester is comfortable programming in Java, and needs
to do some sorta-statistical calculations inside a function used in a
join of some 73 columns, which will get used by some reporting
software... the database in question was ported from a different rdbms
where this was a single flat table rather than a several way join, and
... well... thats all I know so far.
I've already suggested plpgsql and/or plperl.
I'm going to take a stab at building the CVS head of pljava on solaris
sparc 64bit tonight or tomorrow. it appears the 64bit community
builds of PG 8.4 were built with sunstudio 11, pg_config lists
....
CC = /net/grok/ontools/onnv-tools/SUNWspro/SS11/bin/cc
CPPFLAGS = -I/zstore/pgsql/pg84b1/proto/root_sparc/usr/include
-I/zstore/pgsql/pg84b1/proto/root_sparc/usr/sfw/include
-I/usr/sfw/include -I/usr/include/libxml2
-I/zstore/pgsql/pg84b1/proto/root_sparc/usr/include
-I/zstore/pgsql/pg84b1/proto/root_sparc/usr/sfw/include -I/usr/sfw/include
CFLAGS = -xO3 -xarch=v9 -dalign -Wc,-Qiselect-regsym=0 -xspace
-W0,-Lt -W2,-Rcond_elim -Xa -xildoff
CFLAGS_SL = -KPIC
LDFLAGS = -L/zstore/pgsql/pg84b1/proto/root_sparc/usr/lib/64
-L/zstore/pgsql/pg84b1/proto/root_sparc/usr/sfw/lib/64 -L/usr/sfw/lib/64
-L/usr/lib -L/zstore/pgsql/pg84b1/proto/root_sparc/usr/lib/64
-L/usr/lib/64 -L/usr/sfw/lib/64 -Wl,-R'/usr/postgres/8.4-community/lib/64'
It appears I have Sun C 5.9 at my disposal, not sure which version of
sunstudio this is from.
$ /opt/SUNWspro/bin/cc -V
cc: Sun C 5.9 SunOS_sparc Patch 124867-12 2009/11/22
wish me luck :)
On Thu, Apr 15, 2010 at 6:18 AM, John R Pierce <pierce@hogranch.com> wrote: > Joshua D. Drake wrote: >> >> Mostly, I think you will find that the back end developers aren't fond >> of Java and thus, it doesn't get much love. >> >> There is a reason that plPerl is king in this community (and I don't >> even like Perl). >> > Java2perl anyone ? http://search.cpan.org/~philcrow/Java-Javap-0.04/bin/java2perl6 (99% joking) And if you think positively a 14hour TZ difference is really only 10 if you go the other way. Cheers, -Damian
On Wed, 2010-04-14 at 13:41 +0800, Craig Ringer wrote: > John R Pierce wrote: > > is pl/java kind of dead? I don't see much activity since years ago. > > I've been a bit worried about that myself. With OpenJDK and a GPL java, > it makes a lot of sense to make Java a first-class PL in PostgreSQL. > There's a fair bit of activity from Java-using users, and there's not > really much reason Java should be restricted to the client side when the > same language can work well server-side too. > > Not to mention all those Oracle users out there who're hooked on the stuff. > > Of course, Java is extremely thread-happy and PostgreSQL is extremely > *not*, so perhaps there are reasons it doesn't seem to see much work. If > it's anything like working on an embedded Python interpreter... Mostly, I think you will find that the back end developers aren't fond of Java and thus, it doesn't get much love. There is a reason that plPerl is king in this community (and I don't even like Perl). Joshua D. Drake > > -- > Craig Ringer > -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development, Engineering
Damian Carey wrote: > On Thu, Apr 15, 2010 at 6:18 AM, John R Pierce <pierce@hogranch.com> wrote: > > Joshua D. Drake wrote: > >> > >> Mostly, I think you will find that the back end developers aren't fond > >> of Java and thus, it doesn't get much love. > >> > >> There is a reason that plPerl is king in this community (and I don't > >> even like Perl). > >> > > > > Java2perl anyone ? > http://search.cpan.org/~philcrow/Java-Javap-0.04/bin/java2perl6 > (99% joking) > > And if you think positively a 14hour TZ difference is really only 10 > if you go the other way. Is PL/J still being developed? I can't find it myself, but was curious. -- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com
Greg Smith wrote: > John R Pierce wrote: >> is pl/java kind of dead? I don't see much activity since years ago. >> this page seems quite out of date, talking about 1.1.0b1 released, >> but the foundry has 1.4.0 from 2008 that supports 8.3. only > > The last set of commits there was about 9 months ago, so it's not > quite as dead as it appears. The code in CVS supports 8.4, there just > hasn't been an official release in a while: > http://pgfoundry.org/tracker/?func=detail&atid=335&aid=1010695&group_id=1000038 > > > There are a couple of bugs to note at > http://pgfoundry.org/tracker/?atid=334&group_id=1000038&func=browse > like lack of support for JDK 1.6 and some known complier issues. is there a pl/java mail list? I've started to begin to commence to try to compile this stuff, I checked out the whole thing from CVS and when I run make, I'm getting an error that there's missing files in the postgres tree. I'm using the 8.4-community tarball for 64bit postgresql from the postgres website, am I instead going to have to build my own? ~/org.postgresql.pljava]$ gmake gmake[1]: Entering directory `/export/home/piercej/org.postgresql.pljava/build/classes/pljava' gmake[1]: Nothing to be done for `all'. gmake[1]: Leaving directory `/export/home/piercej/org.postgresql.pljava/build/classes/pljava' gmake[1]: Entering directory `/export/home/piercej/org.postgresql.pljava/build/classes/deploy' gmake[1]: Nothing to be done for `all'. gmake[1]: Leaving directory `/export/home/piercej/org.postgresql.pljava/build/classes/deploy' gmake[1]: Entering directory `/export/home/piercej/org.postgresql.pljava/build/objs' /usr/postgres/8.4-community/lib/64/pgxs/src/makefiles/pgxs.mk:59: /usr/postgres/8.4-community/lib/64/pgxs/src/makefiles/../../src/Makefile.global: No such file or directory /usr/postgres/8.4-community/lib/64/pgxs/src/makefiles/pgxs.mk:84: /usr/postgres/8.4-community/lib/64/pgxs/src/makefiles/../../src/Makefile.shlib: No such file or directory gmake[1]: *** No rule to make target `/usr/postgres/8.4-community/lib/64/pgxs/src/makefiles/../../src/Makefile.shlib'. Stop. gmake[1]: Leaving directory `/export/home/piercej/org.postgresql.pljava/build/objs' gmake: *** [c_all] Error 2 this is on Solaris 10, UltraSparc, with SunStudio installed. the postgres is the 8.4 community build, but I do note its only 8.4.1, and I really should upgrade it to 8.4.3.... ....20 mins later, upgraded to 8.4.3, and still getting same error. pg_config says... $ pg_config BINDIR = /usr/postgres/8.4-community/bin/64 DOCDIR = /usr/postgres/8.4-community/share/doc HTMLDIR = /usr/postgres/8.4-community/share/doc INCLUDEDIR = /usr/postgres/8.4-community/include PKGINCLUDEDIR = /usr/postgres/8.4-community/include INCLUDEDIR-SERVER = /usr/postgres/8.4-community/include/server LIBDIR = /usr/postgres/8.4-community/lib/64 PKGLIBDIR = /usr/postgres/8.4-community/lib/64 LOCALEDIR = /usr/postgres/8.4-community/share/locale MANDIR = /usr/postgres/8.4-community/man SHAREDIR = /usr/postgres/8.4-community/share SYSCONFDIR = /usr/postgres/8.4-community/etc PGXS = /usr/postgres/8.4-community/lib/64/pgxs/src/makefiles/pgxs.mk CONFIGURE = '--prefix=/usr/postgres/8.4-community' '--exec-prefix=/usr/postgres/8.4-community' '--bindir=/usr/postgres/8.4-community/bin/64' '--libexecdir=/usr/postgres/8.4-community/bin/64' '--sbindir=/usr/postgres/8.4-community/bin/64' '--datadir=/usr/postgres/8.4-community/share' '--sysconfdir=/usr/postgres/8.4-community/etc' '--mandir=/usr/postgres/8.4-community/man' '--libdir=/usr/postgres/8.4-community/lib/64' '--includedir=/usr/postgres/8.4-community/include' '--sharedstatedir=/var/postgres/8.4-community' '--localstatedir=/var/postgres/8.4-community' '--with-system-tzdata=/usr/share/lib/zoneinfo' '--enable-nls' '--with-docdir=/usr/postgres/8.4-community/doc' '--with-python' '--with-pam' '--with-openssl' '--with-libedit-preferred' '--with-libxml' '--with-libxslt' '--with-gssapi' '--enable-thread-safety' '--enable-dtrace' 'DTRACEFLAGS=-64' '--with-includes=/zstore/pgsql/pg84b1/proto/root_sparc/usr/include:/zstore/pgsql/pg84b1/proto/root_sparc/usr/sfw/include:/usr/sfw/include' '--with-tclconfig=/usr/sfw/lib' '--with-libs=/zstore/pgsql/pg84b1/proto/root_sparc/usr/lib/64:/zstore/pgsql/pg84b1/proto/root_sparc/usr/sfw/lib/64:/usr/lib/64:/usr/sfw/lib/64' 'CC=/opt/SUNWspro/SS11/bin/cc' 'CFLAGS=-xO3 -xarch=v9 -dalign -Wc,-Qiselect-regsym=0 -xspace -W0,-Lt -W2,-Rcond_elim -Xa -xildoff ' 'LDFLAGS=-L/zstore/pgsql/pg84b1/proto/root_sparc/usr/lib/64 -L/zstore/pgsql/pg84b1/proto/root_sparc/usr/sfw/lib/64 -L/usr/sfw/lib/64' 'CPPFLAGS=-I/zstore/pgsql/pg84b1/proto/root_sparc/usr/include -I/zstore/pgsql/pg84b1/proto/root_sparc/usr/sfw/include -I/usr/sfw/include' CC = /opt/SUNWspro/SS11/bin/cc CPPFLAGS = -I/zstore/pgsql/pg84b1/proto/root_sparc/usr/include -I/zstore/pgsql/pg84b1/proto/root_sparc/usr/sfw/include -I/usr/sfw/include -I/usr/include/libxml2 -I/zstore/pgsql/pg84b1/proto/root_sparc/usr/include -I/zstore/pgsql/pg84b1/proto/root_sparc/usr/sfw/include -I/usr/sfw/include CFLAGS = -xO3 -xarch=v9 -dalign -Wc,-Qiselect-regsym=0 -xspace -W0,-Lt -W2,-Rcond_elim -Xa -xildoff CFLAGS_SL = -KPIC LDFLAGS = -L/zstore/pgsql/pg84b1/proto/root_sparc/usr/lib/64 -L/zstore/pgsql/pg84b1/proto/root_sparc/usr/sfw/lib/64 -L/usr/sfw/lib/64 -L/usr/lib -L/zstore/pgsql/pg84b1/proto/root_sparc/usr/lib/64 -L/usr/lib/64 -L/usr/sfw/lib/64 -Wl,-R'/usr/postgres/8.4-community/lib/64' LDFLAGS_SL = LIBS = -lpgport -lxslt -lxml2 -lpam -lssl -lcrypto -lgss -lz -ledit -ltermcap -lnsl -lrt -lsocket -lm VERSION = PostgreSQL 8.4.3 .... my CC is... $ which cc /opt/SUNWspro/bin/cc $ cc -V cc: Sun C 5.9 SunOS_sparc Patch 124867-12 2009/11/22 usage: cc [ options] files. Use 'cc -flags' for details
On Wed, 2010-04-14 at 22:53 -0400, Bruce Momjian wrote: > Damian Carey wrote: > > On Thu, Apr 15, 2010 at 6:18 AM, John R Pierce <pierce@hogranch.com> wrote: > > > Joshua D. Drake wrote: > > >> > > >> Mostly, I think you will find that the back end developers aren't fond > > >> of Java and thus, it doesn't get much love. > > >> > > >> There is a reason that plPerl is king in this community (and I don't > > >> even like Perl). > > >> > > > > > > > Java2perl anyone ? > > http://search.cpan.org/~philcrow/Java-Javap-0.04/bin/java2perl6 > > (99% joking) > > > > And if you think positively a 14hour TZ difference is really only 10 > > if you go the other way. > > Is PL/J still being developed? I can't find it myself, but was curious. Not as far as I know. > > -- > Bruce Momjian <bruce@momjian.us> http://momjian.us > EnterpriseDB http://enterprisedb.com > -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development, Engineering
On Wed, 2010-04-14 at 22:53 -0400, Bruce Momjian wrote: > Damian Carey wrote: > > On Thu, Apr 15, 2010 at 6:18 AM, John R Pierce <pierce@hogranch.com> wrote: > > > Joshua D. Drake wrote: > > >> > > >> Mostly, I think you will find that the back end developers aren't fond > > >> of Java and thus, it doesn't get much love. > > >> > > >> There is a reason that plPerl is king in this community (and I don't > > >> even like Perl). > > >> > > > > > > > Java2perl anyone ? > > http://search.cpan.org/~philcrow/Java-Javap-0.04/bin/java2perl6 > > (99% joking) > > > > And if you think positively a 14hour TZ difference is really only 10 > > if you go the other way. > > Is PL/J still being developed? I can't find it myself, but was curious. Not as far as I know. > > -- > Bruce Momjian <bruce@momjian.us> http://momjian.us > EnterpriseDB http://enterprisedb.com > -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development, Engineering