No not purely preference, the issue is more of being able to call an
enterprise function on a trigger for instance.
Start a thread if something happens in the db.
Dave
On Mon, 2003-12-22 at 08:31, Tony (Unihost) wrote:
> 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
> >
