Earth Hour

As you can see from the bar on the top of the site (if you are reading this in your RSS reader, take a break and step out to the real site for a minute), Floating Sun is participating in Earth Hour. What is Earth Hour?:

Earth Hour began in Sydney in 2007, when 2.2 million homes and businesses switched off their lights for one hour. In 2008 the message had grown into a global sustainability movement, with 50 million people switching off their lights. Global landmarks such as the Golden Gate Bridge in San Francisco, Rome’s Colosseum, the Sydney Opera House and the Coca Cola billboard in Times Square all stood in darkness.

The funky bar is courtesy the earth hour plugin. Of course, just having a CSS distraction on the website doesn’t do much if it is not followed up by real action. I will be turning off the lights in my apartment at the prescribed time and so should you. I’ll also try to rope in as many of my friends as I can. Remember, this is about making a choice. A single lamp in your house for an hour probably feels trivial, but with millions of people, it adds up. Besides, it is a gesture to show your solidarity and support and committment.

Are you going to take part?

How is TV viewership measured?

I’m sure you must have read the headlines. You know, the kind where we get to hear how badly a highly anticipated show did, just hours after it came on TV. Or how well a particular show is doing against shows on competing TV networks? My question is, how do these people measure these numbers, and measure them so quickly?

Ranking

Think about it for a second. Television is, for the most part, a broadcast medium. That is, our television sets mostly just receive data and hardly ever send anything back. You could say that this communication channel is mostly one way.

The Wikipedia page on Nielson ratings sheds some light on the matter:

One involves the use of viewer “diaries,” in which a target audience self-records its viewing (or listening) habits.

I’m not sure how much trust I can put in this methodology. But there is hope:

A more technologically sophisticated system has used Set Meters, which are small devices connected to every television in selected homes. These devices gather the viewing habits of the home and transmit the information nightly to Nielsen through a “Home Unit” connected to a phone line.

But this still doesn’t sound like a good solution. I also read somewhere that another popular methodology involves calling up randomly selected people and questioning them about their viewing habits!!

These days the situation is still a little bit better. Set-top boxes and  DVRs are becoming increasingly prevalent. These devices are significant more powerful and smarter than their ancestors, in the sense that they already do a fair bit of communication with your cable company, and hence it is conceivable that they enable collection of more accurate usage statistics.

Overall, it seems like a hard problem to me, since television has traditionally not been a connection oriented medium. This might change moving forward as IPTV and on-demand videos become more common. If you have some more information on the nitty-gritties of how this all works, please do share!

Milestones

I have been away from this blog for quite a while now and much has happened since then. The past few months have been extremely busy but also quite eventful. 2008 was a very important year for me as I hit several big milestones. Each of these warrant posts of their own, but these one-liners will do for now.

Milestones

First, I successfully defended my PhD on October 31st. I have since finished all the paperwork and filed my dissertation. I am now, officially, Dr. Gupta! :-)

PhD

Second, I had a blast doing job interviews, and was in the difficult, but fortunate position of having to choose among several excellent offers, especially given the current economy. I will be joining Aster Data in a few days!

Work

And finally, I got married to this most wonderful woman! While our wedding was crazy and intense and hectic and a ton of fun, I have come to believe that the reason marriages are more successful in India is that just one marriage drains you so much that you can’t even think about ever getting married again :-D

Diwaker and Surabhi

Amarok ate your stats?

I have a reasonably large music collection. In a desire to trim this collection down to stuff that I really like, over the years I have painstakingly rated my songs in Amarok. But twice, now, I have had Amarok eat up all my ratings and scores and play counts and other stats. This post will show you how to recover from such a loss.

Amarok

The first solution is for a situation where an Amarok upgrade caused the stats to be lost. I was using the default Amarok setup — that is, all the stats are stored in a file on disk using sqlite. During my Amarok upgrade, Amarok decided to create a new database. Fortunately, it left the old sqlite database file lying around. If you have an old version of your database, you can restore the stats using the following script:

The next scenario arose when I switched to using Amrok2 recently. Now, granted that Amarok2 is still under heavy development and hence the requisite migration paths might not be in place. But I still hate to lose all my stats. Amarok2 uses embedded MySQL instead of sqlite to store all its data. The following script uses your old database to restore all the stats in the new database.

Note that for this to work, you need to first start a MySQL server using the embedded MySQL directory as the data backend, as pointed out here.

Hope that helps!