Michal Čihař - Archives

Gammu has ODBC support

One of features for Gammu SMSD which was for quite a long time in my head was ODBC support. With unified SQL backend we have right now it should be pretty easy to add support for it so I gave it a try.

It really did not take to long and the ODBC driver is committed to git and will be part of next release. The great benefit of this is that we get native database support on Windows without need to linking against database libraries, which is always painful.

The ODBC driver behaves like any other SQL based driver for SMSD, so if you are familiar with it, the configuration won't surprise you:

[smsd]
service = sql
driver = odbc
host = dsn_of_your_database
user = username
password = password

All important information about the driver should be available in the manual.

Bloating dependencies

It looks like many peoples decided it is right time to bloat my system with stuff I don't use.

The first think I did not like when squeeze went out was libpcsclite1 pulling pcsd and hal into my system. This is being solved on two fronts - porting pcsd to udev (in #612971) and disabling libpcslite1 support in wpasupplicant. Both of them being good ideas.

What actually drove me to writing this post is today's update, where aptitude suddenly wanted to install whole latex and thus using about 760MiB of extra disk space. I know disk space is supposed to be cheap these days, but it's not that cheap with SSD in notebook. The culprit turned out to be doxygen, which up to now happily lived without single bit of latex, but now needs it (though temporarily according to changelog).

I know it is tempting to enable every possible feature in your package, but in same cases it is really not something what most of people would appreciate.

OpenID in phpMyAdmin

Well not really. The simple reason is that it does not make sense without further integration with other services.

However if you want to deploy such solution, you can now base on example script, I've just pushed to our git repository. It is definitely meant only as example, major reason being storing MySQL user names and passwords in clear text in the PHP script.

phpMyAdmin has new theme

Following results of theme survey, I've changed default theme of phpMyAdmin to pmahomme:

pmahomme theme

I'm sure this new attractive look will improve user experience of upcoming 3.4 release. You can expect beta release with new theme soon and then we will hopefully smoothly continue through one (or more) release candidates to final release.

While making this theme default one, we've also offered team membership to Mike Hommé and I'm quite confident this will be valuable addition to the team. Mike, welcome on board!

phpMyAdmin translation status

Another week is over and it's time to look again at state of translations for phpMyAdmin 3.4. Compared to last week, there one three translations at 100%, so we now have 12 translations at 100%:

But there are still lot of translations which would need some love:

You can help make translation to your language better!

phpMyAdmin theme survey results

The phpMyAdmin survey for new theme is over and it's time to publish results. Today I will show only basic summary, I will dig deeper into the data later.

The first question for default theme has quite clear winner:

Default theme results

As the results are quite persuating, this gives no space to discuss.

Next question was about inclusion of additional theme in standard download kit:

Number of themes results

While two themes still have big majority, people are not that convinced about it.

The last question of the survey was which theme should be included as additional in the download kit:

Second theme results

I think this is most interesting result - while in question about default theme Graphite theme was clearly the second one, in this question people have indicated that Original theme should stay in the download kit.

I would like to thank to all 228 people who have participated (the number is low because the survey required email confirmation, but I still think it is better way than thousands of votes which are easily scriptable).

PS: You can see complete results on the survey site.

Last chance for phpMyAdmin theme survey

Today, you have very last chance to influence selection of new default theme in phpMyAdmin 3.4. You can choose from five themes (all of them are listed on our wiki).

Every opinion counts, so please visit our survey and choose the one you like most:

http://survey.phpmyadmin.net/index.php?sid=72977

Besides the Original and Darkblue_orange themes, there are following to choose:

Toba:

Toba theme

Graphite:

Graphite theme

pmahomme:

pmahomme theme

Photo of a week 7

I'm again almost one week late, but here comes photo from seventh week. The good news is that I've managed to process photo for eight week as well so it will follow soon. This picture was taken under Charles bridge in Prague.

National theatre in background

phpMyAdmin translation status

Another week is over and it's time to look again at state of translations for phpMyAdmin 3.4. Compared to last week, there one new translation at 100% this week, thanks to Dutch translators.

We now have nine translations at 100%:

There are three which were close last week, but are still not at 100%:

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