Partially Attended

an irregularly updated blog by Ian Mulvany

Wrangling data from a mysql db

Fri Feb 13, 2009

117 Words
I am working on a project where I have to pass some data from tables in a MySQL DB over to some people who don't use a relational database. The question is, how I can best extract the data in a way that is useable to them?

I've decided to prepare the data for them as XML, as this prevents problems with

My approach uses a hacked together collection of scripts, because, well, as Mark Pilgrim says, because fuck you.

Actually, what I mean is they were just the fastest set of scripts that I could pull together for the task.

It's a mix of perl and python.

1st off, getting the data out of the DB.
This work is licensed under a Creative Commons Attribution 4.0 International License