Q – Run SQL Directly on CSV or TSV Files
github.com
Q – Run SQL Directly on CSV or TSV Files
1–10 of 10 posts
Re: Q – Run SQL Directly on CSV or TSV Files
#2is this deliberately named to confuse people with the kdb q language?
Re: Q – Run SQL Directly on CSV or TSV Files
#3is this deliberately named to confuse people with the kdb q language? http://code.kx.com/wiki/JB:QforMortals2/contents
I doubt it was deliberate. Q isn't exactly a well-known language outside of the financial sector.
Re: Q – Run SQL Directly on CSV or TSV Files
#4[deleted]
Re: Q – Run SQL Directly on CSV or TSV Files
#5On windows, Logparser 2.2 is a fast implementation of a similar idea.
Does Q handle typical aggravated CSV symptoms such as commas in speechmark delimited strings, speechmarks in speechmark delimited strings, strings that contain carriage returns, etc?
Re: Q – Run SQL Directly on CSV or TSV Files
#6is this deliberately named to confuse people with the kdb q language? http://code.kx.com/wiki/JB:QforMortals2/contents
From the q file on github:
# Name : q (With respect to The Q Continuum)
Re: Q – Run SQL Directly on CSV or TSV Files
#7If you want to just drop CSV files into MySQL, go for it with using the CSV file backing:
http://dev.mysql.com/doc/refman/5.0/en/csv-storage-engine.ht...
As the comments say, create the table with a CSV storage backing and then delete the file and symlink any file to the same location. You are now querying your quicken export or your excel file.
Re: Q – Run SQL Directly on CSV or TSV Files
#8On Windoze, ADO lets you use SQL directly on any data source for many years now, including CSV, TSV, Exchange Microsoft, and many more.
Here's a sample how this can be done: http://fdik.org/ado.zip
Such database middleware is missing on many other platforms. Could be an option to think about it.
Re: Q – Run SQL Directly on CSV or TSV Files
#9On Windoze, ADO lets you use SQL directly on any data source for many years now, including CSV, TSV, Exchange Microsoft, and many more. Here's a sample how this can be done: http://fdik.org/ado.zip Such database middleware is missing on many other platforms. Could be an option to think about it.
Postgres can do it. https://wiki.postgresql.org/wiki/Foreign_data_wrappers
Re: Q – Run SQL Directly on CSV or TSV Files
#10csvtools have had a tool to do this for a while. Not directly though, it goes through sqlite.