Michal Čihař - Archives

phpMyAdmin translation status

As we're slowly heading towards phpMyAdmin 3.4, it is good time to look at current translations state.

There are few which are already at 100%, so they are in best possible shape:

Some languages really miss just few messages, so they will hopefully get to 100% soon:

And there is huge progress in Russian, which will at this pace get to 100% this week.

Was your language not listed? You can help it being better!

Upgrading to Squeeze

Squeeze was released this weekend and it's time to slowly migrate servers to it. The first to upgrade came the ones backing up phpMyAdmin demo server. Reason for trying them first is they have mostly same setup as other, while definitely not being critical to run all the time. For simple reasons that users break them time to time as well :-).

Everything went surprisingly smoothly, the only problematic thing being no availability of MariaDB packages for Squeeze right now. But it does not matter that much, as Lenny packages still work fine.

There should be no visible changes on the servers, but in case there is something broken, please let me know.

While having experience with upgrading database servers, I went to production database server and it is now running Squeeze as well. What still remains is the server doing virtualization, but I prefer to do this in time when I can quickly get to the housing, in case something goes wrong with the reboot.

New phpMyAdmin themes

Today, I've made available two new themes for phpMyAdmin on our demo server.

First one is Toba theme which was contributed by Azhari Harahap:

Toba theme

Second one is Graphite theme which I've started during Hackweek and finished during free time around FOSDEM:

Graphite theme

And we're still waiting for more contributions to our Theme contest.

PS: Forgot to mention that new themes are only for 3.4 branch and won't work with others.

phpMyAdmin improvements

As my Gammu Hackweek 6 project went smoothly, I've decided to spend some time today on phpMyAdmin as well.

My work was mostly inspired by (IMHO unfair) comparing of Adminer and phpMyAdmin. I could surely create similar comparing where would be dozens of things why is phpMyAdmin better, but I don't want to go that way and I rather decided to spend my time on coding.

First and easy task was bit which is in comparing described as "Status variables", where I've added documentation links, so phpMyAdmin now has both short executive summary and link to the official documentation. While looking at server status page, I've categorized some newly added variables, so they now appear in right place. I also reconsidered formatting of numbers and hopefully current solution will work for everybody and not produce contradicting bug reports like the old one.

Then I did focus a little bit on testing AJAX and fixed some minor issues, mostly affecting Chrome/Chromium browsers, because they are strict in case of some errors.

Last but not least I've added URL redirector inside phpMyAdmin, so no external links will now reveal what did user actually was doing in phpMyAdmin, but rather the url of the redirector.

And when speaking about phpMyAdmin, I need to mention one thing as well: contribute yourself! You don't have to be developer, there is currently ongoing themes contest and we're always looking for translators.

Going to FOSDEM 2011

It looks like I will make it again to visit FOSDEM this year. This time it won't be meeting of whole phpMyAdmin team, but just few members but I hope to meet other people in person as well.

If you have something you would like to discuss with me in person there, it's best time to let me know so that we can schedule it.

I'm going to FOSDEM, the Free and Open Source Software Developers' European Meeting

PS: It looks like it might be good timing for Debian release party as well :-).

How good is phpMyAdmin translation to your language?

phpMyAdmin 3.4 is about to be released in something like two months (we want next beta to ship with brand new theme) and there is still plenty of translations to do.

You still have lot of time to translate, but there is also lot of work to do. And I'm pretty sure there are some Slovak, German or Italian speaking readers of this blog. So what are you waiting for? :-)

phpMyAdmin theme contest

If you like phpMyAdmin and have web design skills, this is a chance for you. The question for new default theme has been opened for a while and in last weeks we've finally decided to rather make open contest than to stick with choosing from existing themes.

All you need to do is to submit theme (compatible with phpMyAdmin 3.4) till 13th February 2011. You can find more details on our wiki.

Mastering phpMyAdmin 3.3.x for Effective MySQL Management

The book Mastering phpMyAdmin 3.3.x for Effective MySQL Management is already available for some time, but I still think I should promote a little bit in my blog so here it is :-).

The book covers all you might want to know about using phpMyAdmin. It really does not make sense to copy text from book description, so feel free to find yourself what all it does cover.

As every time, this book is written by Marc Delisle, who is for several years project admin, so probably the person who knows most about hidden features. Usually technical review of the book is done by some other developers and this time it was me doing this job (among other reviewers). I hope we did good job and you will like this book.

Mastering phpMyAdmin 3.3.x for Effective MySQL Management book cover

PS: As a nice bonus, the phpMyAdmin project receives money from every purchased book.

New year

It's new year (for almost 18 hours here) and it's time to balance a bit what has happened in year 2010.

I'm not going to expose details from my personal life and anything related to work, so all what remains are open source projects where I am active.

For phpMyAdmin it was year of quite big changes, most of them beeing agreed on Fosdem 2010. We have migrated to git from svn, what was great step forward and I really like the change. It was also decided to use gettext (or rather php-gettext) for translations in upcoming release. I can see this move (together with online translation service) has definitely attracted more contributors (hey, but there are still many languages not translated, you're welcome!). Also we've participated in Google Summer of Code 2010, what lead to several big projects being merged into our code base (see my summary for more details). All in all, we're heading to 3.4 release in first months of 2011, which will be quite major step and hopefully heading in right direction.

In Gammu and Wammu, there were lot of code improvements, most of them probably going into Gammu SMS Daemon (the latest one being unified SQL backend removing lot of code duplication). Another major improvement is The Gammu Manual covering everything from Gammu command line, through SMSD up to python and C API. On the other side I've bought me a Symbian based phone, which does not work with Gammu and I use Series60-Remote for that, so my interest in Gammu has declined a bit.

Even though I've started adopting some packages in Debian, so it looked like I will end up with much more than last year, but at the end I've decided I'm too overloaded with some of them (and don't use them anymore), so I've given some for adoption and got rid of nanoblogger (and nanoblogger-extra) and looking for somebody to pick up gpointing-device-settings. Maybe all mpd related packages will follow soon, because I currently do not use mpd, so it limits quite a bit my ability to test them.

And of course: Happy New Year 2011!