0
1
Rasi
answered Nov 30 '-1 00:00
sqlite 3 is good option to use [b] SQLite [/b ] with Node JS
sqlite 3 give you to option to control execution flow by serialize function
db.serialize will allow to run first and their inner serialize function will start to run
db.serialize(function() {
// Queries scheduled here will be run first
db.serialize(function() {
// Queries scheduled here will still be run second.
});
});
you can fetch each record by each function form SQLite database
db.each("SELECT rowid AS id, info FROM lorem", function(err, row) {
console.log(row.id + ": " + row.info);
});
close the SQLite connection when you done with it
db.close();
1
shyam
answered Nov 30 '-1 00:00
you can connect with memory by using following code
var sqlite3 = require('sqlite3').verbose();
var db = new sqlite3.Database(":memory:");
0
Mitul Dabhi
answered Nov 30 '-1 00:00
download the sqlite3 module for Node JS
npm install sqlite3
Lets connect Node to MySQL
sqlite3 module provide good set of library to get connection to SQLite
include sqlite3module
var sqlite3 = require('sqlite3')
Database is used to construct the connection
var db = new sqlite3.Database(file);
where file is var file="D:/software/sqllite/example.sqlite";
it can be any SQLite file with accessible path
all function return result set for SQLite
db.all("SELECT id, name FROM employee", function(err, employee){
if(err !== null){
console.log(err);
}
else{
console.log(employee);
}
});
it give all employee list in array format
lets use dynamic value
var id ='12\n1';
db.all("SELECT id, name FROM employee where id=?",(id), function(err, employee){
if(err !== null){
console.log(err);
}
else{
console.log(employee);
}
});
lets use the prepare statement
//delete query with prepare statement
var statement = db.prepare("DELETE FROM employee WHERE id = ?", (id));
statement.run();
statement.finalize();
Github