Re: [sqlite] SQLite binary with Math Functions for OS-X?

[David Goldwich]

On Mon, Nov 21, 2016 at 1:12 PM, Ronald Gombach  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

Re: [sqlite] Mac OS Sierra deprecation in bindings

[David Goldwich]

On Sat, Oct 1, 2016 at 4:41 PM, Simon Slavin  wrote:
> According to a 2012 post from DRH, try this compilation option:
>
> -DSQLITE_WITHOUT_ZONEMALLOC

Another, probably better way would be -DOSATOMIC_USE_INLINED=1. That
will transparently substitute legacy atomic op interfaces with their
 counterparts if targeting macOS 10.12+ or iOS 10.0+
(cmp. ).

It might be a good idea if SQLite itself defined this before including
.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users