Blog

Project

As previously discussed I have a personal project. I don't use it much - TV Listings have moved on since it was first written - sky+, tivo, iplayer et all - basically any on demand service has relegated this project to basically useless. However the first incarnation of this project was written back in 2002 so I am not too hard on myself. Then in 2006 I decided to give XML::Twig a go and rewrote it.

To be honest I got it up and running at the start of 2011 and have left running ever since. I just wanted to see if it could sit there and run for about a year without me going anywhere near it. It did :) I really have no use for it and was thinking of shutting it down after I hit the year mark. However I recently started getting into Rails and other 'hipster' type languages. My problem though is I need something solid to work on - something to get my teeth into - a real life problem. I've never been good at the 'hello world' type development.

So after over a year of the machine running I have the following data set to get my teeth into..

mysql> select count(*) from programme; select count(*) from broadcasts; select count(*) from star; select count(*) from director;
+----------+
| count(*) |
+----------+
| 66203 |
+----------+
1 row in set (0.00 sec)

+----------+
| count(*) |
+----------+
| 586307 |
+----------+
1 row in set (0.00 sec)

+----------+
| count(*) |
+----------+
| 71854 |
+----------+
1 row in set (0.00 sec)

+----------+
| count(*) |
+----------+
| 10089 |
+----------+
1 row in set (0.00 sec)

It'll be interesting if nothing else. Obviously there are more tables besides these ones like synopsis, categories, channels etc... I pretty much think the channel portion of the project is dead - but there is bound to be something interesting to do with the rest of the data..

• Programming (3)