Michal Čihař - Blog Archives for phpMyAdmin

phpMyAdmin code documentation

For some time, code documentation for phpMyAdmin had no official place. The reason for this was phpdoc eating way too much memory on daily runs, so I've disabled the cron job. Today I gave a try to DocBlox and it seems to work fine, so I've re-enabled daily builds.

The new (daily updated) documentation is available at same location as the original one was:

http://www.phpmyadmin.net/phpdoc/

You can also check build failures in the build.log:

http://www.phpmyadmin.net/phpdoc/build.log

New features in phpMyAdmin

As most of the GSoC projects in phpMyAdmin go on quite well, we're already merging some of the new features to our master branch. You can try them all on our demo server and you are welcome to report any issues found :-).

First big part which has been changed is rewriting of server status page done by Tyron Madlener. It now provides more information, provides real time charts and much more. This change also included change in charts produced in other places in the code, so they are now more interactive and allow easy exporting.

The browse mode got improved as well, you can now reorder columns (by Aris Feryanto) and there are new options for displaying GIS data (by Madhura Jayaratne). While speaking about GIS, I have to mention another new feature - rendering of GIS data, either as polygons or on OpenStreetMap map (you can see it by clicking on "Visualize GIS data" link on browse page, it is not possible to link it directly due to XSS protection).

Many smaller changes are being done by Thilanka Kaushalya to convert various parts of user interface to AJAX.

And last but not least we have nice support for editing stored procedures and functions. Support for events and triggers will follow soon. All these are being done by Rouslan Placella.

I hope you will like these new features and thanks to all our GSoC students who are doing great job.

Lack of time

You can see it from my blog activity as well, I simply lack time for lot of things.

My Gammu mail folders are horribly full of unread mail, it took me there three months to release a new testing version and there are still some patches pending for review.

On phpMyAdmin side I spend most time with my GSoC students, who progress really well, but that's pretty much all I can do there. The good news is that phpmyadmin.cz website has new maintainer and is again getting new content. Hopefully it will stay alive for longer time to bring back lost visitors.

My Debian contributions are in still pretty good shape and I manage to fix important bugs, though my MPD related packages are still for sale. Still considering whether to go or not to go to Debconf, my decision will be probably based on fact whether I will get travel sponsorship or not (and when it would happen).

Besides these free software activities I began to be more active in Společné aktivity (in Czech) project for organizing various activities to spend free time.

Occasionally I also contribute to OpenStretMap, but it's more or less random time when I notice something is wrong or when I manage to visit some place which is not that good mapped. The good thing is that Prague is pretty good shape there, so it does not motivate me to spend too much time on this :-).

And of course there is my work at SUSE, working on usual L3 front and improving our Django based incident tracking tool.

Maybe I should step down from some of these, but it would be pretty hard for me to choose which one...

phpMyAdmin 3.4.0 is out

Today, Marc has released phpMyAdmin 3.4.0. This is huge step and introduces lot of new features. The most noteworthy are:

  • User preferences
  • Relation schema export to multiple formats
  • ENUM/SET editor
  • Simplified interface for export/import
  • AJAXification of some parts
  • Charts
  • Visual query builder

As you can see, many of new features come from last GSoC, it took us almost half year to stabilize all new stuff and make it work nicely together.

Thanks to last minute improvements in Japanese, it is fully translated to 15 languages, other translations are little behind, but you can still help improving them for future releases.

The master branch is now open to development and we will start to merge patches accumulated in patch tracker for addition after feature freeze.

PS: I forgot to mention that this release fixed largest number of feature requests and bugs ever - over 160 issues from sf.net tracker got closed. This can be nicely seen on tracker stats.

PS2: Package with new version was just uploaded to Debian.

phpMyAdmin translation status

It's time to report again progress on phpMyAdmin translations. I will make it shorter this time :-).

