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

------------------------------------------------------------------------------ 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.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.com>wrote:

...

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

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

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

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... -- Marc Delisle http://infomarc.info

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

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

-- Marc Delisle http://infomarc.info

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

-- Marc Delisle http://infomarc.info