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

[Michal Čihař]

Hi

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>