SQLite Forum

Ask for new feature: a pre-decoder mechanism for 'variables' and 'stdev' ?
Login

Ask for new feature: a pre-decoder mechanism for 'variables' and 'stdev' ?

(1) By stonebig on 2021-08-15 16:23:45 [link]

Would it be an option to have a pre-decoder stage in SQLite, that would reduce the workarounding to manage 'stddev' and 'variables' ?

- standard deviation:
  . "stdev(x)" math function is manually workarounded by replacing it by  "sqrt((sum(x * x) -2* sum(x) * avg(x) + avg(x) * avg(x) * count( * ))/count( * ))"

- "variables": methods like the one describe in Stackoverflow seems also to be a candidate for a pre-decoder https://stackoverflow.com/questions/7739444/declare-variable-in-sqlite-and-use-it/14574227#14574227

Sorry if this suggestion has already been made 42 times.

(2) By Donald Griggs (dfgriggs) on 2021-08-16 18:28:52 in reply to 1

If I'm understanding 'pre-decoder stage' correctly, maybe one of these is relevant:


Sqlite now supports CTEs (WITH clause) which may help you concisely define a function.    [](https://www.sqlite.org/lang_with.html)



For basic statistics functions, note the contribution of extension-functions.c at   [](https://sqlite.org/contrib/)   
   or  
[](https://github.com/nalgeon/sqlean/blob/0.4.0/docs/stats.md)


Should you be using the CLI (command line interface utility program), it does indeed support named parameters.
[](https://www.sqlite.org/cli.html#sql_parameters)