[Phpmyadmin-devel] Gsoc 2011 - New Project Idea (Sql query Builder- Advanced query window)
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
Hi Dne Wed, 23 Mar 2011 00:34:13 +0530 dilantha silva <dilantha.tyrant@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
HI Michal, Thanks a lot for your response On Thu, Mar 24, 2011 at 6:12 PM, Michal Čihař <michal@cihar.com> wrote:
Hi
This looks like a feature nobody will discover, because nobody reads the documentation.
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.
The main idea of this project is to improve the sql editor with advanced features. I have mentioned only some of the things that we could do to improve it. Im sure there are lot of things we can do with in this 12 weeks. So i would love to have suggestions from the community to pick up the most suitable features to enhance the sql editor.
-- Michal Čihař | http://cihar.com | http://blog.cihar.com
------------------------------------------------------------------------------ Enable your software for Intel(R) Active Management Technology to meet the growing manageability and security demands of your customers. Businesses are taking advantage of Intel(R) vPro (TM) technology - will your software be a part of the solution? Download the Intel(R) Manageability Checker today! http://p.sf.net/sfu/intel-dev2devmar _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
-- Regards, Dilantha Silva, http://twitter.com/dilanthasilva | http://www.linkedin.com/in/dilanthasilva| https://launchpad.net/~dilantha
On Fri, Mar 25, 2011 at 7:34 PM, dilantha silva <dilantha.tyrant@gmail.com> wrote:
HI Michal,
Thanks a lot for your response On Thu, Mar 24, 2011 at 6:12 PM, Michal Čihař <michal@cihar.com> wrote:
Hi
This looks like a feature nobody will discover, because nobody reads the documentation.
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.
The main idea of this project is to improve the sql editor with advanced features. I have mentioned only some of the things that we could do to improve it. Im sure there are lot of things we can do with in this 12 weeks. So i would love to have suggestions from the community to pick up the most suitable features to enhance the sql editor.
-- Michal Čihař | http://cihar.com | http://blog.cihar.com
------------------------------------------------------------------------------ Enable your software for Intel(R) Active Management Technology to meet the growing manageability and security demands of your customers. Businesses are taking advantage of Intel(R) vPro (TM) technology - will your software be a part of the solution? Download the Intel(R) Manageability Checker today! http://p.sf.net/sfu/intel-dev2devmar _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
-- Regards,
Dilantha Silva, http://twitter.com/dilanthasilva | http://www.linkedin.com/in/dilanthasilva| https://launchpad.net/~dilantha
------------------------------------------------------------------------------ Enable your software for Intel(R) Active Management Technology to meet the growing manageability and security demands of your customers. Businesses are taking advantage of Intel(R) vPro (TM) technology - will your software be a part of the solution? Download the Intel(R) Manageability Checker today! http://p.sf.net/sfu/intel-dev2devmar _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
Talking about SQL Editor features, I would find it cool to have an inline SQL editor (Javascript window) instead of a window - pop up
Tyron Madlener a écrit :
Talking about SQL Editor features, I would find it cool to have an inline SQL editor (Javascript window) instead of a window - pop up
Version 3.4.0 has one. -- Marc Delisle http://infomarc.info
participants (4)
-
dilantha silva -
Marc Delisle -
Michal Čihař -
Tyron Madlener