Dirty Little SQL is a SQL notebook for quickly loading CSV, tab-separated, JSON and Microsoft Excel files and running queries on them. You can load a file with millions of rows in it and query it in less than a few seconds. Here's what that looks like in practice:
Uses a modified version of sql.js maintained at https://github.com/mwenge/sql.js
Run the following steps to bundle the separators.js
file:
npm install browserify
npm install json2csv
browserify separators-pre.js > separators.js