[Phpmyadmin-devel] GSOC: Support for procedures

[Michal Čihař]

Hi

Dne Sun, 20 Mar 2011 21:46:55 +0530
Samiran Raj Boro <srajbr at gmail.com> napsal(a):

> I have experimented with the current capability of phpmyadmin with stored
> procedures, triggers, routines and events. As this project aim to create an
> user friendly interface in phpmyadmin I have some ideas to improve it and
> also some questions.
> 
> Currently phpmyadmin supports the above mention features of mysql only with
> sql queries. While creating procedures with ";" in between delimiter have to
> be changed. My view is why the user have to take care of it. We can pass
> some default delimiter to PMA_sqlQueryForm with the delimiter added to our
> query. So for that I suggest to create separate query box to deal with those
> things and this would be in a tab "Routines" for each database. It can even
> be better if we display the list of routines in the database page (the page
> one gets by selecting a database) and also the names of the trigger
> associated with a table when we browse it.

You can already define a delimiter for SQL query, which is also used by
current way of editing procedures.

> Again as ALTER PROCEDURE<http://dev.mysql.com/doc/refman/5.5/en/alter-procedure.html>,
> ALTER FUNCTION <http://dev.mysql.com/doc/refman/5.5/en/alter-function.html>does
> not allow us to change the parameters or the body, we can make a
> interface to change its parameters and body. We can program such a way it
> automatically drops it and create it with the same name with the modified
> changes.

Yes, it is needed to drop and create it again in such case.

> Are my ideas meet the needs of phpmyadmin. Please let me know and suggest to
> make it better.

I've also updated the ideas page to describe in more details what is
expected here. But you are always welcome to be creative in your
proposal, because we will choose only the best one out of all.

-- 
	Michal Čihař | http://cihar.com | http://blog.cihar.com
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 836 bytes
Desc: not available
URL: <http://lists.phpmyadmin.net/pipermail/developers/attachments/20110321/40d5f8b8/attachment.sig>