Hacker News new | past | comments | ask | show | jobs | submit login

The datasette author offers this tool for conversion: https://github.com/simonw/csvs-to-sqlite

Also 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.

The tools in these replies also offer similar functionality (in terms of running sql queries against csv data) https://news.ycombinator.com/item?id=27763129

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact