[Phpmyadmin-devel] Parser / analyzer rewrite

Marc Delisle marc at infomarc.info
Mon Mar 9 15:24:03 CET 2015

Dan Ungureanu a écrit :
> Hello,
> I have been using phpMyAdmin for years now and seeing that phpMyAdmin is a
> mentoring organisation for Google's Summer of Code, I thought of it as a
> great opportunity for me to get invloved in the community as a developer.
> I am interested in the parser and the analyzer of SQL queries of
> phpMyAdmin. For the past days, I have been looking for a replacement
> library, but, unfortunately I was not able to find a suitable one. I came
> to the conclusion that this vital part of phpMyAdmin would benefit a lot
> from a rewrite.
> Most of the current parsing libraries I found are no longer mantained;
> phpMyAdmin already has a huge codebase and adding even more code would be a
> pain in terms of maintainability. Huge fragments of code that are using the
> current `sqlparser` library would require changes as well. Moreover, the
> parser is an important part of the core and it has to be optimised, but
> flexible. From my experience, most libraries focus more on flexibility and
> tend to abstractize a lot, which might increase the overall complexity of
> the code.
> A few goals I would like to accomplish by rewriting are:
> - Modularize the code. What I mean is splitting the library into a lexer, a
> parser and other miscellaneous modules (e.g. query tester, builder,
> exporter etc.). In my opinion, this is one of the most important targets.
> Not only will the code be a lot more easier to understand and extend, but
> it will be a step closer to an object-oriented programmed phpMyAdmin.
> - Find a better algorithm, in terms of speed and attention paid to detail
> as well (ANSI, traditional, strict checking).
> - Implement new features. So far, I browsed through current tickets and
> came up with a list of issues that will potentially be fixed.
> https://sourceforge.net/p/phpmyadmin/bugs/3292/
> https://sourceforge.net/p/phpmyadmin/bugs/4447/
> https://sourceforge.net/p/phpmyadmin/bugs/4510/
> https://sourceforge.net/p/phpmyadmin/bugs/4718/
> https://sourceforge.net/p/phpmyadmin/bugs/4783/
> https://sourceforge.net/p/phpmyadmin/bugs/4787/
> https://sourceforge.net/p/phpmyadmin/feature-requests/1419/
> https://sourceforge.net/p/phpmyadmin/feature-requests/1611/
> https://sourceforge.net/p/phpmyadmin/feature-requests/262/
> I am looking for feedback, so please don't hesitate to send me any
> suggestion you might have!
> Best regards,
> Dan Ungureanu

Hi Dan,
this looks like a good plan. At this point I prefer not to comment about 
  integrating or not an external library, as another student publicly 
stated that he intends to do so for this idea.

Further details will be discussed directly on the Melange site once you 
send your proposal there.

Marc Delisle (phpMyAdmin)

More information about the Developers mailing list