Skip to content

Releases: sqlmath/sqlmath

v2026.7.30 - jslint-ecma - Add ES2015-feature for..of.

Choose a tag to compare

@kaizhu256 kaizhu256 released this 01 Aug 01:35
  • 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.

Full Changelog: v2026.6.30...v2026.7.30

v2026.6.30- jslint-ecma - Unify ES2015-destructure-logic into function prefix_destructure().

Choose a tag to compare

@kaizhu256 kaizhu256 released this 05 Jul 21:02
  • jslint-ecma - Unify ES2015-destructure-logic into function prefix_destructure().
  • jslint-ecma - Update README.md, documenting supported ES2015+ features.
  • 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 {...}'.

Full Changelog: v2026.4.31...v2026.6.30

v2026.4.31 - sqlmath-npm - bugfix - Fix missing lib_lightgbm pre-built libraries in npm-package. - part3 - ./sqlmath/lib_lightgbm_xxx.

Choose a tag to compare

@betadog01 betadog01 released this 02 May 22:40
  • 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

v2026.4.30- sqlmath-python - Add context manager and Pythonic API (execute, close) to SqlmathDb matching sqlite3 conventions.

Choose a tag to compare

@betadog01 betadog01 released this 02 May 18:49
  • 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

v2026.3.31 - sqlmath-ci - Update file .github/workflows/ci.yml with extra matrix.os macos-15-intel.

Choose a tag to compare

@kaizhu256 kaizhu256 released this 03 Apr 04:05
  • 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

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

v2026.3.1 - sqlite - Add sqlite-extension csv.c, tsv.c.

Choose a tag to compare

@kaizhu256 kaizhu256 released this 15 Mar 05:34
  • 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

v2026.2.28 - python-ci - Fix ruff lint-errors.

Choose a tag to compare

@kaizhu256 kaizhu256 released this 15 Mar 04:21
  • 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

v2026.1.31 - chart - Make tooltip more transparent, so datapoints behind it are more visible.

Choose a tag to compare

@kaizhu256 kaizhu256 released this 31 Jan 18:39
  • 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

v2025.12.28 - sqlmath - Update function dbOpenAsync() with default-prm timeoutBusy=5000.

Choose a tag to compare

@kaizhu256 kaizhu256 released this 29 Dec 03:22
  • 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

v2025.9.30 - sqlmath - Add function dbExecProfile() to profile sql-queries.

Choose a tag to compare

@kaizhu256 kaizhu256 released this 01 Oct 22:27
  • 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