- Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] phpMyAdmin with gettext
by Michal Čihař 15 Mar '10

15 Mar '10

Hi all there is new branch called gettext in git repository. The code is really not ready for merging (at least some fixups to po files are needed), but if you want, you can test it right now. After checkout you need to generate .mo files which gettext loads and you can do it using scripts/generatemo. Afterwards at least these translations which do not have broken po files should work. -- Michal Čihař | http://cihar.com | http://blog.cihar.com

3 12

[Phpmyadmin-devel] deactivate SVN
by Marc Delisle 14 Mar '10

14 Mar '10

Hi, I suggest to deactivate SVN, to avoid the situation where someone still reads it, therefore getting an old state of development. -- Marc Delisle http://infomarc.info

3 3

[Phpmyadmin-devel] Enum editor: JQuery UI vs. custom dialog
by Pavel Konnikov 12 Mar '10

12 Mar '10

Hi, all. I'm trying to make enum and set editors (https://sourceforge.net/tracker/index.php?func=detail&aid=1494550&group_id=…) I added the special button near text input (see attachment enum-button.png). When you click on the button, editor dialog are shown. And i have a question about possibility of using jquery ui dialog for this. In js/ folder i'm seeing only mootols js-framework. And i made custom dialog for enum editor (see attachment enum-editor.png). But i think that jquery ui dialog is better solution for this task (http://jqueryui.com/demos/dialog/modal-form.html) What do you think? Best regards. Pavel Konnikov

7 48

[Phpmyadmin-devel] GSoC 2010 application
by Michal Čihař 12 Mar '10

12 Mar '10

Hi the deadline for GSoC 2010 application is this Friday. I've just updated application on wiki to match this year questions: http://wiki.phpmyadmin.net/pma/GSoC_2010_Application Please go through it and make an improvements so that we have great application which will be accepted ;-). PS: Marc, I need your link id (you've chosen this when registering to GSoC website). -- Michal Čihař | http://cihar.com | http://blog.cihar.com

2 6

[Phpmyadmin-devel] [GSoC] PMA OOP architecture ideas with a little REST touch
by Edouard SWIAC 12 Mar '10

12 Mar '10

Hi! Thanks for your reply Marc, I'm back with some idea for this GSoC project now . Instead of directly talking about PHP OOP architecture, I would like to speak REST architecture style firstly. I designed and developed a RESTful web service for the last company I worked for as an intern (4th french online shoes shop), and I developed a PHP RESTful proxy. Beyond the buzzword, it's a well-organized and extensible architecture, that fits very well with PMA. PMA is seen as a GUI that helps manage a MySQL server, but it also can be seen as a web service (disguised beneath a GUI though), transferring and building comprehensive data between the MySQL server and a end user. Plus, relational data is very prone to be REST oriented. Why should one consider PMA as a REST oriented app ? -Client/Server architecture PMA is the client of an underlying application, MySQL, querying on behalf of the user. - Resources Everything that comes from the server and the user work with (CRUD) can be considered as a resource : a table, a row, a user ... SQL queries change the state of theses resources, switching them into a new state. - Uniform interface CRUD operations in DBMS are similar in nature to what HTTP methods do to resources (GET/SELECT, POST/INSERT, DELETE/DELETE, PUT/UPDATE ...). - Resource representations Dumping data from a table is basically dumping the application state : one can select the representation he wants : CSV, LaTeX, XML, PDF ... -URIs & Stateless Clean URIs such as /tables/myapp/users?first_name=Elvis&last_name=Presley are easily bookmark-able due to their stateless structure, and editable by experienced users via the browser's address bar for fast and simple access. Obviously it can support SQL queries and representation types like /tables/myapp?query="SELECT * FROM users WHERE first_name='Elvis' AND last_name='Presley'"&output=xml. In this example, since a URL is fetched via GET, only SELECT statement should be allowed (DESCRIBE too, but querying via URL is just a utility tool, not a full API). There is some points on which PMA cannot be RESTful (REST oriented is enough), since it cannot handle cacheability (we need live data) and maybe some others I miss since I do not know every internal requirements. That was my thoughts on the non-code oriented architecture topic. Now let's move on PHP ;) Should the new architecture be PHP 5.3 compatible and leverage its new functionalities ? As you now, Zend and Sensio headed their frameworks' next major version toward PHP 5.3. What are your plans about it ? (PMA 3 being young) Currently, PHP code is very tied to HTML code and no template solution is used. GSoC proposal says it should be easier to create new templates, so maybe we should start with a simple template engine (existing or home made) that users can learn easily. Pro and cons should considered : home made template may be faster and better integrated, but users have to learn it and documentation has to be written for example ... This separation of concerns leads to MVC architecture, which is currently the best architectural pattern for PHP web based app. Whatever happens, an OOP structure for PMA means a big rewriting of its codebase if I'm not wrong (although some classes are already in the place) . A modular approach, with low coupling components (observer pattern, maybe DI ?) should allow code reusability and easy plugin development. Concerning mysql drivers, what are your minds on PDO ? Actually mysql_* and mysqli_* are the two interfaces used. PDO offers some nice features (prepared statements) for an OO environment (Exceptions) and some little tiny ORM possibilities (Object hydratation-like with fetchObject). Finally, testing could be introduced, to ensure only error free code is committed (not saying you commit code with errors :p) and that it won't break any existing functionality. I hope my ideas is not too far away from your expectations, and that some of them will grasp your attention. Regards, Edouard

