Michal Čihař - Blog Archives for English

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.

Gammu supports Symbian (and going for Android)

Hackweek 6 is over and my project is done - Gammu can now talk to Symbian phones. All the work is based on Series60 - remote applet. The changes on Gammu side were not just to implement new protocol, but also some more general improvements it enforced. I think the diffstat summary tells how much was changed:

166 files changed, 23126 insertions(+), 15738 deletions(-)

All code is is available in our Git repository and check documentation for information how to set it up. There will be testing release incorporating these changes next week to give broader audience chance to test it.

So now Gammu has long requested support for Symbian and we need other challenge. That seems to be Android right now and there are already two approaches which might help there. One of them is porting Series60 applet to Android, what is planned by Series60-remote author. There is also other promising way, where I can not share much details right now, but I can give you a little teaser:

$ gammu identify
Device               : 192.168.1.4 5210
Manufacturer         : HTC
Model                : unknown (HTC Nexus One)
Firmware             : FRG**
IMEI                 : **************8
SIM IMSI             : **************7

Yes, getting basic information already works for the developer working on it :-).

Installation of S60 applet to the phone using Gammu

I've (again) changed schedule of what to implement and I've spend fourth Hackweek 6 day by doing more cleanup and documentation work than real coding.

The major new feature is support for direct installation of the applet to the phone, so the installation is now easier. There were minor improvements on the both sides to allow support for calls and deleting of SMS messages. Adding calendar and todo entries is still left for future (hopefully tomorrow).

I've done (more or less) final cleanup of my changes in the applet itself and I've sent changes back upstream hoping for merging them (I'd give you link to the mail, but the archive does not work).

Rest of the time was spent collecting feedback from users testing the code (surprisingly there are already few brave users who gave it a try). It resulted in few bug fixes and improved documentation.

Last but not least - all code is is available in our Git repository and check documentation for information how to set it up.

Sending SMS on Symbian phone using Gammu

Third Hackweek 6 day went a bit differently than I planned, but there is still lot of progress.

I've added some more calls to the Series60 remote protocol, so that some things now work much faster (eg. getting number of contacts, calendar entries). The applet now also has a function to toggle Bluetooth so it does not have to be done elsewhere in phone menus.

On Gammu side I focused on messaging support, so now Gammu can list messages in the phone or send new message.

Modification of calendar entries is left for tomorrow, hopefully I will get to it and the support will be more or less complete and I will have Friday for final cleanup.

And as usual - all code is is available in our Git repository and check documentation for information how to set it up.

Gammu has calendar and screenshot support for Symbian

I've spent second day of Hackweek 6 on more different tasks.

First I tried to add some improvements to Series60 applet. First things to fix were crashes on requesting non existing contact or calendar entry. After that I started to improve user experience a bit, for example by making the menu work and contain some useful things. After that I've added new functionality to capture screenshots of the device. So you can see how the applet actually looks like:

S60 main screen

S60 menu

On the Gammu side, I've implemented reading of contacts and todos. No write support yet, that will be done tomorrow. And of course counterpart for the screenshot function.

I've also spent some time on writing documentation, so now there is some documentation on setting up the S60 connection or the new gammu screenshot command.

All code is is available in our Git repository.

Gammu can read and write contacts from Symbian

First day of Hackweek 6 is almost over and my progress is quite good so far. The first step wat to make Gammu connect to the Series60 applet and retrieve basic information:

$ ./gammu/gammu identify
Device               : 5C:57:C8:xx:xx:xx
Manufacturer         : Nokia
Model                : E52 (RM-469)
Firmware             : 3.0
IMEI                 : 359000000000000

That was pretty easy. If you want to try it, you need to install Series60 applet into phone (manually for now, but autoinstallation is planned for future) and configure gammu to talk to it:

[gammu]
connection = blues60
device = 5C:57:C8:xx:xx:xx

Second thing I choose to implement was manipulation with contacts. There are some oddities in the applet (like it simply crashes when giving it wrong contact ID to retrieve), which I will try to fix in future, but for now I stick with existing applet and code functionality only in Gammu. And it works:

$ ./gammu/gammu getmemory ME 215
Memory ME, Location 215
Last name            : "Gammu"
First name           : "Test"
Mobile number        : "123456"
General number       : [home]"654321"
Email address 1      : "gammu-users@lists.sourceforge.net"

0 entries empty, 1 entries filled

Tomorrow I should be able to implement calendar, let's see how will it go.

PS: All code is is available in our Git repository

Hackweek and Symbian support in Gammu

Last year I did not have much time to spend on non work related projects in Hackweek, because we took the opportunity and replaced some internal systems, when people were not using them. It will be different this year and I've decided to spend some time on Gammu.

The plan is to implement support for Symbian phones. It is one of frequently requested features and thanks to Series60-remote I can as well see way how to implement it. Current plan is to add support for their applet, with possible extending it in future and adding some features which it lacks.

You can comment this feature in openFATE or Gammu bug tracker.

PS: Introduction video can be found on blip.tv.

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 :-).