- Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] GSoC 2011
by Ammar Yasir 11 Mar '11

11 Mar '11

Hi, I went through the idea list for this year and i was hoping if I could get some more details on the 'Zoom-search' project. What kind of technology would be involved? Also, I had gone through a similar idea a long time back "An Interactive Visual Query Environment for Exploring Data" (UIST'97). Is it related somehow? Regards, Ammar Yasir

2 2

[Phpmyadmin-devel] GSoC 2011
by harsh gidra 10 Mar '11

10 Mar '11

Hi, I am Harsh Gidra, a UG student from India. I am currently pursuing Bachelor of Technology (B.Tech.) in Information Technology from Malaviya National Institute of Technology Jaipur, India [1] and will graduate in May 2011. I am well versed with HTML, PHP, MySQL, Javascript, jQuery and CakePHP (MVC Paradigm) and have a deep interest in Web Development. I have completed a number of web-based projects using Open Source technologies. I was also associated with an Open Source organization (Limesurvey) last year [2]. Here is my complete resume [3]. I am interested in applying for phpMyAdmin in GSoC 2011. I have gone through the GSoC 2011 Ideas List [4] and am interested in the project titled - "phpMyAdmin OOP". I have a doubt regarding the same. Does this project call for implementing the same using some kind of framework like CakePHP, CodeIgniter, etc.? Or does this involve creating everything right from scratch? -- [1]. http://en.wikipedia.org/wiki/Malaviya_National_Institute_of_Technology_Jaip… [2]. http://www.ohloh.net/p/limesurvey/contributors/1159641215474 [3]. http://gidraharsh.in/resume/ [4]. http://wiki.phpmyadmin.net/pma/GSoC_2011_Ideas_List Thanks and regards,Harsh Gidra Department of Computer Engineering Malaviya National Institute of Technology Jaipur-302017 India Website: http://gidraharsh.in IRC Nickname: harsh

2 2

[Phpmyadmin-devel] Multiple "Change Password" Windows
by Kasun Lakpriya 08 Mar '11

08 Mar '11

Hi all, While I was trying to fix the existing PmaSeleniumPrivilegesTest.php I noticed something like this and I am not sure this is a bug or not. When I click on "Change Password" button each time a new "Change Password" window is created and in the newly created windows (after the original window) there is no "Generate Password" field in them and at the same time a new "Generate Password" field is being added to the original "Change Password" window. And since the new windows are being created on top of the original one I can't see the "Generate Password" field in them. Here are some screen shots what I am getting, After clicking several times : http://i.imgur.com/bX0HX.png Original window looks like this : http://i.imgur.com/M3JZo.png And I am in Ubuntu 10.10 and running PMA on xampp and the browsers are Firefox and Chrome. -- Thanks and Regards, Kasun

3 4

[Phpmyadmin-devel] GSOC project - Marc Delisle
by Muhammad Umair 07 Mar '11

07 Mar '11

Dear Marc Delisle, I have desire to contribute for PHPMYADMIN project. I really liked the "User preferences" project that was selected in GSOC 2010 under your supervision. I would really want to contribute in such sort of projects under your kind supervision. I am looking to start contributing as soon as possible in order to familiarise myself with PHPMYADMIN codebase and hopefully make significant contributions during GSOC period and beyond. The following is my brief introduction please: I finished Bachelors in Information and Communication System Engineering (4 year Honors) from National University of Sciences and Technology (NUST) in 2009. In an Undergraduate Dissertation, I worked on “Design and Development of Automatic Frequency Planning (AFP) Tool” in joint collaboration between NUST and world leading Telecommunication Operator, WARID Telecom (Pvt) Limited, Abu Dhabi & SingTel Alliance. My undergraduate dissertation was awarded Rector’s Gold Medal. Currently, I am pursing postgraduate degree in Wireless Systems (2 years) at Royal Institute of Technology (KTH), Sweden. The master course mainly focuses on key technologies for wireless systems, including an overview of the area as well as a deeper knowledge within communications theory, signal processing, radio communication and communication networks and insight in the ongoing research and development work. In 2007, I was selected as an intern at MOBILINK Telecom (PMCL) Group of Multinational Orascom Telecom to work in the Network Switching Subsystem (NSS) department. In 2008, I was selected to take part on an extensive training on Wireless Channel Modeling and Simulation that was organized by NUST in collaboration with University of Surrey UK. In 2010, I worked as a System Integrator at Buraq Integrated Solutions (Australian based company) that involved PHP, JSP, JavaScript, MATLAB, MySQL, MicroLogix and OPC Server. I have over two years of experience in the industrial software development projects. I have fair experience in network programming. I developed a multi-client/server application based on the Sliding Window Protocol using TCP/IP sockets, C++, threads and C#. I have vast hands on experience on different programming languages PHP, C, C++, C#, Java, SQL, Asp.Net and MATLAB. Please find my attached resume. Thanks Thanks for your time and consideration. Yours Sincerely, Umair Muhammad Electrical Engineering Master Student, Specialization in Wireless Systems, School of Electrical Engineering, Royal Institute of Technology (KTH), SE 100-44 Stockholm, Sweden. Email: mumair(a)kth.se Cell: +46 764 097 574

2 1

[Phpmyadmin-devel] PMA logo - vector/font
by Mike Homme 07 Mar '11

07 Mar '11

Hi, Does anyone know what font the PMA logo was designed with, or have a vector/original source file for it? Thanks, Mike

2 1

[Phpmyadmin-devel] PHPExcel 1.7.6
by Dieter Adriaenssens 05 Mar '11

05 Mar '11

2011/3/2 Marc Delisle <marc(a)infomarc.info>: > Le 2011-03-01 13:05, Dieter Adriaenssens a écrit : >> 2011/3/1 Michal Čihař <michal(a)cihar.com>: >>> Hi >>> >>> Dne Mon, 28 Feb 2011 19:18:10 +0100 >>> Dieter Adriaenssens <dieter.adriaenssens(a)gmail.com> napsal(a): >>> >>>> An update for the PHPExcel (1.7.6) library was released yesterday. >>> >>> Are there any fixes which look important to us? >> >> They claim improvements in memory usage when creating an Excel-file, >> but I didn't test it yet. > > I remember seeing reports about excessive memory usage for phpMyAdmin > users when exporting with this, so please test it, for 3.4. There are some improvements. I quickly tested with a small dataset (two tables, one containing approx. 15 rows, another approx. 700 rows, total size of both tables : 20 KiB): PHPExcel | 1.7.4 | 1.7.6 XLS | 26 MB | 23 MB XLSX | 32 MB | 23 MB Not a significant improvement, and the export still runs out of memory with a slightly larger, but not huge, dataset (800 KiB, needs at least 130 MB of memory, but then runs out of it). I still wonder why exporting 20 KiB of data needs that much memory. For reference, when exporting the same dataset as SQL : | sql | bz2 small set (20 KiB) | 10 MB | 18MB larger set (800 KiB) | 19 MB | 24 MB BTW: The memory sizes are that of the apache instance, so it is about 10MB to start with. But maybe the way we are using the library can be improved as well. I'll look into that if I find some time, but maybe that's something for 3.5-dev? I think we can reduce the size of the PHPExcel library as well, we certainly don't use everything in the library. Greets, Dieter >> And some bugfixes, but nothing special. >> >>> >>>> Shall I update it in phpMyAdmin? If yes, only in master/3.4-dev, or >>>> also in QA_3_3? >>> >>> Definitely not in 3.3, I'm also hesitating about 3.4, because it might >>> break more things than it fixes. > > > -- > Marc Delisle > http://infomarc.info > -- Groetjes, Dieter Adriaenssens -- Groetjes, Dieter Adriaenssens

2 2

[Phpmyadmin-devel] Spatial Support Improvements for GSoC 2011
by Liauw Jian Mei 05 Mar '11

05 Mar '11

Greetings! My name is Frank Liauw, a second year going on to third year Computer Science student from the National University of Singapore. I am interested in contributing to the phpMyAdmin project over the coming summer, of which I have been a user for more than a decade. I've had much experience in web development and programming, and have contributed in terms of extension development for other open source projects of which I was actively working on, such as Moodle. I'm particularly interested in implementing OpenGIS support, as listed in the GSoC Idea List for the past 2 years ( https://wiki.phpmyadmin.net/pma/GSoC_2011_Ideas_List#OpenGIS_support) I believe that this topic is of great relevance to me, as I am minoring in Geospatial Information Systems, and have experience with spatial analysis and databases, such as Geodatabase and shapefiles with ESRI ArcGIS. I've looked into the supported spatial features of both MySQL and phpMyAdmin, and have found that phpMyAdmin already supports creation of columns with MySQL supported spatial types as well as well known text (WKT) and well known blob (WKB) spatial functions. However, user input of spatial data is still very much textual with Backus-Naur grammar and is not sufficiently intuitive. It'd be interesting and useful to support graphical data input and spatial data representation with the following improvements: 1. Browser transformation to represent spatial data in a variety of formats, such as an image with point/line/polygon or Google Maps with overlay, 2. Spatial data entry with Google Map location pinning. Any comments or feedback will be much appreciated. Thank you for your time! =) Frank LIAUW

3 3

[Phpmyadmin-devel] pmahomme and column width in browse mode
by Marc Delisle 04 Mar '11

04 Mar '11

Hi, as tested with sakila.actor, the actor_id (SMALLINT) column is very wide. -- Marc Delisle http://infomarc.info

4 5

[Phpmyadmin-devel] pmahomme and big logo
by Marc Delisle 04 Mar '11

04 Mar '11

Hi, do we really need the big form of the logo with sailboat? -- Marc Delisle http://infomarc.info

4 5

[Phpmyadmin-devel] CSP and new version check
by Piotr Przybylski 04 Mar '11

04 Mar '11

Version check fails with current trunk and browsers supporting Content Security Policy (eg. FF 4.0b12): "CSP: Directive "allow http://localhost" violated by http://www.phpmyadmin.net/home_page/version.js" We should specify script-src with 'self' and www.phpmyadmin.net as allowed script sources. -- Piotr Przybylski

2 1