data.vic.gov.au launched
March 3rd, 2010
No comments
Victoria is the latest state to jump on the open data bandwagon following the Australian government and NSW. So how does it stack up?
Read more…
Categories: Web Stuff
Pentaho in the Cloud
February 9th, 2010
No comments
This is a step by step guide to setting up Pentaho on Amazon EC2.
If you haven’t already done so, you’ll need to sign up with EC2.
Once you’ve signed up, log in to the AWS Management Console and launch a new instance. I usually create a spot request because I just want a sandpit and it can be significantly cheaper (but don’t tell anyone or it will get more expensive). A small instance is fine here. Choose the most basic Fedora package (as of writing “Basic Fedora Core 8″, ami-84db39ed). We’ll install everything else ourselves.
Querying XML in Oracle (using EXTRACTVALUE)
February 1st, 2010
No comments
It had to happen sooner or later, today I had to query an XML type column in Oracle. It’s a lot easier than I thought it would be – but only because I wanted to return a singular attribute.
This is how I did it using Toad: