[Phpmyadmin-devel] SQL Validator

[Marc Delisle]

Robin Johnson wrote:

>Hi List,
>
>A few months ago, after there was an article on slashdot about an SQL
>Validator product that you could use freely via the web, I contacted the
>company behind it, and suggested that they make a web service version of
>the web page they had before, that could be used from within other
>applications.
>
>One of their developers that saw my email, and was a great fan of
>phpMyAdmin got back to me, and said he'd talk to management about it.
>I didn't hear anything for a few months, until a few weeks ago, he
>contacted me again, with access to the prototype of the service.
>
>I wrote a small (~15 lines + PHP classes from ActiveState) PHP client that
>works wonderfully for the initial version, and we saw his service was
>great.
>
That's good news.  Did you check what the Validator says with valid 
MySQL statements
that are not exactly ANSI-compliant?

>
>
>As an optional feature, I would like to include the PHP calls to the
>SOAP service in phpMyAdmin. It would get a link in the query box, just
>like we currently have for the 'PHP Code' and it would enable you to click
>on the link and send the data to Mimer via the SOAP service to be
>validated.
>
>In addition to just validating the query, if there is anything wrong with
>your query compared to what the standards, it lists each error, along with
>possible corrections. Up till yesterday, it was only in a text format, but
>as of later today, it will be a parsable XML format that I have had input
>on the design of.
>
>I foresee an additional option for it's use. If you type in a query, and
>the MySQL server gives you an error message, then run the validator as
>well, and it will list possible corrections for each error in the query,
>allowing newbie SQL users to debug their SQL queries in record time.
>
>Just a note, DB-config is now officially postponed until 2.3.1, as it
>needs some more design work, due to a few things pointed out to me
>regarding security.
>
>MySQL parser now passes every one of the tests that are bundled with
>MySQL, so I think it is ready :-).
>