title: A tutorial on SQLite3 for Node.js and a code example explanation wanted
body: <p>I am a bit confused with SQLite at the moment, as this is the first time I'm ever using a database. I got sqlite3 from here: <a href="https://github.com/developmentseed/node-sqlite3">https://github.com/developmentseed/node-sqlite3</a>.</p>
  
  <p>I'm looking at that example there, some things I do understand, while others I do not. Most of those database commands that are wrapped in <code>.run()</code>, <code>.prepare()</code> and the like give me a hard time.</p>
  
  <p>This is the example:</p>
  
  <pre><code>var usersDB = new sqlite3.Database("databases/users.db");
  
    usersDB.serialize(function() {
    usersDB.run("CREATE TABLE lorem (info TEXT)");
  
    var stmt = usersDB.prepare("INSERT INTO lorem VALUES (?)");
    for (var i = 0; i &lt; 10; i++) {
        stmt.run("Ipsum " + i);
    }
    stmt.finalize();
  
    usersDB.each("SELECT rowid AS id, info FROM lorem", function(err, row) {
        console.log(row.id + ": " + row.info);
    });
  });
  
  usersDB.close();
  </code></pre>
  
  <p>Also, how do I store simple things such as usernames, passwords (do I have to hash them myself?) and emails in the SQLite database on Node.js?</p>