On Mon, Nov 21, 2016 at 1:12 PM, Ronald Gombach <ron...@gombach.com> wrote: > > Is there a pre-c binary of SQLIte available for down load that includes a > math library. I particularly need the “median” function. > > If not, can someone point me to instructions on compilation command line to > include the math library (OS-X).
Homebrew can do that conveniently: $ brew update && brew install --with-functions sqlite $ /usr/local/opt/sqlite/bin/sqlite3 sqlite> select load_extension('/usr/local/opt/sqlite/lib/libsqlitefunctions.dylib’); sqlite> select pi(); pi() 3.14159265358979 The “math library” here being extension-functions.c from https://www.sqlite.org/contrib/. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users