Are all of these languages purely preference, or are some better for writing DB functions than others. Personally, although I write in PHP a great deal, I'd just get confused writing stored procs in PHP. So I'll be writing my stored procs in plpgsql, just for the sake of my sanity more than any other reason.
T.
Dave Cramer wrote:
On Sun, 2003-12-21 at 08:37, Paul Thomas wrote:
On 20/12/2003 18:04 Dave Cramer wrote:
I'm actually starting to write one of these for postgres, and apparently
there is another one in the works, from Thomas Hallgren.
There is at least one significant architectural issue here to deal with
Is it more desirable to have a single java vm and communicate via RPC,
or some other mechanism? ie sockets, or ? The alternative is to
instantiate a java vm for every connection, this could be onerous as
there would be considerable overhead for each java vm.
I think anything other than a single jvm would be too much of a
performance hit.
Ok, I tend to agree, so does anyone have any preferences for a protocol?
RMI, RPC, XML-RPC ? Anything better?
This will all go away as soon as java version 1.5 comes out but in the
meantime, what does everyone think
Comments are welcome.
On platforms built with GCC3.2+, GCJ might be an alternative.
There are numerous issues with classpath stuff with GCJ, but I'm
certainly willing to look at it.
Dave
--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants |
http://www.thomas-micro-systems-ltd.co.uk |
+------------------------------+---------------------------------------------+
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend