sqlmath - sqlite for data-science

Status

| Branch | master(v2025.3.31) | beta(Web Demo) | alpha(Development) | |--:|:--:|:--:|:--:| | CI | | | | | Coverage | | | | | Demo | | | | | Artifacts | | | |

Table of Contents

1. Web Demo

2. Quickstart Build

   • To build sqlmath:

3. Quickstart Website

   • To serve your own sqlmath website:

4. Documentation

   • API Doc

5. Package Listing

6. Changelog

7. License

8. 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.3.31*
py -m pip install --index-url https://test.pypi.org/simple/ sqlmath==2025.3.31
#
twine upload dist/sqlmath-2025.3.31*
pip install sqlmath==2025.3.31

sqlite upgrade

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

    (set -e
    #
    # lgbm
    sh jslint_ci.sh shRollupUpgrade "v4.4.0" "v4.5.0" ".ci.sh sqlmath_base.h"
    #
    # sqlite
    sh jslint_ci.sh shRollupUpgrade "3.47.2" "3.49.1" ".ci.sh sqlmath_external_sqlite.c"
    sh jslint_ci.sh shRollupUpgrade "3470200" "3490100" ".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
    )