Monday April 27, 2009
Slides from Advanced Query Manipulation with MySQL Proxy
Just quickly dropping the PDF version of the slides of my presentation at this year's MySQL Conference.Enjoy!
Posted by Kay Roepke [MySQL] ( April 27, 2009 12:03 PM ) Permalink | Comments[4]
Excellent job! Has the SQL parser been integrated in the mysql proxy already?
Posted by hang on July 16, 2009 at 11:03 AM CEST #
Thanks!
No, it has not been integrated, and I'm pretty sure it won't be part of Proxy 1.0 in any case.
That's for at least two reasons:
1) 1.0 must be stable in terms of API and code. The parser is neither at the moment.
2) This new code uses libraries we haven't been using before, so it requires legal review and of course code review as well. Both take time and resources so we'll have to be careful not to overload ourselves.
That being said, once it has received the legal review, I will put it into a separate branch on Launchpad so people can use, test and contribute to it. But it will most likely not be part of the standard distribution until some time after 1.0.
I can also see maybe splitting it up into the lexer part to provide an alternative for the existing lexer and hold off with the parser. I'll bring that possibility up with my colleagues, maybe that can work to get at least some of it in.
Posted by Kay Roepke on July 16, 2009 at 11:19 AM CEST #
Thanks, I see :) I think if there exists a SQL parser, we can rewrite the SQL queries much easier in mysql proxy. And I am just looking for it right now...
Posted by hang on July 17, 2009 at 03:22 AM CEST #
Even though the parser is under legal review, would you please send me a copy of SQL grammer in ANTLR? Thx!
And my email address is hangq.1985 at gmail dot com
Posted by hang on July 21, 2009 at 07:45 AM CEST #