• sqlmath-npm - bugfix - Fix missing lib_lightgbm pre-built libraries in npm-package. - part3 - ./sqlmath/lib_lightgbm_xxx.
• sqlmath-npm - bugfix - Fix missing lib_lightgbm pre-built libraries in npm-package. - part2 - git checkout origin/artifact branch-beta/

Full Changelog: v2026.4.30...v2026.4.31

• sqlmath-python - Add context manager and Pythonic API (execute, close) to SqlmathDb matching sqlite3 conventions.
• sqlmath-python - Add repr and bool methods to SqlmathDb for better debugging experience.
• sqlmath - Remove under-used custom-files sqlmath_custom.c, sqlmath_custom.mjs.
• github-ci - Pin various github-runner-os to stable/lts version.
• sqlmath-demo - Change historical charts from 5-years to 3-years.
• sqlmath-npm - bugfix - Fix missing lib_lightgbm pre-built libraries in npm-package.
• sqlmath-doc - Rewrite README with examples, API reference, use cases.

What's Changed

• docs: rewrite README with examples, API reference, use cases by @ababber in #1
• feat(python): add repr and bool to SqlmathDb by @ababber in #6
• feat(python): add Pythonic API to SqlmathDb by @ababber in #8

Full Changelog: v2026.3.31...v2026.4.30

• sqlmath-ci - Update file .github/workflows/ci.yml with extra matrix.os macos-15-intel.
• ci - Speed-up windows-ci by replacing windows-latest with windows-2022.
• sqlmath-ci - Speed-up ci with env-var npm_config_mode_test_nopython, allowing shell-function shCiTestNodejs() to be run in background, parallel to python -m cibuildwheel.
• sqlmath-ci - Rename pre-built-binaries lib_lightgbm.xxx, libomp.xxx to lib_lightgbm_platform_arch.xxx, libomp_platform_arch.xxx, to prevent name-collision under darwin_arm64 and darwin_x64 builds.
• sqlmath-ci - Update file setup.py to open text-files with utf-8 encoding.
• jslint-ci - Update shell-function shGitPullrequestCleanup() to allow squash-and-merge pull-request.
• sqlmath-ci - Update file .github/workflows/ci.yml with hook to run on pull-request.
• ml - Rename intraday-ml-features a_ml_train_i.xxx to a_ml_train_i.xxi.
• betadog - Replace sql-function QUANTILE() with builtin PERCENTILE_CONT().
• sqlmath-python - bugfix - Fix 762-character-limit SQL-string-bug in python-function db_exec().
• jslint-ci - Update shell-function shLintPython().
• python - Auto-detect-and-load lib_lightgbm.dll.
• sqlite - Add sqlite-extension csv.c, tsv.c.

What's Changed

• • ci - Update file .github/workflows/ci.yml with hook to run on pull-request. by @kaizhu256 in #4
• fix: Windows UTF-8 sdist + Darwin libomp / lightgbm CI paths by @ababber in #3

New Contributors

• @kaizhu256 made their first contribution in #4
• @ababber made their first contribution in #3

Full Changelog: v2026.3.1...v2026.3.31

• sqlite - Add sqlite-extension csv.c, tsv.c.
• sqlmath-python - bugfix - Fix 762-character-limit SQL-string-bug in python-function db_exec().
• jslint-ci - Update shell-function shLintPython().
• python - Auto-detect-and-load lib_lightgbm.dll.

Full Changelog: v2026.2.28...v2026.3.1

• python-ci - Fix ruff lint-errors.
• jslint-ci - Update shell-function shCiBase() to check npm-version-support, before running npm-pkg-fix.

Full Changelog: v2026.1.31...v2026.2.28

• chart - Make tooltip more transparent, so datapoints behind it are more visible.
• demo - Replace sector and subsector charts with subindustry chart.
• chart - Cleanup chart _15_tradebot_tech_intra_1_month.
• chart - Add intraday-technical-indicator tradebot_tech_intra.spy_zcl.
• chart - Change time-scale of 1-month charts from 1-day to 15-minute/5-minute.

Full Changelog: v2025.12.28...v2026.1.31

• sqlmath - Update function dbOpenAsync() with default-prm timeoutBusy=5000.
• jslint - Upgrade to jslint-v2025.12.28.
• ci - Upgrade nodejs used in ci to v24.

Full Changelog: v2025.9.30...v2025.12.28

• sqlmath - Add function dbExecProfile() to profile sql-queries.
• sqlmath - Update function dbExecProfile() with additional-arg sqlLength.
• sqlmath - Update function dbOpenAsync() with default-filename :memory:.
• coverage - Add coverage-directives '/coverage-disable/', '/coverage-enable/'. '//coverage-ignore-line'.
• sqlmath - Update function dbCallAsync() to include db.filename in error-message.
• sqlmath - Replace miniz-library with native-zib-library.
• sqlmath - ugly-hack - win32-sqlite-shell doesn't like nodejs-builtin-zlib, so link with external-zlib.
• sqlmath - Replace sql-functions ZLIB_COMPRESS() to GZIP_COMPRESS(), ZLIB_UNCOMPRESS() to GZIP_UNCOMPRESS().
• sqlmath - Prefer platform-native zlib over sqlmath_external_sqlite.c.
• sqlmath - bugfix - Fix sql-functions ZLIB_COMPRESS(), ZLIB_UNCOMPRESS() crashing sqlite-shell-executable.
• ml - Update sql-function LGBM_TRAINFROMTABLE() to use C_API_FEATURE_IMPORTANCE_GAIN instead of C_API_FEATURE_IMPORTANCE_SPLIT.
• sqlmath - Update function win_sinefit() to rename outputs from/to xx0/xxa, xx1/xxb, yy0/yya, yy1/yyb, rr0/rra, rr1/rrb.
• sqlmath - Update sql-function SINEFIT_REFITLAST() to create copy of wsf-blob, so original argument is not mutated.
• sqlmath - Update function win_sinefit() to allow outputting prm grr, mrr, vrr.

Full Changelog: v2025.8.30...v2025.9.30

• python - Add support for PEP 703 – Making the Global Interpreter Lock Optional in CPython.
• sqlite - Upgrade to sqlite-v3.50.4.

Full Changelog: v2025.6.28...v2025.8.30

• sqlite - Upgrade to sqlite-v3.50.2.
• sqlmath - Update function dbExecAsync() with extra param modeNoop, used in mock-code-coverage.

Full Changelog: v2025.5.31...v2025.6.28