On Mon, Nov 21, 2016 at 1:12 PM, Ronald Gombach <[email protected]> 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
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
