yet another opensource offline-browser / wasm sqlite-editor (used internally for stock trading)

[u/kaizhu256]

• completely offline, but feel free to git-clone / host it locally as a quick-and-dirty sqlite table-explorer - https://sqlmath.github.io/sqlmath/index.html
  • import / export / attach - databases
  • import / export - csv, json, tsv
  • export - tables as sql-insert-scripts for mssql / mysql / postgres etc...
• built originally as dev-oriented frontend dashboard for a tradebot
  • includes some custom / esoteric sql-functions for OLS and sine-fitting (look in file sqlmath_base.c)
  • custom datetime functions manipulating 64-bit integers as YYYYMMDDhhmmss
    • string-based YYYY-MM-DD hh:mm:ss timestamps consumes too much space for intraday stock-data I deal w/ ^^;;;
  • node.js variant also has integrated c-bindings to LightGBM to directly train from, and make predictions from sql-tables.