Re: PL/java?

"Gowey, Geoffrey" <ggowey@rxhope.com> writes:

> probably a bad idea.  From what I've heard the speed of your java program is
> wholely dependent on the speed of your vm (and most aren't that quick).
> Although it would be nice to have just to say we have it and mysql doesn't
> (then again mysql doesn't have a whole lot of things that pgsql already
> has).

Well, compiled Java code can't be that much slower than PL/pgSQL code
or TCL. both of which work fine for lots of people...

I've though about doing this.  It's definitely doable, but here are
some gotchas:

* The JVM is multithreaded, while backends are single-threaded.  This
  could open up a big can of worms if you're not careful.  On
  platforms with different libc's for threaded/nonthreaded code, you'd
  have to get the linking right.

* In order to be useful, you'd need to write a JNI wrapper for the SPI
  libraries.  Again, threading issues may apply.

It's an interesting project, but not one I've had time to look at yet.

-Doug
--
Free Dmitry Sklyarov!
http://www.freesklyarov.org/

We will return to our regularly scheduled signature shortly.