News for hackers. Stuff that matters.
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:

  CREATE EXTENSION file_fdw;

  CREATE SERVER my_server FOREIGN DATA WRAPPER file_fdw;

  CREATE FOREIGN TABLE my_csv (
    field_a text,
    field_b smallint,
    ...
  ) SERVER my_server
  OPTIONS ( filename 'some/file/path.csv', format 'csv', header 'true' );

  select * from my_csv;
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.