sqlmath

sqlmath - sqlite for data-science

Status

Branch	master (v2025.8.30)	beta (Web Demo)	alpha (Development)
CI
Coverage
Demo
Artifacts

Table of Contents

• Web Demo

• Quickstart Build

  • To build sqlmath:

• Quickstart Website

  • To serve your own sqlmath website:

• Documentation

  • API Doc

• Package Listing

• Changelog

• License

• Devops Instruction

  • python pypi publish
  • sqlite upgrade

Web Demo

• https://sqlmath.github.io/sqlmath/index.html

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

• https://sqlmath.github.io/sqlmath/apidoc.html

Package Listing

Changelog

• Full CHANGELOG.md

License

• sqlite is under public domain.
• jslint is under Unlicense License.
• zlib is under zlib License.
• cpplint.py is under 3-Clause BSD License.
• indent.exe is under GPLv3 License.
• Everything else is under MIT License.

Devops Instruction

python pypi publish

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

sqlite upgrade

• goto https://www.sqlite.org/changes.html

    (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.50.3" "3.50.4" ".ci.sh sqlmath_external_sqlite.c"
    sh jslint_ci.sh shRollupUpgrade "3500300" "3500400" ".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
    )