SQLite

• w3resource
• clover
• using all or run

API

// db.close()
// Closes the db connection so it can be accessed again later.

  db.close((e) => {
    if (e) {
      console.log(e);
    } else {
      console.log('DB Closed');
    }
  });

• db.all
  • use for SELECT
• db.each
• db.run
  • use for DELETE, UPDATE, INSERT