Regarding: ... many basic math functions are NOT supported. (sqrt,mod,power,stdev,etc.)...I am curious why these are not available ...now reading how to build my own extensions...
I'm not addressing the documentation question, but extended math functions have been available since 2010. On the *contributors* page, https://www.sqlite.org/contrib Liam Healy contributed a runtime-loadable extension. Windows users can even find pre-compiled versions at: https://github.com/sqlitebrowser/sqlitebrowser/files/1559077/extension-functions.zip extension-functions.c <https://www.sqlite.org/contrib/download/extension-functions.c?get=25> (50.96 KB) contributed by Liam Healy on 2010-02-06 15:45:07 Provide mathematical and string extension functions for SQL queries using the loadable extensions mechanism. Math: acos, asin, atan, atn2, atan2, acosh, asinh, atanh, difference, degrees, radians, cos, sin, tan, cot, cosh, sinh, tanh, coth, exp, log, log10, power, sign, sqrt, square, ceil, floor, pi. String: replicate, charindex, leftstr, rightstr, ltrim, rtrim, trim, replace, reverse, proper, padl, padr, padc, strfilter. Aggregate: stdev, variance, mode, median, lower_quartile, upper_quartile. > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
