• [Tech] Verifying mysqldump output the quick-n-dirty way

    Inspired by a recent blog post over at LGP I wrote this little bash function to verify if a mysqldump command has written the correct data to the filesystem: blindcoder@fortuna:~$ type mysqldump mysqldump is a function mysqldump () { filename="`readlink /proc/${$}/fd/1`"; exec > "`readlink /proc/${$}/fd/0`"; executable=""; for path in ${PATH//:/...


  • [Tech] Counting rows in a GROUP BY directive in MySQL

    Let's say you have a mysql table that looks like this: ID - Name 1 - AAA 2 - AAA 3 - BBB 4 - BBB 5 - CCC 6 - DDD Now you want to count how often 'AAA', 'BBB', 'CCC' and 'DDD' appear in your table. You would...


  • [Tech] Targus TSB312-200

    A short question to the customer support at Targus: Dear Sir or Madam. About 5 years ago I bought a TSB312-002 in the online shop "Thinkgeek.com" and was very happy with it ever since. It accompanied me to Austria, Italy, Switzerland, Turkmenistan, Indonesia, Tanzania, USA and Morocco. It still is...


  • [Solutions] Quickly traversing an information tree

    I just got to link the article in LGP's blog about How to search a data tree efficiently. As the article states, it really makes you go 'Why didn't I think of that?'. EOF


  • [Travel] (fast) 5 Wochen Marokko

    Am kommenden Montag werde ich Marokko verlassen. Ich werde dann fast fuenf Wochen dort gewesen sein. Fuenf Wochen unrasiert und fern der Heimat, was kann man da ueber ein Land, das sich so grundlegend von Deutschland unterscheidet sagen? Nun, die Taxifahrer hier haben jeden Selbsterhaltungstrieb ueber Bord geworfen. Ich war...