News for hackers. Stuff that matters.
Re:Execute SQL against structured text like CSV or TSV by csmithuk on Tuesday February 04, 2014 @06:44AM (#7176817)
Surprisingly, we've been doing this on the Microsoft side of things for years with ADO and csv data sources!

http://msdn.microsoft.com/en-us/library/ms974559.aspx

(article dated 2004)

Re:Execute SQL against structured text like CSV or TSV by dmethvin on Tuesday February 04, 2014 @09:44AM (#7177647)
Even better is LogParser, which lets you do SQL queries against just about any data format you'll find in a file on Windows. It's been around for a decade and continues to be improved.

http://technet.microsoft.com/en-us/scriptcenter/dd919274.asp...

Re:Execute SQL against structured text like CSV or TSV by burmask on Tuesday February 04, 2014 @09:55AM (#7177733)
Microsoft LogParser is not only an established utility, it's extremely fast, too.
Re:Execute SQL against structured text like CSV or TSV by DEinspanjer on Wednesday February 05, 2014 @07:29AM (#7183335)
I remember LogParser from years back. I used to be very involved in that nascent community, and I developed a plugin for it that let you parse an input file using a regex with capture groups so you could use SQL queries on log files that did not have records with simple delimited columns.
Re:Execute SQL against structured text like CSV or TSV by userbinator on Tuesday February 04, 2014 @07:21AM (#7176941)
Even older, the ODBC text driver for Windows 3.1x supported this, 20 years ago: http://support.microsoft.com/kb/146220
Re:Execute SQL against structured text like CSV or TSV by krapp on Tuesday February 04, 2014 @07:57AM (#7177083)
Apropo of absolutely nothing, my advanced C++ final was a basic console CRUD application using ADO. It was a nightmare - fun, and I broke the database (and didn't get points for that) but a nightmare.

I'm so glad C# is a thing now.

Re:Execute SQL against structured text like CSV or TSV by edgarvm on Tuesday February 04, 2014 @11:03AM (#7178246)
For SQL Server OPENDATASOURCE and OPENQUERY can do the trick too
Re:Execute SQL against structured text like CSV or TSV by cafard on Wednesday February 05, 2014 @11:14AM (#7184549)
One can use Oracle "external tables" with delimited files; they are only so flexible, though, and you want to think hard about security.
Re:Execute SQL against structured text like CSV or TSV by mpweiher on Tuesday February 04, 2014 @07:44AM (#7177029)
NeXT DBKit, 1992 or so, had a CSV adapter as well.