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

Reply via email to