Developers

developers@phpmyadmin.net

2 participants
7003 discussions

[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] Website render for 3.5.0 release
by J.M. 09 Apr '12

09 Apr '12

When/How is phpmyadmin.net's render.py called the next time to reflect 3.5.0 release? -- J.M. Rütter, JubloWebSolutions DE: Postfach 2174, 56107 Lahnstein, DE UK: 68 Holmsley Lane, Woodlesford, Leeds LS26 8RY, UK www.mynetx.net | www.jublo.net

2 1

[Phpmyadmin-devel] Submitting patches
by Ahmed Waheed 09 Apr '12

09 Apr '12

Hi, I'm sorry for being yet not submitted any patches, but I'm so busy having exams since the SoC registration opened. I'm checking bug tracker now to fix some bugs, but I need help on how to prepare the patch, and how to submit it, I couldn't find any post/submit tab on patch tracker, or any writing/coding rules on how to make a patch. On the developer wiki, it is said that some bugs are for juniors who don't have knowledge with the code base..then I need to read the code base anyway, right? Then, how and from where to start reading the code? Best Regards,,

2 5

[Phpmyadmin-devel] for patch submission
by nandlal ahirwar 08 Apr '12

08 Apr '12

hello, I have my semester exams going on currently so am not able to give the maximum time to this patch, I also regret that I dint followed the bottom level posting, and all the mess ups. In order to identify a ios device we can use if( navigator.userAgent.match(/ Android/i) || navigator.userAgent.match(/ webOS/i) || navigator.userAgent.match(/iPhone/i) || navigator.userAgent.match(/iPad/i) || navigator.userAgent.match(/iPod/i) || navigator.userAgent.match(/BlackBerry/i) ) { $(function () { $('input:text').prop({ autocapitalize: 'off', autocorrect: 'off' }); }); } I am confused regarding which file this code is to be updated in phpmyadmin?? I have to submit the patch before 10th.. please help

3 4

[Phpmyadmin-devel] [GSoC2012] Refactoring: Table search, Db search, Multi-table query
by tuncay kilicoglu 07 Apr '12

07 Apr '12

Hi, I am Tuncay Kılıçoğlu. I study Computer Engineering at Çanakkale 18 Mart University, Turkey. Open source is very popular at our university (4 of my classmates were at GSoC last year :) ) , I have involved with some open source projects with Pardus ( A Turkish Linux distro that had been to GSoC 2 times before). I joined COMAK project which is a project about running Pardus tools with Gnome rather than KDE. I love Gnu/Linux. Besides that, I have worked at a few commercial companies for a year w,th PHP. I used to use Zend framework for a long time. I'm well adapted to PHP's niceties. I've used Mysql so far and PhpMyadmin is my favoriate database manager interface. I also liked software engineering lessons at school a lot and I use many refactoring techniques consistently. I need to take some advice before I start reading source code. What kind of refactoring styles are we talking about? What are Table search, db search and multitable query are related to? What's bad with current code? Do we also need to modularize scripts into seperate for better abstraction? or It's about refactoring inner details of functions? or is it about objectifying the code? Please give me a quick brief about project because I couldn't find any on mailing list. (You may give the link for the thread, too) Thanks in advance, Best, -- Tuncay KILIÇOĞLU

4 9

[Phpmyadmin-devel] regarding patch
by nandlal ahirwar 07 Apr '12

07 Apr '12

On Sun, Apr 1, 2012 at 12:26 AM, Dieter Adriaenssens < dieter.adriaenssens(a)gmail.com> wrote: > Op 31 maart 2012 19:20 heeft nandu <nandu130(a)gmail.com> het volgende > geschreven: > > Thanks.. > > they are related javascript code embedded in (or referenced from) HTML5 > > documents can use the objects and methods provided by jQuery to perform > its > > tasks. yes you are correct that it cannot be used in html5, > > So can it be considered as 1 thing that i can include in my proposal, > though > > am intending to find others too??? > Please use bottom posting on this mailing list. [0] > > Can you prepare a patch that implements this idea and post it to our > tracker [1] or create a fork of the phpmyadmin code on github and > issues a pull request, as explained on our website [3]. > hello, I have my semester exams going on currently so am not able to give the maximum time to this patch, I also regret that I dint followed the bottom level posting, and all the mess ups. In order to identify a device we can use if( navigator.userAgent.match(/ Android/i) || navigator.userAgent.match(/webOS/i) || navigator.userAgent.match(/iPhone/i) || navigator.userAgent.match(/iPad/i) || navigator.userAgent.match(/iPod/i) || navigator.userAgent.match(/BlackBerry/i) ) { $(function () { $('input:text').prop({ autocapitalize: 'off', autocorrect: 'off' }); }); } I am confused regarding which file this code is to be updated in phpmyadmin?? I have to submit the patch before 10th.. please help

1 0

[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] phpMyAdmin 3.5.0 is released
by Marc Delisle 07 Apr '12

07 Apr '12

Welcome to phpMyAdmin 3.5.0; here are the major new features: * browse-mode improvements ** grid editing ** remember recent tables ** remember last sort order by table ** flexible column width ** reorder columns ** more compact navigation bar * AJAXification of many operations * reorganised server status page, with server monitoring * improved support for stored routines, events and triggers * openGIS support * zoom-search in table search * Drizzle support * improved ENUM/SET editor 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

2 1

[Phpmyadmin-devel] Regarding Change of Email
by nandlal ahirwar 07 Apr '12

07 Apr '12

Sir, I submitted my proposal with this email-id (nandu1304(a)gmail.com), Earlier I was using (nandu130(a)gmail.com), I was registered as a mentor at the starting, which I realized later at the time of submission of proposal. Kindly consider my proposal from this new email (nandu1304(a)gmail.com) thank you

1 0

[Phpmyadmin-devel] patch for bug ID: 3511588
by SELVAM P 06 Apr '12

06 Apr '12

Hi Michal, As per your comments, I have submitted a new patch for the bug *structure schema printed multiple times in Word export - ID: 3511588.* Please have a look. Thanks! -- 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

1 0

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

2002

2001

Developers