June 2010 - Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] Ninad tree and operations / db renaming
by Marc Delisle 21 Jun '10

21 Jun '10

Hi Ninad, in origin/master, when I rename a db I see all the queries that were done; also, the navi panel is updated to the new db. In your version, I see none of these queries; also the navi panel is not updated and a dialog "reload database" appears, in which clicking Yes apparently does nothing. -- Marc Delisle http://infomarc.info

1 0

[Phpmyadmin-devel] phpMyAdmin 3.3.4-rc1 is released
by Marc Delisle 20 Jun '10

20 Jun '10

Welcome to the first release candidate of phpMyAdmin 3.3.4, 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

1 0

[Phpmyadmin-devel] Base64 encoded images in HTML
by Martynas Mickevičius 18 Jun '10

18 Jun '10

Hello everybody again, so today I started working with charts as images rendered by PHP. I wanted to ask what do you guys think about encoding images in the HTML using base64 like this: <imgsrc="data:image/gif;base64,R0lGODlhUAA....j5+g4JADs=" /> I thought about these pros and cons. First of all pros: - no additional request to fetch the image from server. - image generation script can return multiple values. For example the image itself and the image map (later used for tooltips) can be returned. Cons - some overhead is introduced when encoding binary data into base64 format. On my experiment 46kB image was encoded into 60kB. (~30% overhead). - Script execution is halted while the image generation is in progress. This introduces slower response times for pages, which show charts. (If the image is loaded in a "normal" way, in many browsers page is started being rendered before images are received from the server). This problem can be solved by writing rendered charts to disk. However almost all planned charts are going to display dynamic data (query results, profiling data, query statistics). - Generated images can not be linked to externally. (hardly a problem for PMA) The only real problem that I see is the longer script execution times. However all the charts will be generated only on user request, so we can assume that the user knows that the chart is coming soon and expects to wait a little bit more. Both techniques are easy to implement. I have already images as base64 strings working. Changing this would be a matter of minutes. What do you think? Martynas

2 1

[Phpmyadmin-devel] flash files
by Martynas Mickevičius 16 Jun '10

16 Jun '10

Hello, I wanted to ask where should I put the flash files needed for Charts. I believe it would be good to create a folder *flash* in the root directory and put them there. Is it OK? Martynas

6 10

[Phpmyadmin-devel] Setting up phpmyadmin foreign key browse
by Keith D. Mitchell 08 Jun '10

08 Jun '10

Hello, I recently migrated a client from a Plesk instance that had phpmyadmin and the phpmyadmin foreign key browse enabled. The new server does not use Plesk and I've been having a heck of a time setting this function up again. I've setup the phpmyadmin database, but I did so after I imported the database. Was wondering If I had to reimport the DB again since this function had to be enabled prior to the import. Thanks kmitchell(a)hosting.com | Facebook<http://www.facebook.com/#!/pages/Hostingcom/83819275924?ref=ts>| Twitter<http://twitter.com/hostingdotcom>| Linkedin<http://www.linkedin.com/in/keithdmitchell27> |

2 5

Re: [Phpmyadmin-devel] Icons
by Michael Keck 08 Jun '10

08 Jun '10

Hi, You're right I've designed most of the icons in the PMA. But now at moment I'm quite busy with my real job, so please take first the ones you've taken from anywhere. I've started designing a complete new icon set for PMA, and I will release soon as possible after finished my project at real job. It would take round about five days. My suggestion is, to take all needed icons in a icon-map an position them with css. This may reduce download size and speed up rendering in browser. Nearly all good browsers can handle this. The original jQuery UI does this also. The other goal is, to give users a chance to change the icon-size. So I suggest to create the icons in four sizes: 16px, 20px, 24px, 32px. Because with HD-Displays it would be nice to change the font size and the size of icons to ;) But for this, I think we have to replace all <img> with an other thing (<span>, <div>) and give them a special class like 'nav-tab-browse', 'main-list-font-size', like jQuery UI does. Regards Michael Am 08.06.2010 01:29, schrieb teekirol(a)users.sourceforge.net: > Message body follows: > > Hi Michael, > > I'm one of the students participating in Google Summer of > Code (cleaning up the user interface) and I'm in the process > of redesigning the main.php page to look like this: > http://lorilee1.files.wordpress.com/2010/06/main_new_expanded.png > (without the minus icons on the MySQL, Web Server, and > phpMyAdmin groups). > > Michal Cihar believes that you designed most of the icons on > phpMyAdmin, so I was wondering if you could help me out with > designing two icons, for custom color and font size (the > ones in the screenshot I just took off of Google Images). If > not, do you know if there is someone else that I can contact? > > -- > This message has been sent to you, a registered SourceForge.net user, > by another site user, through the SourceForge.net site. This message > has been delivered to your SourceForge.net mail alias. You may reply > to this message using the "Reply" feature of your email client, or > using the messaging facility of SourceForge.net at: > https://sourceforge.net/sendmessage.php?touser=2869926 > >

2 1

[Phpmyadmin-devel] Icon Designer?
by Lori Lee 08 Jun '10

08 Jun '10

Hello, I am wondering, is there one designated person who designs all the PMA icons? I'm asking because I need two icons for the main page; one for "custom color" and one for "font size." -- Thanks, Lori

2 2