Re:Working with CSV files on shell/terminal
by psanford on Wednesday June 28, 2023 @01:45AM
(#36502737)
Yeah, sqlite has been my preferred method for working with csv files for a long time. I will say that one nice thing about DuckDB over SQLite is that it does a better job inferring column types than SQLite does.
[ Parent
| on HN ]
I do use sqlite too to process csv file, but I either rely on csvkit to generate the schema from the csv or create the table with raw sql before inserting data in the sqlite database.