augmentable-cli
CLI for working with CSV files by importing into SQLite
Last updated 2 years ago by patrickdevivo .
MIT · Original npm · Tarball · package.json
$ cnpm install augmentable-cli -g
SYNC missed versions from official npm registry.

augmentable-cli

Overview

Augmentable CLI is a small command line utility for working with CSV and similarly structured text-based data files. It relies heavily on SQLite, and provides two primary utilities: importing data files into SQLite tables, and subsequent querying of those tables. It tries not to reinvent the wheel, and is designed to be comfortable to use and easy to integrate with scripts and other applications.

Importing Data

CSVs are everywhere, but unfortunately are not always pleasant to query. Spreadsheets are easy to use, but can be clumsy and sometimes limiting. Custom scripts and python notebooks are versatile, but may be overkill for certain applications.

Augmentable is a set of tools designed to ease some of the pain involved in asking basic questions of text-based data. You can create a project, which is simply a SQLite database file in a special directory on your machine: ~/.augmentable. You can then run an import process, specifying a CSV (or CSV-like) file and some parameters (delimiter, header row, etc) which will copy that file into a new or existing SQLite table.

  • augmentable projects:create myNewProject
  • augmentable file:import /path/to/my/file.csv myNewProject myNewTable --header 0 -- delimiter ;
  • augmentable sql:exec mynewProject 'SELECT * FROM myNewTable'

Current Tags

  • 0.1.0                                ...           latest (2 years ago)

1 Versions

  • 0.1.0                                ...           2 years ago
Maintainers (1)
Downloads
Today 0
This Week 0
This Month 0
Last Day 0
Last Week 1
Last Month 2
Dependencies (10)
Dev Dependencies (0)
None
Dependents (0)
None

Copyright 2014 - 2016 © taobao.org |