- Developers - lists.phpmyadmin.net

[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

[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