Michal Čihař - Blog Archives for English

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.

Thanks for motivating me

This is a bad day. I'm bad guy because I don't have web pages about Wammu in my native language, I hacked absolutely useless CSV import code in phpMyAdmin. What comes next?

I would make bilingual pages if I'd have time for that, but I will rather write new feature in Wammu than spend time on this.

And I know export is not perfect, everything can be improved and you are welcome to do that!

Sample config after long wishes

Since we've removed default configuration from top level directory, people often copied config.default.lib.php what was not something we wanted.

Last week I finally decided to make some sample config which will be placed in top level directory, so that people can easily start from it and add further options after reading documentation or wiki. Let's see if it will prevent people from copying defaults in upcoming release.