Todays webtip: Jamendo

On December 21st, 2008 | , | 1 Comment | Permalink

It happens very rarely that I post webtips. Because I’m not that kind of guy who’s posting youtube videos in his weblog. But today I found a real piece of jewellery: Jamendo.

Jamendo is a community of free, legal and unlimited music published under Creative Commons licenses. Share your music, download your favorite artists! Free, Legal, Umnlimited.

You don’t need no login and don’t need do accept licences. Just select your favorite genre, listen to the songs and download the album if you enjoy it. Or buy the CD from the artist website if you realy like it.
There is also a very wide scope of music, e.g. 8-bit lagerfeuer by pornophonique: Very cool music in 8-bit style with some locals in “lagerfeuer romantik” with songs like: “take me to the bonuslevel because i need an extralife” or “space invaders”.

Needless to say that it has all the web2.0 features like: widgets for your own weblog, playlists to share or commenting and rating of the artists.

Enjoy it!

My 1st marathon - Bonn (DE)

On April 21st, 2008 | | No Comments | Permalink

Look, if you had one shot or one opportunity
To seize everything you ever wanted in one moment
Would you capture it or just let it slip?

Eminem - Loose Yourself (Intro)

Sunday, April 20th 2008, Bonn (Germany):

  • km 0 - start
  • km 11 - I found the 3:59:59 p(e)ace maker
  • km 21 (1:56) - stopover at McDonalds (the only toilet on the way)
  • km 25 - it’s getting harder with every kilometer
  • km 28 - the hardest part (12 minutes for this only kilometer)
  • km 29 - turned on the iPod - the viewers on the track have done a great job so far
  • km 32 - self-catering in the bag was broken, very adhesive affair
  • km 37 - cramp in the calf, so from now on only very small steps
  • km 42 - it’s done - finished in 4h and 19 minutes - I’m immortal

MySQL-Query: Howto select upcoming birthdays

On December 20th, 2007 | | 1 Comment | Permalink

In a recent software project I needed to select the upcoming birthdays of the
users. But now I detected a problem with the turn of the year. After some time
of researching and trying, I found a stable solution. For your convenience,
here’s the code:
SET @today = '2007-12-20';
SELECT
user_id,
birthday,
DATE_FORMAT(@today, '%Y') - DATE_FORMAT(birthday, '%Y') + IF(
DATE_FORMAT(birthday, "%m%d") < DATE_FORMAT(@today, "%m%d"), 1, 0) AS new_age,
DATEDIFF(birthday + INTERVAL YEAR(@today) - YEAR(birthday) +
IF(DATE_FORMAT(@today, "%m%d") > DATE_FORMAT(birthday, “%m%d”), 1, 0) YEAR,
@today) AS days_to_birthday
FROM users
HAVING days_to_birthday < 14
ORDER BY days_to_birthday ASC;

And you can easily extend it to limit the result to some specific ages. This is
very useful if you want only the big O coming up:
...
HAVING days_to_birthday < 14 AND new_age IN (10,20,30,40,50,60,70,80,90,100)
...

data retention

On November 9th, 2007 | | 1 Comment | Permalink

Today the German parties CDU, CSU and SPD voted for data retention. From 2008 onwards it will be possible to trace who has contacted whom via telephone, mobile phone or e-mail for a period of six months. In the case of mobile calls or text messages via mobile phone, the user’s location will also be logged. Anonymising services will be prohibited.

2007-09-08-02-back-in-switzerland.jpg

The data that will be collected about the entire population will allow our movements to be traced, any calls or communications with business contacts to be monitored and will remove privacy in our personal relationships. It also allows the content of communications to be analyzed, content such as personal interests and the individual life circumstances of the person communicating. Access to the data is to be granted to the police, public prosecutors, secret services and foreign states which hope for better prosecution of crimes.

So for this sad day, my website turned black. rest in peace, german basic rights!

My 3rd half marathon - Bodensee (DE/AT)

On October 7th, 2007 | | No Comments | Permalink

I finished my third half-marathon just a few hours ago. The start was in Lindau (DE) and the finish in Bregenz (AT). Everything was very well organized (including a massage afterwards), the weather was great and our team was well prepared. Ok, I had some little problems with my shoelaces. But they didnt stopped me. This time I made it in less than 2 hours. The exact time is: 1:53:45. I expected something around 1:57:00, the more positive surprised am I now.

Now I can dare to start at a marathon. And so I registered for the Bonn-Marathon on April 20th, 2008 to fulfill my dream: finishing a marathon.

Istanbul reached

On September 4th, 2007 | , | 1 Comment | Permalink

Hello from Istanbul,

we (Christian, Jan, Robert, Georg and I) arrived today in Istanbul. After 25 days and round about 2600 kilometers we finished our big tour without big problems. Now I have 3 days to enjoy Istanbul and prepare my bike for the flight back to germany.

See you all there again. Bye.

Summer vacation

On August 10th, 2007 | , | No Comments | Permalink

Today, I switched on the “out of office” reply for my emails, because I’m taking some weeks off.

I’m going to travel by bike from Salzburg to Istanbul. This isn’t a “vacation” for you? But for me it is. Relieve stress, see some new places and meet nice people is all I expect from my vacations. And I can hardly wait to get on the first stage.

So you want to know where we, yes I’m not cycling alone, are right now? You can find the current status regularly updated on our website: Orient-Express en vélo. A Google map is also available.

Previous entries can be found in the archive.
rss feed icon Receive the latest blog news on your browser or newsreader.

top