var Database = require('better-sqlite3');
var db = new Database('foobar.db');

db.exec('CREATE TABLE IF NOT EXISTS "users" ("id" INTEGER PRIMARY KEY ASC AUTOINCREMENT, "name" TEXT, "password" TEXT);');

// Insert
db.prepare('INSERT INTO users (name, password) VALUES (?, ?)')
    .run('Joni', '123');

var row = db.prepare('SELECT * FROM users WHERE id=?').get(1);

console.log(row.id, row.name, row.password);