Re: MySQL Gets Functions in Java - Enlightenment Please
От | Dave Cramer |
---|---|
Тема | Re: MySQL Gets Functions in Java - Enlightenment Please |
Дата | |
Msg-id | 1072100893.2201.52.camel@localhost.localdomain обсуждение исходный текст |
Ответ на | Re: MySQL Gets Functions in Java - Enlightenment Please ("Tony (Unihost)" <tony@unihost.net>) |
Список | pgsql-general |
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 > >
В списке pgsql-general по дате отправления: