I've been looking at calling ".import" in SQLite directly as an optimization for...

simonw on July 18, 2021 | parent | context | favorite | on: Show HN: Work with CSV files using SQL. For data s...

I've been looking at calling ".import" in SQLite directly as an optimization for my sqlite-utils tool - I'm seeing a big speed up in comparison to parsing the CSV in Python: https://github.com/simonw/sqlite-utils/issues/297