(a simple example)
NODE
TABLE STRUCTURE CREATE TABLE users ( id INTEGER, name TEXT NOT NULL, email TEXT NOT NULL, PRIMARY KEY("id" AUTOINCREMENT) );
DUMMY USERS INSERT INTO users (name, email) VALUES ("Joa Doe", "joa@doe.com"), ("Job Doe", "job@doe.com"), ("Joe Doe", "joe@doe.com");
LOAD REQUIRED MODULES npm i sqlite3 csv-stringify const sqlite = require("sqlite3"), fs = require("fs"), csv = require("csv-stringify");
EXPORT USERS const db = new sqlite.Database("user.db"); db.all("SELECT * FROM users", (e, rows) => rows.forEach(row => { r = Object.values(row); csv.stringify([r], (e, o) => fs. appendFileSync("demo.csv", o)); })); db.close();