News for hackers. Stuff that matters.
Re:CSVfix is a tool for manipulating CSV data by eli on Tuesday November 12, 2013 @11:58PM (#6723439)
The first python script I wrote is a fairly ugly hack that converts CSV to a SQLITE-compatible SQL so you can query it. https://github.com/elidickinson/csv-tools/blob/master/csv2sq...
Re:CSVfix is a tool for manipulating CSV data by stevekemp on Wednesday November 13, 2013 @05:35AM (#6724351)
I once wrote a tool to insert Apache logfiles into a SQLite database to run queries against.

I'm frequently surprised by how popular that project remains:

  * http://steve.org.uk/Software/asql
Re:CSVfix is a tool for manipulating CSV data by eli on Wednesday November 13, 2013 @09:09AM (#6725199)
That reminds me, there's actually a funky old Microsoft skunkworks project that lets you query CSVs and Apache logfiles and all sorts of stuff via SQL: http://www.microsoft.com/en-us/download/details.aspx?id=2465 I have no idea if it even still runs on current windows versions.