npm install sqlite3
sqlite3 mydb.sqlite3
CREATE TABLE user_dt (
data_id INTEGER PRIMARY KEY AUTOINCREMENT,
user_name TEXT,
modified_date DATETIME
);
.quit
test.js
var sqlite3 = require('sqlite3').verbose();
var mydb = new sqlite3.Database('./mydb.sqlite3');
mydb.run("INSERT INTO user_dt (user_name,modified_date) VALUES ('taro yamada', datetime('now', 'localtime') )");
node test.js
http://knexjs.org
https://hiddentao.com/squel/