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
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 oth
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, 20
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 that
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,
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
i
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 or
> 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
-
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
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
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 th
>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
> 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 us
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 P
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
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,
>
> Store
- Original 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
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.
> >Thin
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
spec.
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
> - 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
icali" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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 skil
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 ?
>
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
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/0817244&mode=thread&threshold=
> At a first glance, I think
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 perio
26 matches
Mail list logo