Sha256: 775e8d15d2cbcee15b656439e97fe3fe7a087c91614f626eed7e41fb1240c686

Contents?: true

Size: 916 Bytes

Versions: 1

Compression:

Stored size: 916 Bytes

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(*)" sample.csv
    count(*)
    --------
           1

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

1 entries across 1 versions & 1 rubygems

Version Path
csv_query-0.0.1 README.md