Sqlmath

- lgbm - Replace Microsoft-release-version with PyPi-version of lgbm-binary, because it includes gpu-extension.
- sqlmath - Add sql-function WIN_AVG1(), WIN_AVG2().

- betadog - Re-introduce trading of sp500 stocks.
- lgbm - Make loading of lightgbm-library optional, only loading if file exists.

- sqlmath - Update sql-function LGBM_PREDICTFORTABLE() to allow multiclass.
- lgbm - Upgrade to lightgbm-v4.5.0.
- sqlite - Upgrade to sqlite-v3.46.0.
- sqlmath - Add sql-aggregate-function COLUMNTYPE() and allow exporting sql-table as sql-statement.
- sqlmath - Add sql-functions IDATEFROMTEXT(), IDATETOTEXT().
- python - Upgrade to ruff-v0.5.0.

- sqlmath - Update sql-function LGBM_PREDICTFORTABLE() to allow multiclass.
- jslint - Remove unnecessary shell-function shCurlExe().
- lgbm - Upgrade to lightgbm-v4.4.0.
- jslint - Upgrade to jslint-v2024.6.1-beta.
- lgbm - Include lib_lightgbm.xxx in npm/python package.
- lgbm - Add sqlite-extension for lightgbm.
- lgbm - Add sql-functions:
lgbm_datasetcreatefromfile()
lgbm_datasetcreatefrommat()
lgbm_datasetcreatefromtable()
lgbm_datasetdumptext()
lgbm_datasetfree()
lgbm_datasetgetnumdata()
lgbm_datasetgetnumfeature()
lgbm_datasetsavebinary()
lgbm_dlopen()
lgbm_predictforfile()
lgbm_predictfortable()
lgbm_trainfromdataset()
lgbm_trainfromtable()
- sqlmath - Remove little-used sql-function fill_forward().
- zlib - Update to zlib v1.3.1.
- sqlmath - Add function dbExecAndReturnLastValue().
- sqlmath - Replace functions:
dbExecAndReturnFirstRow() with dbExecAndReturnLastRow()
dbExecAndReturnFirstTable() with dbExecAndReturnLastTable()

- webdemo - Replace market-indices .spx/.ndx/.dji with futures .es/.nq/.ym.
- sqlite - Decouple c-function str99JsonAppendText() from builtin-function jsonAppendString().
- sqlite - Update to sqlite v3.44.2.
- sqlmath - Remove little-used sqlean-regexp-extension and file sqlmath_external_pcre2.c.
- sqlmath - bugfix - Fix off-by-2 root-mean-square-deviation calculation of parameter lee in sql-function win_sinefit2().
- sqlmath - bugfix - Fix null-case handling-behavior for function dbExecAndReturnLastBlobAsync().
- sqlmath - Add functions dbExecAndReturnFirstRow(), dbExecAndReturnFirstTable(), listOrEmptyList().
- jslint - Update jslint to v2024.4.1-beta.
- ci - bugfix - Fix package.json config-regression breaking ci.

- jslint-ci - Add shell-functions shGitPullrequestCleanup(), shGitPullrequest() to automatically cleanup or create-and-push github-pull-commit to origin/alpha.
- ci - Fix tmpdir in shell-function shBrowserScreenshot().
- webdemo - Update tables tradebot_intraday_xxx.
- migration - Rename prm ydate to xdate, ytime to xtime.
- sqlmath - Move function dbTableImportAsync from file sqlmath_browser.mjs to sqlmath.mjs.
- ci - Update github-ci for actions/cache, actions/setup-python from nodejs v16 to nodejs v20.
- ci - Update shell-function shRollupFetch() to fix blank date-committed.