Hi Claudio,
I think having the functionality of stored procedures would be a wonderful addition to
MySQL. Let me be the first to say a hearty 'Thank you!' for your very generous offer
to devote your vacation time to this task.
I like Oracle's PL/SQL. I've used it a fair amount, and it get's the job done. PL/SQL
= Procedural SQL -- SQL plus procedural logic. This has the advantage of being a
language that uses the SQL that we all already know and love, plus enough procedural
things -- loops, conditionals, etc. -- to implement logic. It's more a programming
language than just a query language. This is a good thing.
That being said, I don't think re-implementing PL/SQL is necessarily the way to go for
MySQL. There may indeed be proprietary issues (though I'm not sure) and I think it'd
be possible to take a more 'open source' approach.
Let's remember what we want to accomplish with stored procs; that is, the ability to
store server-side logic where we can implement such things as business rules, and
ensure consistency in the way 'front-ends' of whatever flavour (and probably written
by different programmers) perform transactions with the dataset.
In my opinion, it'd be great if the choice of the server-side procedural language
could be left up to the developer/DBA. Perhaps a method whereby the stored proc would
then call a script in [language-of-choice] and then accept the returned results.
I realize that that method is not as tightly 'married' to MySQL as an internal
PL/SQL-like language would be and, depending on the scripting language, may have a bit
of a performance hit, but it does allow more freedom for the DBA in the tools to
choose from.
Just some thoughts. They're open-source, of course, so do with them what you will. :>
Best,
/Rob
Ob. MySQL: database, sql, query, table
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Robert Alexander ~~ Programmer/Analyst/DBA/Admin
WWW Database Applications ~~ http://www.ra1.net
Web Software and Hosting ~~ http://www.workmate.ca
---------------------------------------------------------------------
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