Re: PL/java?

"Gowey, Geoffrey" <ggowey(at)rxhope(dot)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.