|eleith f24f0aebc6||3 years ago|
|.gitignore||3 years ago|
|README.md||3 years ago|
|package.json||3 years ago|
|zippylite.js||3 years ago|
unzip a bunch of csv files and import than into an sqlite database, all from the command line
a zip file containing csv files of data. the names of the csv files will become your tables and the first row of each csv file will be your columns. all column types will be of type TEXT.
chmod 700 zippylite.js ./zippylite.js -f path/to/archive.zip -o database.sqlite
issues and pull requests are welcome
the original intent of this exercise was to produce a sqlite table from caltrain's zipped data for use in my android caltrain app.