[Phpmyadmin-devel] [Phpmyadmin] Interested in Participating in GSoC 2010

[ANKIT GUPTA]

hi,

I have improved the previous design check the image:

http://dl.dropbox.com/u/1008346/schema.jpg

examples:
For the example in image we will select name checkbox.
and then select S_LANG in song table there we will go to the option and
click on the where button a small where window will come here we will use
the drop down menu to select = and in the textbox we will write English,and
press Ok one entry will be added to the history table,repeat the process to
for HINDI.
after all this we will select the AND rule by writing (1 and 2).and then
submit .

Problems

The Sub-query option provided with where and having,here user has to type in
the sub query no visual building options.

please discuss this design and share your thoughts and suggestion .
we can discuss by taking any other query of your choice.


Thanks,
Ankit
On Thu, Apr 1, 2010 at 6:36 PM, ANKIT GUPTA <ankitatbits at gmail.com> wrote:

> Hello marc,
>
> yes you are right,that there is no need to explicitly ask the user to
> "select relation arrows",
> but  i want to provide users with an option to select the Join
> type(inner,outer,left,right).
>
> i have not mentioned any details for writing Nested Sub queries.till now i
> don't have a good design to implement them......and am still working on it.
>
> Thanks
> Ankit
>
> 2010/4/1 Marc Delisle <marc at infomarc.info>
>
> ANKIT GUPTA a écrit :
>> > Hi,
>> >
>> > because of the size limit , i am resending the my previous mail but this
>> > time in place of attaching the image i am providing a URL
>> >
>> > URL for image:
>> > http://dl.dropbox.com/u/1008346/mock_schema.jpg
>> >
>> > PFA with this mail
>> > as marc Suggested that we should discuss the design with the help of an
>> > example,
>> > so i have made a mock schema with three tables artist,song and
>> sings.details
>> > u can see in the diagram with this mail.
>> >
>> > i know The Design which i have developed till now is just the beginning
>> > draft , lot of discussion and thought has to be put to finalize the
>> design
>> > with functionality.
>>
>> Hi Ankit,
>>
>> I had a look at your image. I'm not sure what you mean by "select the
>> relations arrows which we need for the query". I think that in a query
>> builder, the user should be able to specify what he needs just in terms
>> of tables and columns, and the product should build the correct joins.
>>
>> --
>> 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 at lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.phpmyadmin.net/pipermail/developers/attachments/20100403/6ba49a18/attachment.html>