4 ms·
SQLite does a great job of importing CSV, and then you're able to use something like "DB Browser for SQLite"[1] to browse the data. I use something like this t
by gav 7y ago
SQLite does a great job of importing CSV, and then you're able to use something like "DB Browser for SQLite"[1] to browse the data.
I use something like this to fix up column names and import:
sed -i '' -e '1 s/ \/ /_/g; 1 s/[() ]/_/g' $csv_file
sqlite3 $db_file <<SQL
.mode csv
.import $csv_file $table_name
SQL
[1] https://sqlitebrowser.org/ https://sqlitebrowser.org/
- alecdibble 7y agoAmazing, I will definitely try this out. Thank you!