Re:CSVfix is a tool for manipulating CSV data
by elchief on Tuesday November 12, 2013 @08:57PM
(#6722832)
To quickly examine CSV data in PostgreSQL, you can do this:
[ Parent
| on HN ]
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.