simonw/csvs-to-sqlite
View on GitHub ↗ ★ 940 Python
Convert CSV files into a SQLite database
8 mentions on Hacker News by 3 people: 0 stories, 8 comments · first 2017-11-14 · latest 2021-07-18
20082026
-
The datasette author offers this tool for conversion: https://github.com/simonw/csvs-to-sqlite
comment by hprotagonist · 2021-07-18 · in Show HN: Work with CSV files using SQL. For data scientists and engineers -
…Bash hacks) for bulk CSV import, but it's really hard to beat the convenience of csvs-to-sqlite: https://github.com/simonw/csvs-to-sqlite
comment by danso · 2020-12-12 · in Datasette: An open source multi-tool for exploring and publishing data -
…https://github.com/Tinche/cattrs Want to transform csv into sqlite? https://github.com/simonw/csvs-to-sqlite Want to serve sqlite as a REST api? https://datasette.readthedocs.io/en/stable/ Want to stuff simple things into a da
comment by hprotagonist · 2020-01-13 · in Ask HN: What tools do you use for data munging and merging? -
…it and do all kinds of other useful SQL things on top of it. Tools I've written so far include: https://github.com/simonw/csvs-to-sqlite - convert CSV files to a SQLite database https://sqlite-utils.readthedocs.io/en/stable/cli.html -…
comment by simonw · 2019-07-16 · in Show HN: OctoSQL – Query and join multiple databases and files, written in Go -
Related, but with a free web interface https://github.com/simonw/datasette , https://github.com/simonw/csvs-to-sqlite
comment by hprotagonist · 2018-11-14 · in Q: Run SQL Directly on CSV Files -
…CSV with SQLite is one of my goals for the combination of https://github.com/simonw/datasette and https://github.com/simonw/csvs-to-sqlite
comment by simonw · 2018-05-04 · in We’re happy with SQLite and not urgently interested in a fancier DBMS (2016) -
…the web UI, it's the publish command: datasette publish now ~/path-to-my/sqlite.db Combined with my https://github.com/simonw/csvs-to-sqlite tool it means you can take a CSV file and turn it into a live-on-the-internet REST SQL API in…
comment by simonw · 2017-11-14 · in Show HN: Datasette – Create and publish an API for SQLite databases -
…I built a separate tool on top of pandas which can mass-convert CSVs to SQLite - https://github.com/simonw/csvs-to-sqlite - so building the database for https://fivethirtyeight.datasettes.com/ is now a one-liner: csvs-to-sqlite ~/fivethirt
comment by simonw · 2017-11-14 · in Show HN: Datasette – Create and publish an API for SQLite databases