October 2012 - Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] Documentation
by Michal Čihař 04 Dec '12

04 Dec '12

Hi for quite some time I was thinking about way we provide documentation and I think there is lot of place for improvements. As my current favorite tool to build documentation is Sphinx <http://sphinx.pocoo.org/>, I gave it a try. To name some of the benefits let me quote from their home page: * Output formats: HTML (including Windows HTML Help), LaTeX (for printable PDF versions), manual pages, plain text * Extensive cross-references: semantic markup and automatic links for functions, classes, citations, glossary terms and similar pieces of information * Hierarchical structure: easy definition of a document tree, with automatic links to siblings, parents and children * Automatic indices: general index as well as a module index * Built-in fulltext search I've done quick and dirty [*] conversion of FAQ and few introductory sections, you can find source here: https://github.com/nijel/phpmyadmin-doc And the generated documentation in HTML and PDF here: http://tmp.cihar.com/pmadoc/index.html http://tmp.cihar.com/phpMyAdmin.pdf What do you think about changing our documentation from HTML to something else (be it Sphinx, Docbook or something completely else)? [*] I've lost all text formatting and links in text, but that should not be hard to convert properly, I just did not want to spend much time on prototype. -- Michal Čihař | http://cihar.com | http://phpmyadmin.cz

4 13

[Phpmyadmin-devel] Upgrading sf.net project
by Michal Čihař 16 Nov '12

16 Nov '12

Hi maybe you've noticed, maybe not, but sf.net is slowly moving to new platform called Allura [1] and projects can opt in for upgrading. There seems to be quite a lot of improvements [2], especially in the Issue tracking (you can see Allura's own tickes [3] as an example). There are upgrading information on separate page [4] and none of not migrated things does not affect us, so I'd go for upgrade. Any comments on that? [1]:https://sourceforge.net/p/allura/ [2]:https://sourceforge.net/p/allura/wiki/Features/ [3]:https://sourceforge.net/p/allura/tickets/ [4]:https://sourceforge.net/p/upgrade/ -- Michal Čihař | http://cihar.com | http://blog.cihar.com

3 9

[Phpmyadmin-devel] Hint for double-click (grid editing)
by Marc Delisle 13 Nov '12

13 Nov '12

Hi, It would be annoying to display a hint on mouseover for all grid-editable cells. To help 3.5.x users learn about the double-click (which is now the default action for grid editing in 4.0), we could display a hint when the user clicks on the data row (which has the effect of selecting the row, like the checkbox). However we must take care of displaying this hint just once (per session?). Also, what about removing the "select row on click" feature? Is this intuitive? Comments? -- Marc Delisle http://infomarc.info

3 11

[Phpmyadmin-devel] Merge of the frames-removal project
by Rouslan Placella 04 Nov '12

04 Nov '12

Hi all, I've just merged my GSoC project[0] into master. As it introduces some changes to how pages are served, I thought that I'd mention that there is some documentation on the matter[1][2][3]. Sadly, the new features also come with a list of known bugs, which can be viewed here[4]. Bye, Rouslan [0]: http://www.google-melange.com/gsoc/project/google/gsoc2012/roccivic/71002 [1]: http://wiki.phpmyadmin.net/pma/Page_loader [2]: http://wiki.phpmyadmin.net/pma/Navigation [3]: http://wiki.phpmyadmin.net/pma/Microhistory [4]: http://roccivic.blogspot.ie/2012/08/final-report.html

4 9

[Phpmyadmin-devel] Rebuilding the sql from the scratch
by Chanaka Dharmarathna 30 Oct '12

30 Oct '12

