3 ms·
The datasette author offers this tool for conversion: https://github.com/simonw/csvs-to-sqlite https://github.com/simonw/csvs-to-sqlite
by hprotagonist 5y ago
The datasette author offers this tool for conversion: https://github.com/simonw/csvs-to-sqlite https://github.com/simonw/csvs-to-sqlite
- simonw 5y agoAlso https://sqlite-utils.datasette.io/en/stable/cli.html#inserting-csv-or-tsv-data https://sqlite-utils.datasette.io/en/stable/cli.html#inserti... which comes with a lot of other useful tools for manipulating the scheme, adding indexes and so on after you've imported the data.
- kingosticks 5y agoThe tools in these replies also offer similar functionality (in terms of running sql queries against csv data) https://news.ycombinator.com/item?id=27763129 https://news.ycombinator.com/item?id=27763129