IDE for stored procedures, are MySQL stored procedures reliable?

Hi,
I am trying to create stored procedures in MySQL. Does anyone have a
suggestion on a good IDE to use. I have been working with the MySQL
Query Browser but it generates errors very often and is shut down by
Windows. When I make changes to my procedure, it doesn't seem to
always change what is being executed. Furthermore, sometimes the
procedure just disappears from my database. I am starting to think
that the stored procedure language in MySQL is just not reliable. Am I
wrong on this?

Thanks,
Bob

Re: IDE for stored procedures, are MySQL stored procedures reliable?

bshumsky06@yahoo.com wrote:
> Hi,
> I am trying to create stored procedures in MySQL. Does anyone have a
> suggestion on a good IDE to use.

MySQL Query Browser. I use it here and it works well.

> I have been working with the MySQL
> Query Browser but it generates errors very often and is shut down by
> Windows. When I make changes to my procedure, it doesn't seem to
> always change what is being executed.

What version are you using? The latest on dev.mysql.com seems to be
MySQL GUI Tools 5.0-r4. I'm running 5.0-r3 here and the QB component is
at version 1.2.3 beta.

You might also look at MySQL Workbench. It's a powerful schema design
application, and it has tools to create stored procedures. It's called
"Routine group". I'm still very new to the workbench though, so I can't
give you some expert advice about it.

> Furthermore, sometimes the
> procedure just disappears from my database. I am starting to think
> that the stored procedure language in MySQL is just not reliable. Am I
> wrong on this?

Might be a problem with QB. I created some stored functions and
procedures a while back in my WWW logging database and they never
disappeared nor stopped functioning, so for me it seems the MySQL stored
procedure language is reliable.

>
> Thanks,
> Bob
>

No problems, you're welcome! I hope I helped you a bit.

Nicolas Laplante

Re: IDE for stored procedures, are MySQL stored procedures reliable?

Appreciate it. I'll try a newer QB version and the MySQL workbench
when I get back to the stored procedures.


Nicolas Laplante wrote:
> bshumsky06@yahoo.com wrote:
> > Hi,
> > I am trying to create stored procedures in MySQL. Does anyone have a
> > suggestion on a good IDE to use.
>
> MySQL Query Browser. I use it here and it works well.
>
> > I have been working with the MySQL
> > Query Browser but it generates errors very often and is shut down by
> > Windows. When I make changes to my procedure, it doesn't seem to
> > always change what is being executed.
>
> What version are you using? The latest on dev.mysql.com seems to be
> MySQL GUI Tools 5.0-r4. I'm running 5.0-r3 here and the QB component is
> at version 1.2.3 beta.
>
> You might also look at MySQL Workbench. It's a powerful schema design
> application, and it has tools to create stored procedures. It's called
> "Routine group". I'm still very new to the workbench though, so I can't
> give you some expert advice about it.
>
> > Furthermore, sometimes the
> > procedure just disappears from my database. I am starting to think
> > that the stored procedure language in MySQL is just not reliable. Am I
> > wrong on this?
>
> Might be a problem with QB. I created some stored functions and
> procedures a while back in my WWW logging database and they never
> disappeared nor stopped functioning, so for me it seems the MySQL stored
> procedure language is reliable.
>
> >
> > Thanks,
> > Bob
> >
>
> No problems, you're welcome! I hope I helped you a bit.
>
> Nicolas Laplante