Yesterday at work there was a call for a hero. There was a lot of unformatted, unordered data that needed parts of it stripped out and neatly arranged into the form of XML insert statements for a production system. Time was short.

When I was faced with this challenge I set to work using programming patterns I initially learned while working on this very journal. The year was 2006, a hard drive crash in a data-centre in Texas had taken with it five weeks of important journal entries. With no local backups the only method I had to resurrect them was to write a script that would churn through Google’s cache of the entries, rip the important HTML parts out, and then filter all the data into neat SQL insert statements.

I remember running that script on my journal. I’d tested it first, so I was confident it would work, but watching it run and re-create two dozen entries in the blink of an eye was a proud moment for me. I felt the same way yesterday as I watched six-hundred-thousand records zooming into a production data repository at the same sort of speed. I didn’t mention to anyone that my experience in doing this kind of thing came solely from bradism.coming using 0.00004% of the volume of data.
Now I know I'm ready though, ready for enterprise journalling.


Add Comment
Toggle Comments Form
Next Entry: Coastal Walk

On a nice sunny day Sunday we decided to wake up at 6am and walk 28kms over cliffs and beaches and through bushland. At 7:30am we left Otford station, at the southern end of Royal National Park and started our trek to Bundeena.

Promoted: The Greatest Rapper in the world Christmas Special

This is the story of a Lego lighthouse keeper who loves his wife, and wanted to write the world's best Christmas Rap album.

Promoted: Five Lessons from Speculate 18

Too much for me summarise in a review. Instead, I thought I'd share a single takeaway and challenge from each of the sessions.

Previous Entry: Flower Powers

After a long day at work today I came home to find my wife had bought me a new box of Weet Bix.

Enjoy what you've read? Want to receive updates and publishing news in your inbox? Sign up to the bradism mailing list. You'll also receive an ebook, free!