On Tue, 11 Sep 2001, Arnulf Kristiansen wrote:
| I have just started to look into the stored procedure issue. We will come up with a
| definite plan within a short period of time.
But does this mean that you won't welcome any other initiative or ideas
from other programmers?
|
| It is true
newbie DB developer question
Are stored procedures scripts or compiled code ?
James
- Original Message -
From: Endre Stølsvik [EMAIL PROTECTED]
To: Arnulf Kristiansen [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, September 13, 2001 5:09 PM
Subject: Re: Let's approach stored
Endre Stølsvik wrote:
On Tue, 11 Sep 2001, Arnulf Kristiansen wrote:
| I have just started to look into the stored procedure issue. We will come up with a
| definite plan within a short period of time.
But does this mean that you won't welcome any other initiative or ideas
from other
James Clifford wrote:
newbie DB developer question
Are stored procedures scripts or compiled code ?
James
It can be either. Compiled code generally offers greater performance while something
that
has to be accepted by an interpreter will be more robust, provided the interpreter is
solid.
I have just started to look into the stored procedure issue. We will come up with a
definite plan within a short period of time.
It is true that there are solutions that would make transitions from another DBMS to
MySQL
easier however, I am leaning towards the ANSI standard rather than PL/SQL
On Mon, Sep 10, 2001 at 10:23:10AM +0200, Endre Stølsvik wrote:
The proprietary issues might of course be a huge problem. Anyone
knows anything about this?
Well, the PostreSQL folks managed to implement a stored procedure
language that looks, feels, and acts remarkably like Oracle's. So
At 09:40 AM 9/11/01 +0200, Arnulf Kristiansen wrote:
I have just started to look into the stored procedure issue. We will come
up with a
definite plan within a short period of time.
It is true that there are solutions that would make transitions from
another DBMS to MySQL
easier however, I am
Adams, Bill TQO wrote:
The other thing about all of this is that MySQL is feature rich so most people
might not have a use for stored procedures. Unlike, say, Informix which has
not build in MIN or MAX function.
Depending on the way you define things, MIN and MAX are essentially
stored
On Fri, 7 Sep 2001, Robert Alexander wrote:
| 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 definately
Depending on the way you define things, MIN and MAX are essentially
stored procedures that were programmed into MySQL. Why not let us make
our own?
This is already possible with Aggregate UDF 's. Check the manual here:
http://www.mysql.com/doc/A/d/Adding_functions.html
dpk
Claudio Cicali wrote:
I'm going to attend a long period of holidays (finally) so,
I thought: why don't try to implement stored procedures
in mysql ?
Someone did it with perl.
http://software.tangent.org/article.pl?sid=01/08/23/0817244mode=threadthreshold=
At a first glance, I think Oracle
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
At 10.44 07/09/2001 -0500, Ed Carp wrote:
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
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
- it's cool
Not a valid business reason.
- where I work, we have a HUGE database-driven web-application. A lot of
our business logic is implemented via stored procedures, that
act as black boxes for the web-designers.
Think of enterprise java beans.
They are not nonsense or
.
IMHO,
Cal
*
* Cal Evans
* Senior Internet Dreamer
* http://www.calevans.com
*
- 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
Cal Evans ([EMAIL PROTECTED]) writes:
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
At 11.03 07/09/2001 -0500, Ed Carp wrote:
- it's cool
Not a valid business reason.
- where I work, we have a HUGE database-driven web-application. A lot of
our business logic is implemented via stored procedures, that
act as black boxes for the web-designers.
Think of
Message -
From: Ed Carp [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, September 07, 2001 11:14
Subject: Re: Let's approach stored procedures
Cal Evans ([EMAIL PROTECTED]) writes:
Stick with the ANSI standard. (ANSI99?) Do not try to implement either
PL/SQL or T
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
Cal Evans wrote:
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
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
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
Why reinvent the wheel? MySQL already has user-defined function capability
in C.
Related question, what language or psuedo language would be used
Claudio Cicali ([EMAIL PROTECTED]) writes:
- where I work, we have a HUGE database-driven web-application. A lot of
our businness logic is implemented via stored procedures, that
act as black boxes for the web-designers.
Think of enterprise java beans.
They are not nonsense or
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
25 matches
Mail list logo