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

1. cdn download
2. documentation
3. quickstart example.js
4. extra screenshots
5. package.json
6. changelog of last 50 commits
7. internal build script
8. misc

cdn download

• none

documentation

api doc

• https://kaizhu256.github.io/node-sqlite3-lite/build..beta..travis-ci.com/apidoc.html

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

/*
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

1. https://kaizhu256.github.io/node-sqlite3-lite/build/screenshot.buildCi.browser.%252F.tmp%252Fbuild%252Fapidoc.html.png

2. https://kaizhu256.github.io/node-sqlite3-lite/build/screenshot.buildCi.browser.%252F.tmp%252Fbuild%252Fcoverage.lib.html.png

3. 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 <[email protected]>",
    "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