microservice-nodesqlite3

2.6 KiB

Raw Permalink Blame History

Swarmlab is a collection of services that aims to

provide teachers and professors with online remote tools to do their lessons

give students the opportunity to study real life examples in their chosen area of expertise

allow developers to fully test and debug their applications and provide POC’s

or you simply want to use a Application (in a microservices-based architecture)

Swarmlab provides you with all the required tools, tools to teach work or try out demos in a completely virtual environment.

More info: http://docs.swarmlab.io/SwarmLab-HowTos/swarmlab/docs/swarmlab/docs/index.html

LabInstance node-sqlite3

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();

Quickstart

This is a quickstart guide of howto use this

Default Configuration

Working Directory

/usr/local/node-sqlite3/node-sqlite3

Default user

docker

Default password

docker

Default password4root

pass

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

CLI

git clone ...

cd [DIRECTORY]

help

make help

create service

make create

start service

make start

stop service

make stop

list service

make list

clean service

make clean

2.6 KiB Raw Permalink Blame History