26 messages in com.mysql.lists.mysqlRe: Let's approach stored procedures
FromSent OnAttachments
Claudio Cicali07 Sep 2001 08:30 
Adams, Bill TQO07 Sep 2001 08:40 
Ed Carp07 Sep 2001 08:44 
Claudio Cicali07 Sep 2001 08:49 
Cal Evans07 Sep 2001 08:56 
Ed Carp07 Sep 2001 09:02 
Cal Evans07 Sep 2001 09:05 
Ed Carp07 Sep 2001 09:14 
Claudio Cicali07 Sep 2001 09:17 
Cal Evans07 Sep 2001 09:21 
William R. Mussatto07 Sep 2001 09:26 
Adams, Bill TQO07 Sep 2001 09:29 
Cal Evans07 Sep 2001 09:33 
Ed Carp07 Sep 2001 09:45 
Dana Powers07 Sep 2001 10:15 
Robert Alexander07 Sep 2001 11:46 
Frank Fisher10 Sep 2001 00:41 
Endre Stølsvik10 Sep 2001 01:22 
Dana Powers10 Sep 2001 10:17 
Arnulf Kristiansen11 Sep 2001 00:39 
Jeremy Zawodny11 Sep 2001 00:45 
Claudio Cicali11 Sep 2001 00:59 
Endre Stølsvik13 Sep 2001 00:09 
James Clifford13 Sep 2001 00:26 
Arnulf Kristiansen13 Sep 2001 01:07 
Arnulf Kristiansen13 Sep 2001 01:08 
Subject:Re: Let's approach stored procedures
From:Cal Evans (ca@calevans.com)
Date:09/07/2001 08:56:31 AM
List:com.mysql.lists.mysql

My $.02,

Stick with the ANSI standard. (ANSI99?) Do not try to implement either PL/SQL or T/SQL. Please do not implement PERL (or Python) , Java, PHP or any other procedural or OO language in stored procedures. Speaking form experience, all this does is blur the lines of that the database should do and what the middle tier should do.

Whatever you do, do not adversely impact the speed at which MySQL runs.

Happy to Alpha/Beta test any patches you may create,

IMHO, Cal * * Cal Evans * Senior Internet Dreamer * http://www.calevans.com *

----- Original Message ----- From: "Claudio Cicali" <c.ci@mclink.it> To: <mys@lists.mysql.com> Sent: Friday, September 07, 2001 10:30 Subject: Let's approach stored procedures

I think this is a little OT here, so after reading please indicate me where to talk about this subject.

I'm a skilled programmer in C, C++ and others progr. lang. I have also a solid background in SQL and some RDMS (DB2, Oracle, SQLServer, and of course, Mysql).

I'm going to attend a long period of holidays (finally) so, I thought: why don't try to implement stored procedures in mysql ?

Now, on with the questions:

I think that MySQL programmers had yet thinked on some way to implement sp, and I'd wish that someone say me: - "No, dude it's impossible/too hard" - "No, dude, we are in the way to finish that by ourselves" - "No, dude, we never insert big patches in our official distribution branch, that does not belong to us"

Or, better, something more optimistic...

I don't want to loose my time, in something that you know is impossible or too hard to get.

Another question:

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 ?

That's all, for now.

database, mysql

--------------------------------------------------------------------- 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 <mysq@lists.mysql.com> To unsubscribe, e-mail <mysql-unsubscribe-cal=cale@lists.mysql.com> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php