Created
May 18, 2016 20:21
-
-
Save marklit/33d72b56e91ba83954914ec6e7a9615b to your computer and use it in GitHub Desktop.
Insert compressed CSV data into an SQLite3 table
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
$ (echo -e "PRAGMA synchronous=OFF; PRAGMA count_changes=OFF;\n.mode csv\n.separator ,\n.import /dev/stdin trips"; | |
gunzip -c ~/taxi-data/*.csv.gz) | \ | |
sqlite3 trips.db |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment