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