Michal Čihař - Blog Archives for English

Again fork of cdrtools?

This issue has arised already for many times (I remember it from times I worked for SUSE and there were some problems with unmodificable source parts), but this time it seems really serious. Current problem is in CDDL being incomaptible with GNU GPL while both are being used for cdrecord code. I again have to say I don't uderstand Jörgs behaviour.

Debian has replaced cdrtools with for of it called cdrkit. So keep in mind that you will have to use wodim instead of cdrecord in near future.

Wammu 0.15

Wammu 0.15 has been just released. New features:

  • Language selection for Windows (based on GTK+ 2 ISS code).
  • Finnish translation from rosetta.
  • Searching can be done plaintext and not only regexp.
  • Phone number matching now works even for national numbers.
  • Fixed usability with inveresed themes.

MSIE hacks

Okay it looks like I again found some bug in my favourite browser. There seems to be something wrong in border handling which makes subsequent blocks to have reverse indentation of left border widht.

So instead of simple:

body.blog blockquote {
    border-left: 0.5em solid #BBB;
}

I have to use:

body.blog blockquote {
    border-left: 0.5em solid #BBB;
    /* Following need to be in for MSIE */
    border-top: 0.5em solid #EEE;
    border-right: 0.5em solid #EEE;
    border-bottom: 0.5em solid #EEE;
}

Weblog has same design as rest of site

Today I finally managed to make weblog look same as rest of my pages. I know this look is not perfect, but I'm too lazy to create something better.

For now blog style is tested only in Firefox, I will look at it from others soon to fix possible bugs.

Let's face the history

While googling for something completely different, I randomly found Czech article about phpMyAdmin from year 2000. It would not be something special if there would not be following sentece:

Vývoj se zaměřil na verzi 3.0. Ta bude obsahovat "databázové abstraktní vrstvy" a umožňí použití s Postrges a ostatními databázemi. Verze 3.0 bude vyžadovat nejméně jednu další tabulku. Zatím se tomu pokouším vyhnout, ale je to asi nevyhnutelné pro určité vlastnosti (jako je například ukládání preferencí a uživatelských SQL dotazů). Verzi 3.0 můžete (doufám) očekávat na konci roku 2 000.

Short translation to English:

Development goes to release 3.0, which will contain database abstraction layer to support PostgreSQL and other databases. Version could be expected by end of year 2000.

Well, we still don't have release 3.0 and no databse abstraction (and we most likely never will have), but it is nice to see that something like that has been planned six years ago :-).

Google reveals phpMyAdmin searches

Day after finding Google webmaster tools, I came to idea to grab from there information about http://www.phpmyadmin.net site. Most clicked search results are predictable (number in brackets shows average position in results):

  1. phpmyadmin (1)
  2. phpmyadmin download (1)
  3. php myadmin (1)
  4. php my admin (1)
  5. download phpmyadmin (1)
  6. mysql (10)
  7. php admin (1)
  8. mysql admin (5)
  9. php mysql admin (2)
  10. myadmin (2)

People garble our name in various ways, but they mostly get what they want. What suprised me is average position on generic searches like php (25th position), donwload (102nd position) and especially "net download" (8th position). When I would search for net, I'd expect something else than phpMyAdmin to appear…

Anyway it looks we need to improve our rank as MySQL admin, so let's start with it :-).

Do Google sitemaps have effect?

I just looked over Google webmaster tools which looks like interesting way to get some information from Google about page ranking, top search where it is being listed and crawler found errors on pages. It also suggests everybody to supply sitemap with information about last update time of pages on site.

I found plugin for MediaWiki so I added it to phpMyAdmin wiki, generating it for this blog was pretty easy as here is only static content and for phpMyAdmin demo server with few indexable pages it was trivial. However I'm not yet convinced to invest much effort in creating sitemap for cihar.com as it is too complicate to create. Let's see if sitemap will make Google sooner index my changes.

Nanoblogger customisations for next time

As time goes, I again needed to touch NanoBlogger code. I again saw there is bug with calendar alignment, for which I made simple patch, hopefully it will get soon into CVS.

Another thing I wanted to improve is displaying of feeds in web browser. This can be simply done by adding CSS style.

If you want to list all category feeds on main page, you can find it in my patch for generating this listing.

Next code is to allow inclusion of blog listings in other pages on my site such as phpMyAdmin demo. This is achieved by generating special pages which only list entries.

And last thing is enabling and fixing of title based permalinks, which was first thing I hacked for NanoBlogger :-).

Update: I filed NanoBloggers patch tracker with all those patches, let's see how much of them will get included.