There has been great progress in translation progress. Japanese translation is near completing (only 55 messages are missing right now) thanks to Yuichiro who did tremendous work there. There is also ongoing effort for Sinhala translation lead by Madhura Jayaratne. Nevertheless the number of complete translations is still 14 (see my previous post for complete list).

Besides translating phpMyAdmin itself, there was lot of work on translating documentation, so we now have complete documentation translated to Spanish and very good progress on Chinese one.

As the final release of 3.4.0 is really close, anybody is welcome to translate missing bits. Any Norwegian, Polish or Finnish readers of this blog? I'm sure you can still make your translation complete! (Others are welcome as well of course.)

GSoC projects for phpMyAdmin

This year we will have two more projects is GSoC comparing to last year, the chosen ones being:

  • OpenGIS support for phpMyAdmin by Madhura Jayaratne
  • Zoom-search by Ammar Yasir
  • Browse-mode Improvements ++ by Aris Feryanto
  • Drizzle support by Piotr Przybylski
  • AJAXify phpMyAdmin Interface by Thilanka Kaushalya
  • Support for Procedures: Creating a user friendly interface for the manipulation of routines, triggers and events in phpMyAdmin by Rouslan Placella
  • Query statistics & charts for the status page by Tyron
  • phpMyAdmin Automated Testing by Zarubin Stas

Looking forward to cooperation with new students, especially Madhura, Rouslan and Tyron, which I will be mentoring.

phpMyAdmin translation status

We're heading to release candidates for phpMyAdmin 3.4.0 (probably once GSoC application/evaluation rush period is over), so the translators have less time to make the translations better. There is no new complete translation, so we still have 14 translations at 100%:

There are still lot of translations which would need some love, for example:

Recently two of our prospective GSoC students started to contribute to translations, so there is great progress in Sinhala and Hindi translations. Looking forward to have these completed soon :-).

You can also help make translation to your language better! If your language is missing just let me know (either in comments or by email).

Bits from GSoC applications

Reading GSoC applications is sometimes funny. This year I've decided to be active only in phpMyAdmin projects, but this still gives enough interesting texts.

Some people definitely did not even care about looking at our name and think phpMyAdmin is written in C:

I assume this project would require C/C++ programming and, of course, SQL.

We ask people to tell us a little about their real life, in most cases this includes information where did the student study and so on, but sometimes it is just:

I'm a fairly standard guy.

In some cases people rather use some random file sharing service to post their CV and I'm too impatient to wait for several minutes till free download is available and I'm definitely not going to pay to download it.

PS: As usual, the last day we receive most incomplete proposals over the time. Generally I think that the best proposals arrive at beginning and the quality lowers. This is probably heavily influenced by our requirements for students to know the code before and advertising GSoC early, so that the really interested ones are ready to submit proposals as soon as the interface is open, while others trying to catch train later.

Pushing harder on incomplete translations

Looking at current state of some phpMyAdmin translations, I came to conclusion that some are not worth shipping, because they really do not translate reasonable amount of the interface. The problematic question is where to draw the line. For 3.4.0-rc1 I drew it at 50% of messages, what means that 25 languages currently pass. It might look too strict and the threshold will most likely change for final 3.4.0, but we need to start somewhere.

While discussing this topic on mailing list, Tyron Madlener came with idea to tell users of incomplete translations about it and point them to information how to contribute. I quickly implemented this idea and it is now in git and live on demo server. I deliberately decided not to remove incomplete translations on demo server, maybe they will attract new contributors thanks to new warning on main page.

Pleased by GSoC applications quality

So far I'm quite pleased by quality of GSoC applications we receive for phpMyAdmin. Tightening our applicant guide seems to be good idea and getting people active early and discuss the proposals seems to filter out the bad ones.

This also means that we will probably receive much less applications than last year. We've received 64 last year and we're not yet at half of the count, while only three days are left for students to submit their proposals.

Anyway take this as friendly reminder that not much time is left, especially if you want to receive some feedback for adjusting missing bits in the proposal.