sqlmath 2024.3.25

sqlite for datascience

sqlmath - sqlite for data-science

Status

Branch	master (v2024.3.25)	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.
• pcre2 is under 3-Clause BSD 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-2024.3.25*
py -m pip install --index-url https://test.pypi.org/simple/ sqlmath==2024.3.25
#
twine upload dist/sqlmath-2024.3.25*
pip install sqlmath==2024.3.25

sqlite upgrade

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

curl -L https://www.sqlite.org/2023/sqlite-autoconf-3420000.tar.gz | tar -xz
git grep "3\.39\.4\|3390400"
for FILE in .ci.sh sqlite_rollup.c
do
    sed -i -e "s|\<3\.39\.4\>|3.42.0|g" "$FILE"
    sed -i -e "s|\<3390400\>|3420000|g" "$FILE"
done
git grep "3\.39\.4\|3390400"
shRollupFetch sqlite_rollup.c