dalelane

var sqlite3 = require('sqlite3').verbose();
var db = new sqlite3.Database('data/demodb02');

db.serialize(function() {
    db.run("CREATE TABLE IF NOT EXISTS counts (key TEXT, value INTEGER)");
    db.run("INSERT INTO counts (key, value) VALUES (?, ?)", "counter", 0);
});

TravelingTechGuy

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

db.serialize(function() {
	db.get("SELECT name FROM sqlite_master WHERE type='table' AND name='lorem'", function(error, row) {
		if (row !== undefined) {
			console.log("table exists. cleaning existing records");
			db.run("DELETE FROM lorem", function(error) {
				if (error)
					console.log(error);