SQL. Stored procedures are loosely analogous to shell scripts. No
additional language constructs, outside of what is defined in the ANSI-SQL
standard are necessary for them.
IMHO, C would be a bad thing.
My $.02 worth, (which is worth less, each time I post)
Cal
*
* Cal Evans
* Senior Internet Dreamer
* http://www.calevans.com
*
----- Original Message -----
From: "William R. Mussatto" <[EMAIL PROTECTED]>
To: "Cal Evans" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; "Ed Carp" <[EMAIL PROTECTED]>
Sent: Friday, September 07, 2001 11:27
Subject: Re: Let's approach stored procedures
> 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
