Node js sqlite3

var sqlite3 = require('sqlite3').verbose();
var db = new sqlite3.Database(':memory:');

db.serialize(function() {
  db.run("CREATE TABLE lorem (info TEXT)");

  var stmt = db.prepare("INSERT INTO lorem VALUES (?)");
  for (var i = 0; i < 10; i++) {
      stmt.run("Ipsum " + i);
  }
  stmt.finalize();

  db.each("SELECT rowid AS id, info FROM lorem", function(err, row) {
      console.log(row.id + ": " + row.info);
  });
});

db.close();

Source: npmjs.com

Similar codes

0 vote328 views1 answer
How to fetch first 10 characters of a string in node js
Javascript Node.js
0 vote334 views1 answer
Insert multiple Row in SQL database with NodeJS
Javascript Node.js
1 vote319 views2 answers
How to update node js through terminal
Javascript Node.js
0 vote344 views1 answer
Node scheduler rules
Javascript Node.js
1 vote500 views1 answer
Nodejs redis json count object keys
Javascript Node.js
19 votes342 views2 answers
Node fetch response body
Javascript Node.js
103 votes427 views6 answers
How to install node js in ubuntu
Javascript Node.js
2 votes303 views1 answer
Promise syntax in node js
Javascript Node.js
-1 vote348 views3 answers
Stripe subscription node js
Javascript Node.js
0 vote297 views1 answer
Node js require all function from another file
Javascript Node.js