Re: PERL/SQL, again? - Re: Procedures

2002-04-04 Thread Tod Harter
On Wednesday 03 April 2002 13:25, Russell E Glaue wrote: > I am an avid PERL programmer, I also know java. I cannot completely agree > with either of you. > However, this debated subject is best discussed in another community. > The focus here is what has the necessary abilities/functionality to c

Re: PERL/SQL, again? - Re: Procedures

2002-04-03 Thread Colin Faber
I would assume a plpgsql solution wouldn't be a bad one, All you would really need is IF ELSEIF ELSE and FOR/WHILE, a way for procedures, triggers, views, etc. to be able to access each other with in the syntax of the language (providing routine/function support) along side the ability to access

Re: PERL/SQL, again? - Re: Procedures

2002-04-03 Thread Russell E Glaue
I am an avid PERL programmer, I also know java. I cannot completely agree with either of you. However, this debated subject is best discussed in another community. The focus here is what has the necessary abilities/functionality to cause SQL to become a 4th level language in MySQL. High level fe

RE: PERL/SQL, again? - Re: Procedures

2002-04-03 Thread Nick Arnett
> -Original Message- > From: Russell E Glaue [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, April 03, 2002 7:15 AM ... > Does anyone on this list have a suggestion as what might be the best > language to embed into MySQL? Be sure to consider memory efficiency, > threadding, speed of th

Re: PERL/SQL, again? - Re: Procedures

2002-04-03 Thread Tod Harter
That assumes you believe the myth that Java is really the language of choice in the back rooms of large enterprise IT shops. It isn't. In the financial industry perl is ubiquitous. Upper management will tell you Java is god, but if you actually look at the deployed systems that are out there do

Re: PERL/SQL, again? - Re: Procedures

2002-04-03 Thread Tod Harter
One thing to consider with Perl is that perl 5 and perl 6 are totally different beasts. Perl 6 is built on top of parrot, a general purpose register based virtual machine which is optimized to execute perl and similar languages. There are already a small test language running on top of parrot

Re: PERL/SQL, again? - Re: Procedures

2002-04-03 Thread Robert Cross
Russell E Glaue wrote: >Actually, I like this proposal of being able to plug in any language into >MySQL. I also want to make a note that Greg Cope has a very good point. >And going from what Greg mentioned in an earlier e-mail in this thread, >the embedded language of choice really needs to b

Re: PERL/SQL, again? - Re: Procedures

2002-04-03 Thread Russell E Glaue
Actually, I like this proposal of being able to plug in any language into MySQL. I also want to make a note that Greg Cope has a very good point. I believe it to be good to be able to plug in any language, but the mySQL community may want to make a standard recomendation of a certain language. A

RE: PERL/SQL, again? - Re: Procedures

2002-04-03 Thread Greg_Cope
> -Original Message- > From: pwxgao [mailto:[EMAIL PROTECTED]] > Subject: PERL/SQL, again? - Re: Procedures > > I have been using languages like Smalltalk, Perl and Java for about xx years. I am a huge fan of putting one in the DB for embedded server procedures. I a

PERL/SQL, again? - Re: Procedures

2002-04-02 Thread pwxgao
I have been using languages like Smalltalk, Perl and Java for about 15 years. I am a huge fan of putting one in the DB for embedded server procedures. I also beleive the best strategic option for MySQL to continue its adoption in the Enterprise IT world is to choose Java as this language. Perl i

Re: PERL/SQL, again? - Re: Procedures

2002-04-02 Thread Jeremy Zawodny
On Tue, Apr 02, 2002 at 06:20:41PM -0600, Russell E Glaue wrote: > > On the mysql-internals mail list we had a thread going about this. I > was suggesting something like embedding PERL into MySQL to produce > something like PERL/SQL (similar to PL/SQL in oracle). > Unfortunately, although promisi

Re: PERL/SQL, again? - Re: Procedures

2002-04-02 Thread Carsten Gehling
From: "Russell E Glaue" <[EMAIL PROTECTED]> Sent: Wednesday, April 03, 2002 2:20 AM > On the mysql-internals mail list we had a thread going about this. I was > suggesting something like embedding PERL into MySQL to produce something > like PERL/SQL (similar to PL/SQL in oracle). > Would anyone

Re: Procedures

2002-04-02 Thread Scalper
Not yet, but hopefully in 4.1. Check out http://www.mysql.com/doc/N/u/Nutshell_4.1_development_release.html. Craig sql,query At 06:07 PM 4/2/2002, you wrote: >Does any know if mysql has any kind of stored procedures? >If not, is there any plans on including them? > >-matt ---

Re: PERL/SQL, again? - Re: Procedures

2002-04-02 Thread Joel Rees
Russell E Glaue mentioned: > On the mysql-internals mail list we had a thread going about this. I was > suggesting something like embedding PERL into MySQL to produce something > like PERL/SQL (similar to PL/SQL in oracle). > Unfortunately, although promising and liked among people of the list,

PERL/SQL, again? - Re: Procedures

2002-04-02 Thread Russell E Glaue
On the mysql-internals mail list we had a thread going about this. I was suggesting something like embedding PERL into MySQL to produce something like PERL/SQL (similar to PL/SQL in oracle). Unfortunately, although promising and liked among people of the list, there are no plan right now to devel

Re: Procedures

2001-07-26 Thread Sinisa Milivojevic
=?iso-8859-2?Q?Michal_Proke=B9?= writes: > I need to use procedures in mysql. > Does somebody know, what is the easiest way? > > I hear, that it is possible to compile new procedures to mysql, but I don't > know how! > > Thanks Michal > Check our manual on UDF's. -- Regards,

Re: Re: Procedures

2001-06-13 Thread John Tsangaris
Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: database,sql,query,table If you just reply to this message, and include the entire text of it in the reply, your

Re: Procedures

2001-06-12 Thread John Tsangaris
Seung-woo, I understand the point you are making, a stored procedures is a group of queries that can be executed together like a function. As you have said "if you can [write] SQL and Perl programs, you could write a function that works like stored procedures in MS SQL server or Oracle". M

Re: Procedures

2001-06-11 Thread Seung-woo Nam
Hi: There is a perl module for MySQL you can download from cpan. It provides the interface to MySQL database you can use to connect, execute SQL statements from perl programs. Seung-woo Nam John Tsangaris wrote: > > >From the docs, it doesn't look like too much has been done in the area of stor