Thursday, May 31, 2007

Web2.0 stupidity of the day: vod:pod

Let me introduce you to vod:podbeta.

Launched in December 2006, vod:pod is a typical silly Rails-based, buzzword-compliant, community-based, mashup website. Basic premise seems to be around users contributing videos they found on other video sharing sites to "pods", which are simply rich tags. There's also functionality to upload videos directly to the site, but there are various limitations on that.

Technically, the website is ok. Going against the grain of Web2.0 philosophies, it is visually busy. There are about a million different action items on each page, all demanding attention with bright colours and contrasting images. Being a Rails site the performance isn't great either.

It does have a few positive things going for it too. It uses AJAX fairly sensibly (that is, almost not at all). Popularity (?) graphs in pod headers are quite cute. Most importantly, cluttered and confusing UI makes it very hard to waste more than about 3 minutes on the site (unless you decide to bitch about it on a blog!).

They claim to be self-funded, and are hiring. Seeing as there are no ads on the site (not that they would generate much revenue, with their visitor numbers) someone is sinking a decent amount of cash into this. And, according to their FAQ, they plan to make money on advertisement and "premium services".

Admirable effort, but no biscuit.

Monday, May 28, 2007

Setting up Mondrian's FoodMart example

So I tried to setup Mondrian's example data mart. It is included in the distribution and referred to by the documentation. It supports various databases, which means it's a Java program, rather than an SQL file. The program creates does all the DDL and then populates it with sample data.



Unfortunately, none of the documentation provides actual working details on how to run that program. After about an hour of screaming at my keyboard, the following command emerged and did the job:



C:\Pentaho\mondrian-2.3.2.8944>java -cp ../workbench-2.3.2.9247/drivers/mysql-connector-java-3.1.14-bin.jar;../workbench-2.3.2.9247/lib/eigenbase-properties.jar;../workbench-2.3.2.9247/lib/eigenbase-resgen.jar;../workbench-2.3.2.9247/lib/eigenbase-xom.jar;lib/mondrian.jar;../workbench-2.3.2.9247/lib/log4j-1.2.12.jar mondrian.test.loader.MondrianFoodMartLoader -tables -data -indexes -jdbcDrivers=com.mysql.jdbc.Driver -inputFile=demo/FoodMartCreateData.sql -outputJdbcURL="jdbc:mysql://dbtest/foodmart?user=user&password=blah"

Java is a lovely system.