sqlmath

sqlmath JS library on GitHub sqlmath JS library on npm Download sqlmath JS library

sqlite for data-science

Version 2025.6.28 License MIT
sqlmath has no homepage
sqlmath JS library on GitHub
sqlmath JS library on npm
Download sqlmath JS library
Keywords
data-sciencedatabasenumericalsqlite

sqlmath - sqlite for data-science

Status

Branch master
(v2025.6.28)
beta
(Web Demo)
alpha
(Development)
CI ci ci ci
Coverage coverage coverage coverage
Demo
Artifacts



Table of Contents

  1. Web Demo

  2. Quickstart Build

  3. Quickstart Website

  4. Documentation

  5. Package Listing

  6. Changelog

  7. License

  8. Devops Instruction



Web Demo

screenshot



Quickstart Build



To build sqlmath:

#!/bin/sh

# git clone sqlmath repo
git clone https://github.com/sqlmath/sqlmath --branch=beta --single-branch
cd sqlmath

# build nodejs binary ./_binary_sqlmath_napi8_xxx_x64.node
npm run test2

# build webassembly binary ./sqlmath_wasm.wasm
sh jslint_ci.sh shCiBuildWasm



Quickstart Website



To serve your own sqlmath website:

#!/bin/sh

# cd <sqlmath repo>

# serve website at http://localhost:8080/index.html
PORT=8080 sh jslint_ci.sh shHttpFileServer



Documentation



API Doc

screenshot



Package Listing

screenshot_package_listing.svg



Changelog

screenshot_changelog.svg



License



Devops Instruction



python pypi publish

python -m build
#
twine upload --repository testpypi dist/sqlmath-2025.6.28*
py -m pip install --index-url https://test.pypi.org/simple/ sqlmath==2025.6.28
#
twine upload dist/sqlmath-2025.6.28*
pip install sqlmath==2025.6.28



sqlite upgrade

    (set -e
    #
    # lgbm
    sh jslint_ci.sh shRollupUpgrade "v4.5.0" "v4.6.0" ".ci.sh sqlmath_base.h"
    #
    # sqlite
    sh jslint_ci.sh shRollupUpgrade "3.49.2" "3.50.2" ".ci.sh sqlmath_external_sqlite.c"
    sh jslint_ci.sh shRollupUpgrade "3490200" "3500200" ".ci.sh sqlmath_external_sqlite.c"
    #
    # zlib
    # sh jslint_ci.sh shRollupUpgrade "1.3" "1.3.1" ".ci.sh sqlmath_external_zlib.c"
    #
    # shSqlmathUpdate
    read -p "Press Enter to shSqlmathUpdate:"
    sh jslint_ci.sh shSqlmathUpdate
    )