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
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.