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

sqlite upgrade

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

curl -L https://www.sqlite.org/2023/sqlite-autoconf-3440200.tar.gz | tar -xz
mv sqlite-autoconf-3440200 .sqlite-autoconf-3440200
git grep "3\.42\.0\|3420000"
for FILE in .ci.sh sqlmath_external_sqlite.c sqlmath_external_zlib.c
do
    sed -i -e "s|\<3\.42\.0\>|3.44.2|g" "$FILE"
    sed -i -e "s|\<3420000\>|3440200|g" "$FILE"
done
git grep "3\.42\.0\|3420000"
shRollupFetch sqlmath_external_sqlite.c
shRollupFetch sqlmath_external_zlib.c
sh jslint_ci.sh shSqlmathUpdate