2 comments

[ 2.0 ms ] story [ 15.7 ms ] thread
Thanks for sharing!

If converting SQLite to CSV/parquet is a one-off task for you, you can also import SQLite files (among the other 50+ formats for tabular data) and export to multiple supported formats (CSV and parquet included) using Datagrok (https://datagrok.ai/). Just drag-and-drop the sqlite file, then use the "export" button on top. Everything happens inside the browser (so there is a limit on the max size of the dataset, probably around 1GB).

Disclaimer - I'm one of the developers of Datagrok :)

$ duckdb f.db -c 'COPY table1 TO table1.csv;COPY table1 TO table1.parquet;'