CSV to SQLite - Is it better to write records as they are being read

The blog post discusses a Rust program that reads a CSV file and inserts its data into an SQLite database. The author questions whether writing records to the database immediately while reading from the CSV would be more efficient than first storing them in a vector. They seek insights on optimizing the process.