(a simple example)
NODE
CREATE TABLE users ( id INTEGER, name TEXT NOT NULL, email TEXT NOT NULL, PRIMARY KEY("id" AUTOINCREMENT) );
Joa Doe,joa@doe.com Job Doe,job@doe.com Joe Doe,joe@doe.com
REQUIRED MODULES npm i sqlite3 csv-parser const sqlite = require("sqlite3"), fs = require("fs"), csv = require("csv-parser");
OPEN DATABASE & CSV FILE const db = new sqlite.Database("users.db"); fs.createReadStream("users.csv") .pipe(csv({ headers : false }))
INSERT ROW BY ROW .on("data", row => { row = Object.values(row); db.run(`INSERT INTO users (name, email) VALUES (?, ?)`, row); })
END .on("end", () => db.close);