[Phpmyadmin-devel] [GSOC 2011 Draft Proposal] Specialized Syntax for Query Building

[Marc Delisle]

Le 2011-04-04 11:14, Dhruv Baldawa a écrit :
> *Personal Details*
> 
> *Name:*Dhruv Baldawa
> *Email:*dhruvbaldawa at gmail.com
> *Skype ID or GTalk:*dhruvbaldawa at gmail.com
> *IRC nick:*dhruvbaldawa
> *Phone number:* +(91)-9323321233
> *School Name:* Thakur College of Engineering and Technology, University of
> Mumbai
> *Years completed:*Third Year Computer Engineering
> *Python Experience Level:*Intermediate
> 
> *Project Description*
> 
> *Describe your idea in detail:*SQL is a generic language and is the most
> common language used for database querying. But, the problem with SQL is,
> when a new user fires a SQL query, he needs to know 2 things :
> 
>    1. He needs to all the relations in the schema, and how are they related,
>    and how are they linked using which attributes.
>    2. When a user needs to fire similar queries (similar means queries with
>    almost same entities), in such a case all the JOIN statements or linking
>    conditions have to be rewritten.
> 
> So, here I propose a tool, which comprises of a metadata and syntax
> generator, algorithm and query helper, which can help user create a
> specialized syntax for querying the database in a simple and efficient
> manner, ignoring all the linking between the various tables.

Hi,
in phpMyAdmin 3.3, there is a multi-table query generator (click on a db
name, then Query). In version 3.4 this has been augmented with a visual
builder.

Did you notice these features in phpMyAdmin?

-- 
Marc Delisle
http://infomarc.info