2 1

[Phpmyadmin-devel] sessions and framesets
by Marc Delisle 12 Mar '10

12 Mar '10

Hi, Trying to solve a phpMyAdmin bug, I want to unset some values from an array located in $_SESSION. At the end of footer.inc.php, just before the exit I have a look and my values are gone from $_SESSION. However on the next click, just after the session_start(), the values are back! Is it possible that due to our two framesets, the navigation script would end after the main script, therefore storing what I think was unset() from my session? -- Marc Delisle http://infomarc.info

2 1

[Phpmyadmin-devel] about .gitignore
by Marc Delisle 11 Mar '10

11 Mar '10

Hi, What would be the best way to maintain a .gitignore file containing, for example: config.inc.php Should this be part of the repository, or the responsibility of each developer to set up? -- Marc Delisle http://infomarc.info

2 2

[Phpmyadmin-devel] phpMyAdmin 3.3.1-rc1 is released
by Marc Delisle 10 Mar '10

10 Mar '10

Welcome to the first release candidate of phpMyAdmin 3.3.1, a bugfix release. Details will appear on http://phpmyadmin.net. In a hurry? you can visit http://sourceforge.net/projects/phpmyadmin to download. Marc Delisle, for the team -- http://infomarc.info

1 0

[Phpmyadmin-devel] [GSoC] PMA OOP architecture project
by Edouard SWIAC 10 Mar '10

10 Mar '10

Hello everybody! I'm Edouard, a french student in Computer Science, keen on PHP since 2005 (got my Zend PHP5 certification in July '09), and very interested in neat PHP5 OO architectures, design patterns & reusability. I use PMA for a long time now (as almost every PHP developer I suppose), and my recent interest for the GSoC coupled with this very interesting project led me here:) I would like to propose you some ideas on this project, but is it still available ? Regards, Edouard SWIAC

2 1

[Phpmyadmin-devel] Migration to Git
by Michal Čihař 10 Mar '10

10 Mar '10

Hi as 3.3.0 is out, it's time to move to Git. If there are no objections, I'd do the migration this Thursday (11th March). During the migration no commits will be allowed to both SVN and Git (I'll remove privileges to do that). The migration should take at most one hour and I expect it to start around 10:00 CET, so around 11:00 CET the Git repository should be ready to use. After migrating the code I'll do necessary changes on other infrastructure (demo server, snapshots, creating releases), what should be all completed during Thursday. -- Michal Čihař | http://cihar.com | http://blog.cihar.com

3 3