Bulk insert huge data into SQLite using Python

Bulk insert huge data into SQLite using Python

I read this: Importing a CSV file into a sqlite3 database table using Python
and it seems that everyone suggests using line-by-line reading instead of
using bulk .import from SQLite. However, that will make the insertion
really slow if you have millions of rows of data. Is there any other way
to circumvent this?