May 2010 - Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] [ Exporting Relations Schema] Project
by ADnan 12 Jul '10

12 Jul '10

Hi, First of all, thanks for accepting my proposal. I am very delighted that I got a chance to take part in Great Google Summer of Code Program and phpMyAdmin was my favorite choice. I posted my proposal to my blog. <http://www.imblog.info/export-relations-schema-project-google-summer-of-cod…> I expect to get the feedback about my proposal from the Community :) Thanks! I will write weekly status reports at my blog and will regularly tweet my progress. My twitter: @hiddenpearls Regards Muhammad Adnan -- Failure takes you higher than success ..!

6 33

[Phpmyadmin-devel] SQL terminology
by Marc Delisle 31 May '10

31 May '10

Hi, today someone sent me a remark that phpMyAdmin does not follow the SQL and relational terminology when calling a column "field" and a row "record". I agree with him (in fact, this has annoyed me for some time) and here is what I intend to do: - for the 3.4 series I'll change all messages accordingly - for the 3.3 series I think we should leave the old terminology in place to avoid confusion, as 3.3.x is out since months and people referring to it in documentation, magazines, books, etc are using the old terminology -- Marc Delisle http://infomarc.info

2 1

[Phpmyadmin-devel] Ajaxify phpMyAdmin - List of tasks to complete
by Ninad Pundalik 31 May '10

31 May '10

Hi All, As I mentioned in my weekly report for GSoC for the last week [0], I've created a list [1] of major and minor tasks/actions that need to be Ajaxified over the summer. This list is a refinement over what I've specified in my project proposal. If I've missed some tasks, please edit the pastebin so that I don't miss out on completing important stuff. Also, I've created a list of JavaScript functions (from js/functions.js and js/common.js) that I feel I can refactor without causing any major bugs in the same pastebin. Please do check it as well. Thanx for all the help! :) [0] - http://ninadpundalik.co.cc/blog/2010/05/the-summer-of-code-prologue/ [1] - http://pastebin.ca/1873367 Ninad S. Pundalik Twitter: @ni_nad | Identica : @ninad | http://ninadpundalik.co.cc/blog GPG Key Fingerprint: 2DF7 B856 C75E C9F9 0504 C0EF D456 1946 7C45 2C69

2 3

[Phpmyadmin-devel] Maintaining non-js compatibility?
by Marc Delisle 30 May '10

30 May '10

Hi, I'm posting this to both lists to get developers and users feedback. In the phpMyAdmin 3.4 series, is it worth maintaining compatibility with non-js-enabled browsers? -- Marc Delisle http://infomarc.info

4 3

[Phpmyadmin-devel] Setup script language strings
by Piotr Przybylski 30 May '10

30 May '10

Hi, I want to add a new field to the setup script, how do I add associated message strings so that it is not lost in transition to gettext? Or is setup/lib/messages.inc.php a final solution? -- Piotr Przybylski

2 3

[Phpmyadmin-devel] User preferences survey
by Piotr Przybylski 30 May '10

30 May '10

Hi, I made a short survey about options that users would like to customize in phpMyAdmin for themselves [1]. I don't expect much, but maybe I will see there a good idea which can be implemented as part of my GSoC project. Can it be published on phpMyAdmin's news page? Preferably only link to the form [2], so that it will be easier to get there. I want to gather some input, preferably from end users, not just developers here. [1] http://crackpl.eu/blog/user-preferences-survey/ [2] http://spreadsheets.google.com/viewform?formkey=dHdBQTYxZWJxZ2Q4YVNsYXoyeFp… -- Piotr Przybylski

2 1

[Phpmyadmin-devel] Where to put new jQuery functions
by Lori Lee 28 May '10

28 May '10

I wrote a jQuery function that will replace the hide_them_all() and init_options() javascript functions used in Import/Export. I am wondering if this should go back in the PMA_pluginGetJavascript() function in plugin_interface.lib.php, into one of the .js files, or into a new .js file. I will probably also end up re-writing the match_file() function which is also declared in PMA_pluginGetJavascript(). -- Thanks, Lori

