March 2012 - Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] guidelines for avoiding security pitfalls
by Dieter Adriaenssens 29 Apr '12

29 Apr '12

Hi, As discussed on the team meeting in February, I started creating a wiki page with some guidelines for avoiding security bugs [0]. The page is not finished yet, I just set out some ideas, that I will work out in the next few days. Feel free to comment, improve or add guidelines as you see fit. [0] http://wiki.phpmyadmin.net/pma/Security_pitfalls -- Kind regards, Dieter Adriaenssens

4 8

[Phpmyadmin-devel] Improving Sync for Big Tables
by adeel khan 09 Apr '12

09 Apr '12

Hi, Well i am interested in the GSoC project that is improving the synchronization feature , which really have problems with big tables. I already have a bad experience of synch huge tables. Last year i was testing this feature as i was doing research on tools having sync capability and after using a huge table > 0.1 Million the app/browser stopped responding. The main cause if i remembered exactly was probably time out. As you have written in the ideas list to first check it so i give it another try , and it again gives me the same result. I tested it on a db having just one table of 20K+ record, the script executed for about 5 minutes and there was php timeout. Here i am just taking the source table (single table) to destination . I thought about the solution and here what i can think of it right now First as your app generate everything before showing the difference stuff to the user, this is the major cause of bottleneck. In my 20K tuples example i was amazed why it didnt give me any timeout error on the first dialog. In a worst case scenarios generating a diff for the entire db is simply not scalable approach.Even if you have a lot of time/memory the user would have other stuff to do and would not wait for a long time for the sync thing to finish. I think the whole thing should be done in batches.The idea is that the structural diff is mostly less time and memory consuming, so its better to generate it for the entire db, but for data, just generate enough so that the script doesnot time out. (cases where we have huge tables). Now any user would get all the structural diff , plus what data diff we can able to get through in that pass. The time allowed for pass is bounded by script execution time which is 5 minutes as i see. Hence whatever has to be generated and applied has to meet this criteria. Now as if the user go for synch all option it would be synch without any issue and he/she would again land on the same page with next possible difference that was not evaluated in the previous pass. Now obviously there would be no structural diff now as they are already resolved. The issue now remains is the if the user wants a selected diff. The user might be interested in a table diff which app is not generating because of it is not coming in the first pass. The above method forces any user that he/she must apply initial pass diff to able to reach his/her desired table. This issue can be resolved by giving a skipping feature so that the user can skip to next tables, just as the concept of pagination. I was thinking about profiling and checking for memory consumption. My brief intro is that iam currently doing MS in Computer Science from LUMS Lahore ,Pakistan .Previously i did my BS with major in CS from FAST-NU .I am interested in system stuff like OS,distributed system,networks and and any good/cool software. I have started programming in C/C++, way back in 2004. I do have little industry experience too working in mobile applications (J2ME and Android) . I started working in PHP and MySQL in 2008 mostly because of its ease of use and its syntactic relatedness to C. My best Opensource/developement experience is/was working in GSOC 2010 that was making a synchronzation plus visualization feature for pgAdmin(postgres client). Other than that i have fixed bugs and developed a feature for a OpenSource project "OrangeHRM" (tool for human resource management). Regards adeel

4 5

[Phpmyadmin-devel] proposals: Refactoring: Insert/edit, Privileges, Operations, Structure
by nandu 07 Apr '12

07 Apr '12

hello, I am a Masters student of computers applications from NIT bhopal, India i am gud with php mysql, css, jsp, AJAX,html, as an application developer keen interested in software engineering Vb6, .Net framework etc I would like to add that in replacement of $row_table_def['True_Type'] = preg_replace('@\(.*@s', '', $row_table_def['Type']); we can use the str_replace which is faster then preg_replace since it will be more faster in simple cases which are used frequently. also there are multiple if else statements which can be replaced by select statements which will be more efficient, the code should have more derived classes since it works more faster than the base one. Sir I am expecting some guideline plz help me to work forward.. thanks -- Nandlal Ahirwar MCA, II yr Maulana Azad National Institute of Technology, Bhopal India

4 13

[Phpmyadmin-devel] Display multiple query results at once
by Chanaka Dharmarathna 05 Apr '12

05 Apr '12

