[Nottingham] Nottingham Perl Mongers (good/bad idea?)
Duncan John Fyfe
djf at star.le.ac.uk
Mon Feb 16 19:58:48 GMT 2004
On Mon, 16 Feb 2004, Andy Brown wrote:
>
> Lesson 7
> Total insanity, such as using perl to read CSV files and stuff data
> into a Microsoft SQL Server (well, MSDE) database.
>
> (and yes, this probably *is* the best way of doing the data transfer)
>
>
Why is this insane ?
DBD::CSV -> DBD::*
Is a great way of loading data into a database while leaving the data humanly mongable and in a database neutral format.
Especially good for test data and initial data sets.
Have fun,
Duncan
--
Duncan John Fyfe X-ray Astronomy Group,
Dept. of Physics & Astronomy,
Phone +44 116 252 3635 University of Leicester,
E-mail djf at star.le.ac.uk University Road,
Leicester, LE1 7RH, U.K.
More information about the Nottingham
mailing list