login/register

Snip!t from collection of Alan Dix

see all channels for Alan Dix

Snip
summary

q is a command line tool that allows direct execution of... on CSVs/TSVs (and any other tabular text files).
q treats ordinary files as database tables, and supports ...

Run SQL directly on CSV files | Text as Data | q
http://harelba.github.io/q/

Categories

/Channels/techie/database

[ go to category ]

For Snip

loading snip actions ...

For Page

loading url actions ...

q is a command line tool that allows direct execution of SQL-like queries on CSVs/TSVs (and any other tabular text files).

q treats ordinary files as database tables, and supports all SQL constructs, such as WHERE, GROUP BY, JOINs etc. It supports automatic column name and column type detection, and provides full support for multiple encodings.



 




 



    
HTML

     
     

<p>q is a command line tool that allows direct execution of SQL-like queries on CSVs/TSVs (and any other tabular text files).</p>

<p>q treats ordinary files as database tables, and supports all SQL constructs, such as WHERE, GROUP BY, JOINs etc. It supports automatic column name and column type detection, and provides full support for multiple encodings.</p>

<pre class="main_example_wrapper"></pre>



 


 


 













 	
      
  
Search Alan Dix Snips

  

  

	    

  

  



       
Channels - Alan Dix