2020.8.19 • Published 4 years ago
sqlite3-lite v2020.8.19
sqlite3-lite
this zero-dependency package will provide pre-built version of node-sqlite3 (v5.0.0)
live web demo
- none
git-branch : | master | beta | alpha |
---|---|---|---|
test-report : | |||
coverage : | |||
build-artifacts : |
table of contents
- cdn download
- documentation
- quickstart example.js
- extra screenshots
- package.json
- changelog of last 50 commits
- internal build script
- misc
cdn download
- none
documentation
api doc
cli help
changelog 2020.8.19
- include trace
- update build
- none
todo
- none
quickstart example.js
to run this example, follow instruction in script below
/*
example.js
this script will run node-demo of sqlite3-lite
instruction
1. save this script as example.js
2. run shell-command:
$ npm install sqlite3-lite && \
PORT=8081 node example.js
3. edit this script to suit your needs
*/
/* istanbul instrument in package sqlite3 */
/* jslint utility2:true */
/* istanbul ignore next */
// run shared js-env code - init-local
(function () {
"use strict";
let db;
let sqlite3;
sqlite3 = (
globalThis.utility2_rollup
|| globalThis.utility2_jslint
|| require("sqlite3-lite")
);
db = new sqlite3.Database(":memory:");
db.serialize(function () {
let ii;
let stmt;
db.run("CREATE TABLE lorem (info TEXT)");
stmt = db.prepare("INSERT INTO lorem VALUES (?)");
ii = 0;
while (ii < 10) {
stmt.run("Ipsum " + ii);
ii += 1;
}
stmt.finalize();
db.each("SELECT rowid AS id, info FROM lorem", function (err, row) {
if (err) {
throw err;
}
console.log(row.id + ": " + row.info);
});
});
db.close();
}());
output from shell
extra screenshots
https://kaizhu256.github.io/node-sqlite3-lite/build/screenshot.buildCi.browser.%252F.tmp%252Fbuild%252Fapidoc.html.png
https://kaizhu256.github.io/node-sqlite3-lite/build/screenshot.buildCi.browser.%252F.tmp%252Fbuild%252Fcoverage.lib.html.png
https://kaizhu256.github.io/node-sqlite3-lite/build/screenshot.buildCi.browser.%252F.tmp%252Fbuild%252Ftest-report.html.png
package.json
{
"!!jslint_utility2": true,
"author": "kai zhu <kaizhu256@gmail.com>",
"description": "this zero-dependency package will provide pre-built version of node-sqlite3 (v5.0.0)",
"devDependencies": {
"utility2": "kaizhu256/node-utility2#alpha"
},
"engines": {
"node": ">=12.0"
},
"fileCount": 8,
"homepage": "https://github.com/kaizhu256/node-sqlite3-lite",
"keywords": [
"sql",
"sqlite",
"sqlite3",
"database"
],
"license": "MIT",
"main": "lib.sqlite3.js",
"name": "sqlite3-lite",
"nameAliasPublish": "",
"nameLib": "sqlite3",
"nameOriginal": "sqlite3-lite",
"repository": {
"type": "git",
"url": "https://github.com/kaizhu256/node-sqlite3-lite.git"
},
"scripts": {
"build-ci": "./npm_scripts.sh",
"env": "env",
"eval": "./npm_scripts.sh",
"heroku-postbuild": "./npm_scripts.sh",
"postinstall": "./npm_scripts.sh",
"start": "./npm_scripts.sh",
"test": "./npm_scripts.sh",
"utility2": "./npm_scripts.sh"
},
"version": "2020.8.19"
}
changelog of last 50 commits
internal build script
- build_ci.sh
# build_ci.sh
# this shell script will run build-ci for this package
shBuildCiAfter () {(set -e
shDeployCustom
# shDeployGithub
# shDeployHeroku
shReadmeTest example.sh
)}
shBuildCiBefore () {(set -e
shNpmTestPublished
shReadmeTest example.js
)}
# run shBuildCi
eval "$(utility2 source)"
shBuildCi
misc
- this package was created with utility2