4 8

[Phpmyadmin-devel] "Quick Export/Import"
by Lori Lee 27 May '10

27 May '10

Regarding the new Export design, Marc noted that some users might want to “just do a backup” where all options that can be hidden, are hidden. The backup would contain all possible features for structure and data. Would these settings be okay: General options: ======================= - databases/tables: select all - output: save as file - save on server: true - overwrite existing file(s): user must choose - file name template: whatever value is already there - remember template: true - character set of the file: whatever the default is - compression: none SQL options: ======================== - display comments: true - additional custom header comment: blank - creation/Update/Check dates: true - relations: true - MIME type: true - enclose export in a transaction: false - disable foreign key checks: false - maximize compatibility with: whatever the default is - add DROP DATABASE statement: false - dump: structure and data Structure options: - Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT: false - Add IF NOT EXISTS: true - Add AUTO_INCREMENT value: true - Enclose table and field names with backquotes: true - Add CREATE PROCEDURE / FUNCTION / EVENT: false Data options: - delayed inserts: false - ignore inserts: false - complete and/or extended inserts: both - Use hexadecimal for BLOB: true - Export time in UTC: true - Maximal length of created query: whatever the default is - Export type: INSERT -- Thanks, Lori

2 1

[Phpmyadmin-devel] Visual Query builder
by ANKIT GUPTA 26 May '10

26 May '10

Hi, I made a few changes in the design, added self join operation plz have a look http://ankitgupt.wordpress.com/2010/05/. my Git repo's link is http://repo.or.cz/phpmyadmin/ankitg.git although i am having a few issues with the push command, git push ankitg master gives error To ssh://repo.or.cz/srv/git/phpmyadmin/ankitg.git ! [rejected] master -> master (non-fast forward) error: failed to push some refs to 'ssh:// repo.or.cz/srv/git/phpmyadmin/ankitg.git' I saw the code of designer and it uses linked table infrastructure, but this infrastructure doesn't exist by default. so for visual builder should this be developed in such a way that it without linked table. or should we follow designer.?

4 5

[Phpmyadmin-devel] Beginner questions
by Ninad Pundalik 25 May '10

25 May '10

Hi All, The start of the GSoC coding period is just around the corner, and I would like to start writing some useful code as soon as possible. I have a few questions before I start doing that though. In my proposal, I have mentioned one of my tasks as writing functions that will wrap the output of AJAX requests in well-formed XML. Over the last few days, I have been trying to figure out how to do this. Should I use output buffering at the start of an ajax request, read the entire output buffer into a string variable and then construct either a DOM or a SimpleXML object from that string when the request ends? Or, is there a better way of doing this? Also, when I checked out the latest version from git, I could see that a jQuery JSON plugin has been added in the js/jquery folder. If this plugin is being used, should the output for AJAX requests be in JSON instead of XML? I feel it would be a lot more easier to handle the output in JSON rather than XML. For the AJAX calls, do I use the jQuery's $.get/$.post/$.ajax methods directly or should I build wrapper functions around them? I found a plugin that makes it easy to handle a page with frames, the jQuery FrameReady plugin [0]. Has anybody used this plugin with phpMyAdmin (or in any other projects)? It makes a lot of sense to use this, as I had context issues when I was trying to write the patch for paginating the table. Last, where should I put all the jQuery scripts that will be written over the next few weeks in the tree? Should I keep it in a js/ajax folder for the period of this summer, and then merge it later into the js folder after the features have been sufficiently tested? I guess that's a lot of questions! Thank you for all the help :) ------------------------- [0] - http://ideamill.synaptrixgroup.com/?p=6 ------------------------- Ninad S. Pundalik Twitter: @ni_nad | Identica : @ninad | http://ninadpundalik.co.cc/blog GPG Key Fingerprint: 2DF7 B856 C75E C9F9 0504 C0EF D456 1946 7C45 2C69

3 3