On Fri, 7 Sep 2001, Cal Evans wrote:
> Date: Fri, 7 Sep 2001 11:05:27 -0500
> From: Cal Evans <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED], [EMAIL PROTECTED], Ed Carp <[EMAIL PROTECTED]>
> Subject: Re: Let's approach stored procedures
>
> Ed,
>
> Stored procedures allow you to pre-compile and re-use code easily. They also
> make transactions easier. (At least from one point of view) It's not like
> the XML argument. SPs are also part of the ANSI spec so to be compliant,
> MySQL will have to have them. XML is not part of the ANSI-SQL spec.
>
> IMHO,
> Cal
> *
> * Cal Evans
> * Senior Internet Dreamer
> * http://www.calevans.com
> *
Since the current version of MySQL is open source you could write stored
procedures in the same language used in (until recently) DB2, i.e., C. I
don't think that would be useful for those of us who are C challanged...
I think the real question is, can it be done w/o impacting performance.
Related question, what language or psuedo language would be used to code
them.
> ----- Original Message -----
> From: "Ed Carp" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Friday, September 07, 2001 10:44
> Subject: Re: Let's approach stored procedures
>
>
> > Claudio Cicali ([EMAIL PROTECTED]) writes:
> >
> > > At a first glance, I think Oracle PL/SQL is the best (afaik)
> > > programming language for sp, but, in the case we implement
> > > that language, should we go against some Oracle copytight
> > > infringment ?
> >
> > Why would you want to do such a thing? Isn't SQL good enough? I'm just
> trying to figure out your reasoning here, besides the same argument used by
> the XML crowd of "it's the latest/greatest do-all-be-all-end-all, so
> everyone should be using it" type of nonsense.
> > --
> > Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 -
> http://www.pobox.com/~erc
> >
> > Squished Mosquito, Inc.
> > Internet Applications Development
> > Escapade Server-Side Scripting Language Development Team
> > http://www.squishedmosquito.com
> > Pensacola - Dallas - Dresden - London
> >
> > ---------------------------------------------------------------------
> > Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
> >
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
Sincerely,
William Mussatto, Senior Systems Engineer
CyberStrategies, Inc
ph. 909-920-9154 ext. 27
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php