[Phpmyadmin-devel] Gsoc 2011 - New Project Idea (Sql query Builder- Advanced query window)

Michal Čihař michal at cihar.com
Thu Mar 24 13:42:34 CET 2011


Dne Wed, 23 Mar 2011 00:34:13 +0530
dilantha silva <dilantha.tyrant at gmail.com> napsal(a):

> Im Dilantha Silva,a final year undergraduate student of the Faculty of
> Information Technology, University of Moratuwa, Sri Lanka. Im interested in
> partcipiating for Gsoc 2011 under phpmyadmin.I have participated for Gsoc
> 2010 under sahana software foundation and successfully completed the
> project[1]. I have been using phpmyadmin for quite long time and this idea
> came to my mind some times back.
> Query window act as a editor to create sql queries in phpmyadmin. It provide
> some basic functions to make things easy (showing the columns etc.) when
> writing a query. But i think we can add some features to enhance it and make
> it more user friendly.For example Key words like "SELECT", "FROM",
> "WHERE",etc will be used in most of the queries typed in the query window.
> So for that we can give auto completes and suggetions. When user type "S"
> and press Ctrl + Space (or something similar) we can show all the key words
> starting by "S" and allow user to select the particular one. 

This looks like a feature nobody will discover, because nobody reads
the documentation.

> Also when we
> are selecting a particular table in a database, once the user type
> "db_name." and press Ctrl + Space we can show all the tables in that
> particular db. Similarly when selecting a column in a table we can use this
> method. We can list down the available columns and allow users to select
> among them. specially when there are columns which has longer names this
> method will save lot of time and also avoid errors.
> These are just some of the improvements that we can do.Im sure there are
> plenty of things left. So i would love to hear your comments and suggestions
> regarding this project. Thanks.

Please keep in mind, that the project is for 12 weeks, so it definitely
needs to contain more that just improving SQL editor with few functions.

	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/20110324/4fed0f92/attachment.sig>

More information about the Developers mailing list