Big CSV file import, are there exec() or shell_exec() commands alternatives?

[osc2nuke]

Learned a big lesson yesterday when working with big data files, as all worked so well when testing with just little test data.
Then uploaded a file of +/- 35MB - holds over 100.000 rows - and all became horrible.

But that is something i can figure out - ( by create 2 tables, 1 for categories and one for its children) - the distinct query is not a good choice with so many rows.

But here it comes, importing +100.000 rows takes up over 20 minutes. I try json format and csv, no changes.
Then i use the sqlite3 import via CLI - just to see how much that would change - and was stunned it took only max 3 seconds!

As NativepPHP is for a desktop app, what are the alternatives to import such files with a higher speed?

PS: i am aware sqlite3.exe is standalone and i only used it to test out.
I am also not familiar with the exec() and shell_exec() functions, when i tested example codes i found to run these ( using sqlite3), they kept stuck on the so called dot-commands E.g:

.mode csv
.import <path to csv> <table name>

https://laracasts.com/discuss/channels/laravel/laravel-and-sqlite-dot-commands
And tried:

        // Locate the sqlite nativephp.sqlite db        
        $sqldb = base_path(env('DB_DATABASE'));
        //Make a connection to db
        $db = new \SQLite3($sqldb);
        // Execute the dot command to import the CSV file
        $db->exec(".mode csv\n.import C:/wamp64/www/tvview/storage/tvglist.csv channels");
        // Close the database connection
        $db->close();

I also made several attempts to execute a Seeder, but it appear to not find the seeder class.

$mySeeder = new \Database\Seeds\MySeeder();
$mySeeder->run();

Yesterday was really a stressfull day!

[osc2nuke]

Ok, getting finally some answers about the .dot-commands.
They are only available via the CLI.
[ Via: https://dba.stackexchange.com/a/305205 ]

Still there must be a way to import a CSV file no? ( i want to believe).

[osc2nuke]

Following seems to be fastest in my case, it took 12 minutes to insert 115.688 rows.
Still it inserts 1 by 1.
[ maybe it can be handy for others ]

        // Locate the sqlite nativephp.sqlite db
        $sqldb = "C:/wamp64/www/tvview/database/nativephp.sqlite";
        //Make a connection to db
        $db = new \SQLite3($sqldb);
        // Execute the dot command to import the CSV file
        $sql = file_get_contents("C:/wamp64/www/tvview/storage/app/backup.sql");
        $db->exec($sql);

[osc2nuke]

Finally solved the big CSV IMPORT and took just less then 2 seconds for over 115.000 rows!!!
And i have even 2 solutions for WIN only for now.
First follow the steps in this stackoverflow answer to create the .sql file and have your .csv available:
https://stackoverflow.com/a/36001304/277632

OPTION 1 (requires sqlite3 already installed on the client machine)

        exec("sqlite3 C:/wamp64/www/tvview/database/nativephp.sqlite < C:/wamp64/www/tvview/storage/app/import.sql");

OPTION 2 (Add the sqlite3.exe to your project build and store it somewhere suitable)

        $db = "C:/wamp64/www/tvview/database/nativephp.sqlite";
        $sql = "C:/wamp64/www/tvview/storage/app/import.sql";
        exec("C:/wamp64/www/tvview/database/sqlite3.exe ".$db."<".$sql);

What i have not figured out yet is if shell_exec or exec can do:
For Linux:
exec(sudo apt install sqlite3)
For Mac os:
exec(brew install sqlite)

Found the install procedure via:
https://www.linkedin.com/pulse/part-5-how-install-sqlite-your-machine-windows-linux-mac-julles/