CSVQL is a React Javascipt application for querying CSV data using SQL. It uses sql.js, a Javascript SQLite port.
NPM is used for package management, and Gulp is used to run common tasks.
To prepare the environment, run npm install.
To spin up the application locally, accessible at http://localhost:3000: npm watch
This will reload the site whenever changes are made to any files.
Tests are written in Jest and can be run with npm test.
# Autoformat
jscs --fix app/scripts/**/*.js
# Lint
gulp lint
gulp build will prepare the project for production. gulp will do the same, but also clean and lint the project.
- Dates and time parsing
- Validations in libraries
- Unit test coverage
- Build files and number of dev dependencies
- Custom delimiters (i.e. not just comma)
- Option to strip padding from CSV columns
- Export query results as CSV