Hi Michal, I feel it's better to have some clarifications on above title under [1] in GSoC idea list. This topic is mentioned about displaying multiple query results at once in same page (Please make me correct if I'm wrong). The results will be appear as set of tables in the same page. But, in order to get those multiple query results, from where I should execute those two queries separately ? If it is SQL tab in pma, is it a task relating to above title that improving SQL query window page to adding multiple query boxes ? or any suggested way ? Regards ! [1] http://wiki.phpmyadmin.net/pma/GSoC_2012_Ideas_List#Refactoring:_Displaying… -- ____________________________________ Chanaka Indrajith Bsc.Computer Engineering Undergraduate Faculty of Engineering University of Peradeniya ____________________________________

3 4

Re: [Phpmyadmin-devel] PDF export - ID: 1376650 -- need help
by SELVAM P 05 Apr '12

05 Apr '12

Hi Marc , I am really sorry for the delay. I had my lab exams going on. I did compare the libraries/export/pdf.php with libraries/export/htmlword.php. I have written the function PMA_exportStructure() for pdf export and its working, printing the structure. But the problem is that the "pdf_structure_or_data" option value is "data". It has to be changed to "data_and_structure".I inspected the source code, this is the problematic code > <input type="hidden" value="data" name="pdf_structure_or_data">. > > So i am trying to pin point the script where the format specific options are set. Any help would be appreciated. -- Selvam Palanimalai Website <http://selvam.e-caffeine.net/> || LinkedIN<http://www.linkedin.com/profile/view?id=109815979> Department of EEE | Department of Biology, Birla Institute of Technology and Sciences

4 4

[Phpmyadmin-devel] Need some suggestions for a feature request
by Chanaka Dharmarathna 05 Apr '12

05 Apr '12

Hi All, I'm interested on working the feature request [1]. As I understood, it is requested to link each result, which shows after browsing (click brows) any field in table structure, to relevant data row in that table. Please make me correct if I'm wrong. But if the browsing row is already a link, due to that field has a relation with another table field, what should be the behavior of this feature. My suggestion is to without bothering the column already a link or not, add a new link as 'show data row' after click on corresponding cells. If you have any suggestions please inform me to make some improvements. As well it is very helpful for me if you can suggest some source files related to these feature. [1] http://sourceforge.net/tracker/index.php?func=detail&aid=2998185&group_id=2… Regards ! -- ____________________________________ Chanaka Indrajith Bsc.Computer Engineering Undergraduate Faculty of Engineering University of Peradeniya ____________________________________

2 7

[Phpmyadmin-devel] GSoC 2012: Refactoring Designer/schema integration
by Adnan 02 Apr '12

02 Apr '12

hello guys, Refactoring phpMyAdmin codebase is important at this stage. I had an idea to make mobile version of phpMyAdmin for iPhone/Android using phoneGap but Michal Čihař said we will refactoring PMA this year GSoC. So, Refactoring Designer/schema integration would be best for me because I have work on Schema integration in GSoC 2010. schema export is already in OOP btw but Designer not yet. will start looking into codecase and ask questions. Thanks -- Muhammad Adnan Twitter: @hiddenpearls I blog too do u know ? http:// www.imblog.info Failure takes you higher than success ..! you sell code, I sell my brain.

4 11

[Phpmyadmin-devel] Plug-able authentication for phpMyAdimin
by Darshana Gunawardana 02 Apr '12

02 Apr '12

Hi Marc, I worked on implementing plug-able authentication and for simulation purpose, a new tab was added to main tab pane and file importer was used to import the plugin. Currently I have added another input to specify the plugin name since the plugin name can defer from the file name and it is required to install the plugin. Is there any other way to find the plugin name other than this way? Thank you - Regards, Darshana.

2 3

[Phpmyadmin-devel] GSOC 2012- Refactoring
by Thilina Buddika Abeyrathna 01 Apr '12

01 Apr '12

Hi, When we are going to refactor the huge php file which contains mix of html tags and php code like server_privileges.php script. And html tags are printed by php in this script, what is the best way to refactor. I somewhat confused about that. Is it good to separate html and php tags and implement several functions? I like to see the suggestions. -- Regards. Thilina Buddika Abeyrathna, Department of Computer Engineering, Faculty Of Engineering, University of Peradeniya, Sri Lanka.

2 1

[Phpmyadmin-devel] submit bug
by nandu 31 Mar '12

31 Mar '12

i used git to submit the bug to phpmyadmin, with the style and way of coding that you suggested, but while preparing the proposal do i need to mention in there???? How this will help me in getting in GSoC? am still not clear am I going in right direction or not?? plz i need some counselling here -- Nandlal Ahirwar MCA, II yr Maulana Azad National Institute of Technology, Bhopal India

2 1