- sqlmath-npm - bugfix - Fix missing lib_lightgbm pre-built libraries…

… in npm-package. - part3 - ./sqlmath/lib_lightgbm_xxx.

# v2026.4.30

- 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.

# v2026.3.31

- 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.
- sqlmath-ci - Update file .github/workflows/ci.yml with extra matrix.os macos-15-intel.
- 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.

# v2026.3.1

- 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.

# v2026.2.28

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

# v2026.1.31

- demo - Replace sector and subsector charts with subindustry chart.
- chart - Make tooltip more transparent, so datapoints behind it are more visible.
- 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.

# v2025.12.28

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

# v2025.9.30

- 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 - Add function dbExecProfile() to profile sql-queries.
- 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.

# v2025.8.30

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

# v2025.6.28

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