Hi, i have used phpMyadmin for few of my projects,but the query builder tool provided is not very user friendly and has a limited scope I wish to add a query-builder for phpMyAdmin which will be powered by javascript and will also show the *Relational Schema diagram* for our database.
A good GUI support will be provided with this extension so developers can easily select the attributes from various tables in the database diagram and generate SQL query. with this extension JOINS and other complex query can be easily written.
further this project can be extended and we can build Data-Objects in our Schema where query builder will generate all queries as different functions and we can add this file in our main code and use these function.
Anyone here to discuss the idea?
Regards, Ankit Gupta
On Sun, Mar 28, 2010 at 12:52 AM, ANKIT GUPTA ankitatbits@gmail.com wrote:
Hi, i have used phpMyadmin for few of my projects,but the query builder tool provided is not very user friendly and has a limited scope I wish to add a query-builder for phpMyAdmin which will be powered by javascript and will also show the *Relational Schema diagram* for our database.
A good GUI support will be provided with this extension so developers can easily select the attributes from various tables in the database diagram and generate SQL query. with this extension JOINS and other complex query can be easily written.
further this project can be extended and we can build Data-Objects in our Schema where query builder will generate all queries as different functions and we can add this file in our main code and use these function.
Anyone here to discuss the idea?
Regards, Ankit Gupta
Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
Hi,
We can integrate some existing open source SQL builder and develop that further for PMA instead of writing from scratch/.
There are many good SQL builders.
Thanks
thanks for the suggestion Neeraj, yes we can find Some Good existing open Source builder.
Main thing on which i want to concentrate is the GUI part. As PMA is used by many novice Users and they have very little idea and knowledge in writing SQL queries the interface should be very user friendly ,so that every one can easily use this tool
Thanks
On Sun, Mar 28, 2010 at 12:55 AM, Neeraj Agarwal nee.agl@gmail.com wrote:
On Sun, Mar 28, 2010 at 12:52 AM, ANKIT GUPTA ankitatbits@gmail.comwrote:
Hi, i have used phpMyadmin for few of my projects,but the query builder tool provided is not very user friendly and has a limited scope I wish to add a query-builder for phpMyAdmin which will be powered by javascript and will also show the *Relational Schema diagram* for our database.
A good GUI support will be provided with this extension so developers can easily select the attributes from various tables in the database diagram and generate SQL query. with this extension JOINS and other complex query can be easily written.
further this project can be extended and we can build Data-Objects in our Schema where query builder will generate all queries as different functions and we can add this file in our main code and use these function.
Anyone here to discuss the idea?
Regards, Ankit Gupta
Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
Hi,
We can integrate some existing open source SQL builder and develop that further for PMA instead of writing from scratch/.
There are many good SQL builders.
Thanks
Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
Hi,
Marc i am still using the old version ,so have not seen the Designer feature of the latest version will check that. anyways if the designer feature has been added in the new versions then we can use it for the query builder .
Thanks Ankit Gupta
On Sun, Mar 28, 2010 at 1:03 AM, ANKIT GUPTA ankitatbits@gmail.com wrote:
thanks for the suggestion Neeraj, yes we can find Some Good existing open Source builder.
Main thing on which i want to concentrate is the GUI part. As PMA is used by many novice Users and they have very little idea and knowledge in writing SQL queries the interface should be very user friendly ,so that every one can easily use this tool
Thanks
On Sun, Mar 28, 2010 at 12:55 AM, Neeraj Agarwal nee.agl@gmail.comwrote:
On Sun, Mar 28, 2010 at 12:52 AM, ANKIT GUPTA ankitatbits@gmail.comwrote:
Hi, i have used phpMyadmin for few of my projects,but the query builder tool provided is not very user friendly and has a limited scope I wish to add a query-builder for phpMyAdmin which will be powered by javascript and will also show the *Relational Schema diagram* for our database.
A good GUI support will be provided with this extension so developers can easily select the attributes from various tables in the database diagram and generate SQL query. with this extension JOINS and other complex query can be easily written.
further this project can be extended and we can build Data-Objects in our Schema where query builder will generate all queries as different functions and we can add this file in our main code and use these function.
Anyone here to discuss the idea?
Regards, Ankit Gupta
Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
Hi,
We can integrate some existing open source SQL builder and develop that further for PMA instead of writing from scratch/.
There are many good SQL builders.
Thanks
Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
Even I haven't seen that :(
On Sun, Mar 28, 2010 at 1:36 AM, ANKIT GUPTA ankitatbits@gmail.com wrote:
Hi,
Marc i am still using the old version ,so have not seen the Designer feature of the latest version will check that. anyways if the designer feature has been added in the new versions then we can use it for the query builder .
Thanks Ankit Gupta
On Sun, Mar 28, 2010 at 1:03 AM, ANKIT GUPTA ankitatbits@gmail.comwrote:
thanks for the suggestion Neeraj, yes we can find Some Good existing open Source builder.
Main thing on which i want to concentrate is the GUI part. As PMA is used by many novice Users and they have very little idea and knowledge in writing SQL queries the interface should be very user friendly ,so that every one can easily use this tool
Thanks
On Sun, Mar 28, 2010 at 12:55 AM, Neeraj Agarwal nee.agl@gmail.comwrote:
On Sun, Mar 28, 2010 at 12:52 AM, ANKIT GUPTA ankitatbits@gmail.comwrote:
Hi, i have used phpMyadmin for few of my projects,but the query builder tool provided is not very user friendly and has a limited scope I wish to add a query-builder for phpMyAdmin which will be powered by javascript and will also show the *Relational Schema diagram* for our database.
A good GUI support will be provided with this extension so developers can easily select the attributes from various tables in the database diagram and generate SQL query. with this extension JOINS and other complex query can be easily written.
further this project can be extended and we can build Data-Objects in our Schema where query builder will generate all queries as different functions and we can add this file in our main code and use these function.
Anyone here to discuss the idea?
Regards, Ankit Gupta
Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
Hi,
We can integrate some existing open source SQL builder and develop that further for PMA instead of writing from scratch/.
There are many good SQL builders.
Thanks
Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
Neeraj Agarwal a écrit :
Even I haven't seen that :(
Not seen the Designer feature? It's there since version 2.10. Look in Documentation.html. Maybe you need to consult the "Mastering phpMyAdmin 3.1" book, chapter 11 ;)
On Sun, Mar 28, 2010 at 1:36 AM, ANKIT GUPTA ankitatbits@gmail.com wrote:
Hi,
Marc i am still using the old version ,so have not seen the Designer feature of the latest version will check that. anyways if the designer feature has been added in the new versions then we can use it for the query builder .
Thanks Ankit Gupta
HI, Marc i installed the latest phpmyadmin version and saw the Designer feature which uses Ajax, yes something similar i wanted for my diagram ..................but this feature is only for defining relationships,if we can use this diagram feature for query generation it will be very interactive and useful for the users,further we can also provide feature to automatically generate php classes having functions containing these query. users can directly put these classes in their code and just use the functions.!!
Thanks
On Sun, Mar 28, 2010 at 1:59 AM, Marc Delisle marc@infomarc.info wrote:
Neeraj Agarwal a écrit :
Even I haven't seen that :(
Not seen the Designer feature? It's there since version 2.10. Look in Documentation.html. Maybe you need to consult the "Mastering phpMyAdmin 3.1" book, chapter 11 ;)
On Sun, Mar 28, 2010 at 1:36 AM, ANKIT GUPTA ankitatbits@gmail.com
wrote:
Hi,
Marc i am still using the old version ,so have not seen the Designer feature of the latest version will check that. anyways if the designer feature has been added in the new versions then
we
can use it for the query builder .
Thanks Ankit Gupta
-- Marc Delisle http://infomarc.info
Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
ANKIT GUPTA a écrit :
HI, Marc i installed the latest phpmyadmin version and saw the Designer feature which uses Ajax, yes something similar i wanted for my diagram ..................but this feature is only for defining relationships,if we can use this diagram feature for query generation it will be very interactive and useful for the users,further we can also provide feature to automatically generate php classes having functions containing these query. users can directly put these classes in their code and just use the functions.!!
Thanks
Well, the Designer is not only for defining relationships, there are other buttons at the top that give other functionnalities. But you're right, a visual query builder would be good.
A challenge will be to try not duplicating the visual aspect of other similar products.
Ok, will check the other things . Regarding the concern for duplicating thing from similar product,yes we can keep this point in mind while designing and make our own unique design.
i had one more idea in this same query generation field, if we can provide a natural language processing tool (NLP) with phpmyadmin,this will be completely new and here people with little or no SQL knowledge can generate queries just by writting their queries in plain english.!! i have seen some similar open source tools ,we can integrate them with phpmyadmin one such tool is developed by mark watson and is open source
http://www.markwatson.com/opensource/nlbeandoc.htm
i have myself done some basic project in NLP at my college,
but for this summer i will like to concentrate on visual query generation.
thanks
On Sun, Mar 28, 2010 at 5:08 PM, Marc Delisle marc@infomarc.info wrote:
ANKIT GUPTA a écrit :
HI, Marc i installed the latest phpmyadmin version and saw the Designer
feature
which uses Ajax, yes something similar i wanted for my diagram ..................but this feature is only for defining relationships,if
we
can use this diagram feature for query generation it will be very interactive and useful for the users,further we can also provide feature
to
automatically generate php classes having functions containing these
query.
users can directly put these classes in their code and just use the functions.!!
Thanks
Well, the Designer is not only for defining relationships, there are other buttons at the top that give other functionnalities. But you're right, a visual query builder would be good.
A challenge will be to try not duplicating the visual aspect of other similar products.
-- Marc Delisle http://infomarc.info
Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
Hi Marc,
If u can give some information on other products which use visual features for query building, then i can have a look and it will be of great help for me to decide how to make this addition without duplicating visual aspects of other products.
Thanks,
On Sun, Mar 28, 2010 at 5:30 PM, ANKIT GUPTA ankitatbits@gmail.com wrote:
Ok, will check the other things . Regarding the concern for duplicating thing from similar product,yes we can keep this point in mind while designing and make our own unique design.
i had one more idea in this same query generation field, if we can provide a natural language processing tool (NLP) with phpmyadmin,this will be completely new and here people with little or no SQL knowledge can generate queries just by writting their queries in plain english.!! i have seen some similar open source tools ,we can integrate them with phpmyadmin one such tool is developed by mark watson and is open source
http://www.markwatson.com/opensource/nlbeandoc.htm
i have myself done some basic project in NLP at my college,
but for this summer i will like to concentrate on visual query generation.
thanks
On Sun, Mar 28, 2010 at 5:08 PM, Marc Delisle marc@infomarc.info wrote:
ANKIT GUPTA a écrit :
HI, Marc i installed the latest phpmyadmin version and saw the Designer
feature
which uses Ajax, yes something similar i wanted for my diagram ..................but this feature is only for defining relationships,if
we
can use this diagram feature for query generation it will be very interactive and useful for the users,further we can also provide feature
to
automatically generate php classes having functions containing these
query.
users can directly put these classes in their code and just use the functions.!!
Thanks
Well, the Designer is not only for defining relationships, there are other buttons at the top that give other functionnalities. But you're right, a visual query builder would be good.
A challenge will be to try not duplicating the visual aspect of other similar products.
-- Marc Delisle http://infomarc.info
Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
ANKIT GUPTA a écrit :
Hi Marc,
If u can give some information on other products which use visual features for query building, then i can have a look and it will be of great help for me to decide how to make this addition without duplicating visual aspects of other products.
Thanks,
Hello Ankit, I am not familiar with such products. Also, maybe seeing these would influence your design and it could be better not to see them...
yes maybe you are right ,it is better not to see those products.
I was planning to get started and get familiarized with the latest "master" git , i want to start developing and provide u with some deliverable as soon as possible. but presently i am on my college's network ,the port 22 needed for the git is blocked in here. so am not able to access it.
Is there any way to solve this problem.??
Thanks,
On Mon, Mar 29, 2010 at 7:51 PM, Marc Delisle marc@infomarc.info wrote:
ANKIT GUPTA a écrit :
Hi Marc,
If u can give some information on other products which use visual features for query building, then i can have a look and it will be of great help for me to decide how to make this addition without duplicating visual aspects of other
products.
Thanks,
Hello Ankit, I am not familiar with such products. Also, maybe seeing these would influence your design and it could be better not to see them...
-- Marc Delisle http://infomarc.info
Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
ANKIT GUPTA a écrit :
yes maybe you are right ,it is better not to see those products.
I was planning to get started and get familiarized with the latest "master" git , i want to start developing and provide u with some deliverable as soon as possible. but presently i am on my college's network ,the port 22 needed for the git is blocked in here. so am not able to access it.
Is there any way to solve this problem.??
Thanks,
In http://wiki.phpmyadmin.net/pma/Devel:Git there are two commands in the "obtaining the code" section, try the one which does not use "ssh".
Hi Marc,
i have already tried that command but it is also not working,i am getting following error fatal:unable to connect a socket (connection timed out).
I also want to discuss about the design for visual query designer,i have thought of some points like to add an option button with each selected attribute of table where we will have a menu bar with following fields GROUP ,ORDER ,Rename and Where. As user selects option from this menu bar other boxes/options will appear as the case is.
i am planing to implement select from clause,joins,group by order by and various aggregate function in query builder.you can check further details in my Gscoc Application .
please suggest any other functionality which we can add or any additional features in the design.
Thanks, Ankit Gupta
On Tue, Mar 30, 2010 at 7:27 PM, Marc Delisle marc@infomarc.info wrote:
ANKIT GUPTA a écrit :
yes maybe you are right ,it is better not to see those products.
I was planning to get started and get familiarized with the latest "master" git , i want to start developing and provide u with some deliverable as soon as possible. but presently i am on my college's network ,the port 22 needed for the git is blocked in here. so am not able to access it.
Is there any way to solve this problem.??
Thanks,
In http://wiki.phpmyadmin.net/pma/Devel:Git there are two commands in the "obtaining the code" section, try the one which does not use "ssh".
-- Marc Delisle http://infomarc.info
Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
ANKIT GUPTA a écrit :
Hi Marc,
i have already tried that command but it is also not working,i am getting following error fatal:unable to connect a socket (connection timed out).
I hope you can find a machine on which you can git ...
I also want to discuss about the design for visual query designer,i have thought of some points like to add an option button with each selected attribute of table where we will have a menu bar with following fields GROUP ,ORDER ,Rename and Where. As user selects option from this menu bar other boxes/options will appear as the case is.
This would be easier to discuss with some mock-up examples.
i am planing to implement select from clause,joins,group by order by and various aggregate function in query builder.you can check further details in my Gscoc Application .
please suggest any other functionality which we can add or any additional features in the design.
Thanks, Ankit Gupta
Hi
Dne Tue, 30 Mar 2010 23:06:43 +0530 ANKIT GUPTA ankitatbits@gmail.com napsal(a):
i have already tried that command but it is also not working,i am getting following error fatal:unable to connect a socket (connection timed out).
See http://wiki.phpmyadmin.net/pma/Devel:Git#Accessing_Git_repository_from_behin...
I also want to discuss about the design for visual query designer,i have thought of some points like to add an option button with each selected attribute of table where we will have a menu bar with following fields GROUP ,ORDER ,Rename and Where. As user selects option from this menu bar other boxes/options will appear as the case is.
i am planing to implement select from clause,joins,group by order by and various aggregate function in query builder.you can check further details in my Gscoc Application .
please suggest any other functionality which we can add or any additional features in the design.
You did not explicitely mention HAVING clause...
ANKIT GUPTA a écrit :
Hi,
Marc i am still using the old version ,so have not seen the Designer feature of the latest version will check that. anyways if the designer feature has been added in the new versions then we can use it for the query builder .
Thanks Ankit Gupta
Please, I am allergic to top-posting ...
I expect all potential GSoC students for a phpMyAdmin project to be running at least the latest stable 3.3.1 version, and preferably the latest "master" from git. Anyway you need to become familiar with git as this is the SCM we use.
On Sun, Mar 28, 2010 at 1:03 AM, ANKIT GUPTA ankitatbits@gmail.com wrote:
thanks for the suggestion Neeraj, yes we can find Some Good existing open Source builder.
Main thing on which i want to concentrate is the GUI part. As PMA is used by many novice Users and they have very little idea and knowledge in writing SQL queries the interface should be very user friendly ,so that every one can easily use this tool
Thanks
ANKIT GUPTA a écrit :
Hi, i have used phpMyadmin for few of my projects,but the query builder tool provided is not very user friendly and has a limited scope I wish to add a query-builder for phpMyAdmin which will be powered by javascript and will also show the *Relational Schema diagram* for our database.
About relational schema, did you look at the Designer feature currently in phpMyAdmin?
A good GUI support will be provided with this extension so developers can easily select the attributes from various tables in the database diagram and generate SQL query. with this extension JOINS and other complex query can be easily written.
further this project can be extended and we can build Data-Objects in our Schema where query builder will generate all queries as different functions and we can add this file in our main code and use these function.
Anyone here to discuss the idea?
Regards, Ankit Gupta
-
ANKIT GUPTA -
Marc Delisle -
Michal Čihař -
Neeraj Agarwal