sqlmath

esm
sqlite for data-science
Version 2025.6.28 License MIT
Keywords
data-sciencedatabasenumericalsqlite
INSTALL
Type:
Version:
- Static
- Latest Patch
- Latest Minor
- Latest Major
- 2025.6.28
- 2025.5.31
- 2025.3.31
- 2025.2.28
- 2025.1.31
- 2024.12.25
- 2024.11.24
- 2024.10.23
- 2024.9.30
- 2024.8.30
- 2024.7.28
- 2024.6.25
- 2024.5.26
- 2024.3.25
- 2024.1.21
- 2023.12.20
- 2023.11.22
- 2023.10.25
- 2023.9.25
- 2023.9.19
- 2023.8.20
- 2023.7.21
- 2023.6.26
- 2023.5.25
- 2023.4.22
- 2023.3.21
- 2023.2.26
- 2023.1.29
- 2022.12.31
- 2022.11.20
- 2022.10.20
- 2022.9.20
- 2022.8.20
- 2022.6.30
- 2022.5.20
- 2022.4.28
- 2022.3.5
- 2021.11.20
- 0.0.5
- 0.0.4
- 0.0.2
- 0.0.1
<script type="module"> import sqlmath from 'https://cdn.jsdelivr.net/npm/sqlmath@2025.6.28/+esm' </script>
sqlmath - sqlite for data-science
Status
Branch | master (v2025.6.28) |
beta (Web Demo) |
alpha (Development) |
---|---|---|---|
CI | |||
Coverage | |||
Demo | |||
Artifacts |
Table of Contents
Web Demo
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
Package Listing
Changelog
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.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
)