Tags: sqlmath/sqlmath

# v2026.8.31

- jslint-ci - Update ci-shell-function shGitLsTree() to include sha256 hash of files.
- sqlmath - Cleanup c-function winSinefitSnr().
- sqlmath - Update sql-function WIN_SINEFIT2() argument modeSnr with bitmask, allowing selective sine-fit of each column, to avoid wasting cpu on columns that don't need it.
- lgbm - Upgrade to lightgbm-v4.7.0.
- sqlite - Upgrade to sqlite-v3.51.3.
- sqlmath - Remove obsolete sql-functions MEDIAN2(), QUANTILE(), superseded by sqlite-builtins.
- sqlmath - Fix c-header conflict between dlfcn.h and Python.h.

# v2026.7.30

- jslint-ecma - Add ES2015-feature for..of.
- jslint - Change scope from scope_function to scope_block:
    - const-declaration
    - let-declaration
    - function-declaration
- jslint - Expand built-in-globals for browser, ecma, and node - auto-generated from online-sources.
- jslint-ci - Add automated ci for shellcheck to lint shell-scripts.
- jslint-regression - Cleanup indent for multiline-method-chaining.
- jslint-regression - Fix long-running regression where 'let x = x;' doesn't warn about temporal-dead-zone.

# v2026.6.30

- jslint-ecma - Update README.md, documenting supported ES2015+ features.
- jslint-ecma - Unify ES2015-destructure-logic into function prefix_destructure().
- jslint - Wrap all property-updates 'name.init = true/false' with calls to:
    name_lookup() - 'aa=0'
    name_push()   - 'let aa=0'
- cpplint - Upgrade to cpplint@v2.0.2.
- jslint - Add ES2018-syntax for object-literal-spread-operator.
- jslint - Add ES2025-syntax 'import ... with {...}'.

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