A tutorial on SQLite3 for Node.js and a code example explanation wanted
database, javascript, node.js, sqlite
Solution
Maybe you can try node-sqlite from grumdrig. He has a very nice "example-driven" documentation.
Problem
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: https://github.com/developmentseed/node-sqlite3. 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 `.run()`, `.prepare()` and the like give me a hard time. This is the example: ``` 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 < 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(); ``` 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?