Contents

CSV Query - Use SQL to query CSV data
=====================================

CSV Query is a command line tool that allows you to run SQL queries on data
stored in CSV files.

For example:

    $ csvq --select "count(*)" --where "name='Jakob'" sample.csv
    count(*)
    --------
           1

[![Build Status](https://secure.travis-ci.org/koppen/csv_query.png?branch=master)](https://travis-ci.org/koppen/csv_query)

Assumptions
-----------

The first row of data is assumed to be headers.

All fields are created as `VARCHAR(255)`, which hopefully works for most cases.

Behind the scenes
-----------------

CSV Query loads the CSV data into an in-memory SQLite database. Thus, the SQL
queries need to be SQLite-flavored where applicable.

Alternative/related projects
----------------------------

* [csvq.py - Python variant that does almost the same thing](http://www.gl1tch.com/~lukewarm/software/csvq/)
* [CSVql - A query language for CSV files](https://github.com/ondrasej/CSVql)

License
-------

Licensed under the MIT License. See LICENSE for details.

Version data entries

4 entries across 4 versions & 1 rubygems

Version	Path
csv_query-1.0.4	README.md
csv_query-1.0.3	README.md
csv_query-1.0.2	README.md
csv_query-1.0.1	README.md