Hi, I'm working on bug [0]. Relevant modifications to the sql query is done inside tbl_export.php, according to the selected results from the table browse window which is going to export. When modifying the query, it actually rebuild from the scratch. As I understand there are 2 requirements for modify the query. 1. Remove the LIMIT clause (for append any where clause) 2. Add needed filtering clause (additional where clause) To do the above things is it really need to rebuild the query from the scratch ? I don't think that there are scenarios which need to modify the beginning part of he query (before where clause). So is it okay to modify the query only from the where clause. Though the current analyzer doesn't support for the multiple select statements, hopefully this will fix the bug I mentioned. Any thoughts on this ? [0] : http://sourceforge.net/tracker/?func=detail&aid=3034670&group_id=23067&atid… Regards ! -- Chanaka Dharmarathna *Virtusa (Pvt) Ltd. | **Sri Lanka*

2 3

[Phpmyadmin-devel] grid editing not with single-click?
by Marc Delisle 20 Oct '12

20 Oct '12

Hi, After reading [0] I am almost convinced that grid editing with a single-click is not the best idea. So, for 4.0, I suggest to switch to some other action to activate grid editing. [0] https://sourceforge.net/tracker/?func=detail&atid=377411&aid=3522109&group_… -- Marc Delisle http://infomarc.info

3 4

[Phpmyadmin-devel] Travis CI enabled on Github
by Michal Čihař 18 Oct '12

18 Oct '12

Hi all I've just enabled Travis CI on Github. In basic, it runs our testsuite on every commit, but supports using more PHP versions compared to Jenkins. You can see results here: https://travis-ci.org/#!/phpmyadmin/phpmyadmin But it also provides support for testing pull requests and displaying it's status just at the pull request. This will allow you to directly see if pull request would break anything or not. You can see examples on Github and Travis blogs: https://github.com/blog/1227-commit-status-api http://about.travis-ci.org/blog/2012-09-04-pull-requests-just-got-even-more… Please note that this won't replace Jenkins, it's just an additional source, mostly to help with the pull requests. -- Michal Čihař | http://cihar.com | http://blog.cihar.com

3 2

[Phpmyadmin-devel] translatable string
by Dieter Adriaenssens 17 Oct '12

17 Oct '12

Hi, I don't find any clear rules on when to add/update translatable strings (from the developer point of view). I have a suggestions : master (dev) : - freely add and change translatable strings when preparing a future stable (4.0-alpha/rc) - no new translatable strings - no updates that changes the content/meaning of a translatable string (but exceptions allowed after discussion on mailing list) - updates fixing typos and grammar are allowed current stable (QA_3_5) - no new translatable strings - no updates that changes the content/meaning of a translatable string - updates fixing typos and grammar are allowed old releases - no maintance on translatable strings (no new strings, no fixes on existing strings) What do you think? BTW : the reason I mentioned allowing grammar/typo fixes in current stable, is because it has almost no influence on the translating process. A string with an fixed typo does not have to be retranslated. -- Kind regards, Dieter Adriaenssens

3 6

[Phpmyadmin-devel] about the "DocSQL" format
by Marc Delisle 13 Oct '12

13 Oct '12

Hi, In current master, when the UploadDir feature is activated and a database is empty, clicking on Import produces: Fatal error: Call to a member function getExtension() on a non-object in libraries/Util.class.php on line 3465 Even if this could be debugged, I would like to just remove support for the docSQL import format. The docSQL project has had no activity in the last ten years. -- Marc Delisle http://infomarc.info

2 1

[Phpmyadmin-devel] Support for LIKE %...% operator while searching numeric fields in table search screen
by Chanaka Dharmarathna 09 Oct '12

09 Oct '12

Hi, Currently there is no 'LIKE %...%' operator for the numeric fields in table search screen. But there are some scenarios we need to search the numeric fields (int, date etc) with 'LIKE' operator + wildcard characters (LIKE %2012%). So, was there any reason for not using that previously ? If we can give the support for this, it hopefully provide a different way to bypass the problem in bug [0]. Any thoughts on this ? [0] : https://sourceforge.net/tracker/index.php?func=detail&aid=3573456&group_id=… Regards ! -- Chanaka Dharmarathna *Virtusa (Pvt) Ltd. | **Sri Lanka*

2 2