LabInstance nodesqlite3!
LabInstance Info
Asynchronous, non-blocking SQLite3 bindings for Node.js.
Supported platforms
The sqlite3 module works with:
Node.js v11.x, v12.x, v13.x and v14.x. Electron v6.0.x, v6.1.x, v7.0.x, v7.1.x, v8.0.x, v8.1.x and v8.2.x
The sqlite3 module provides a rich set of features:
-
Simple API for query execution
-
Parameters binding support
-
Control the query execution flow, supporting both serialized and parallel modes.
-
Comprehensive debugging support
-
Full caching / Blob support
-
SQLite extension support
-
Bundles SQLite as a fallback
See the API documentation: https://github.com/mapbox/node-sqlite3/wiki
Usage Example
var sqlite3 = require('sqlite3').verbose();
var db = new sqlite3.Database(':memory:');
db.serialize(function() {
db.run("CREATE TABLE lorem (info TEXT)");
var stmt = db.prepare("INSERT INTO lorem VALUES (?)");
for (var i = 0; i < 10; i++) {
stmt.run("Ipsum " + i);
}
stmt.finalize();
db.each("SELECT rowid AS id, info FROM lorem", function(err, row) {
console.log(row.id + ": " + row.info);
});
});
db.close();RUN INSTANCE
Swarmlab services can be run in different ways.
-
You can run them through the swarmlab hybrid environment (http://docs.swarmlab.io/SwarmLab-HowTos/swarmlab/docs/swarmlab/docs/hybrid/start-microservices.html)
-
or use them individually at will on the command line of your system