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

[dilantha silva]

Hi All,

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. 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.

[1] http://wiki.sahanafoundation.org/doku.php/foundation:gsoc_silva



-- 
Regards,

Dilantha Silva,
http://twitter.com/dilanthasilva | http://www.linkedin.com/in/dilanthasilva|
https://launchpad.net/~dilantha
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.phpmyadmin.net/pipermail/developers/attachments/20110323/5656b5d2/attachment.html>