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

[Ronald Gombach]

Keith … THANKS.

I should have caught that — these senior citizen eyes ain’t what they used to 
be.


> On Nov 23, 2016, at 8:24 AM, Keith Medcalf <kmedc...@dessus.com> wrote:
> 
> 
> If what appears is what was entered, then you need to change the closing ’ to 
> a closing ' (that is, from a funny word-processor symbol that looks like a 
> quote but is really an apostrophe used in typesetting but is not a quote that 
> terminates a string, into a quote to terminate the string) ...
> 
> sqlite> select 
> load_extension('/usr/local/opt/sqlite/lib/libsqlitefunctions.dylib’);
> sqlite> select 
> load_extension('/usr/local/opt/sqlite/lib/libsqlitefunctions.dylib');
> 
> You have to be careful because most modern e-mail clients, unless 
> specifically configured otherwise, are designed specifically for sending 
> web-pages containing glossy-brochures by SMTP and are not suitable for use in 
> exchanging plain-text that must not be tampered with.  In this case the 
> culprit was likely a configuration option that substituted "pretty quotes" 
> and "apostrophes" for functional quotes.  You can tell because the 
> pretty-quotes are, well, pretty and curvy, such as are around your original 
> “median”, while actual quotes that-do-something (other than look pretty) do 
> not have curves:  "median".  The same mis-feature also changes single-quotes 
> ' into apostrophes ’ in the circumstances it thinks such changes are 
> appropriate depending on its substitution rules.
> 
>> -Original Message-
>> From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org 
>> <mailto:sqlite-users-boun...@mailinglists.sqlite.org>]
>> On Behalf Of Ronald Gombach
>> Sent: Wednesday, 23 November, 2016 04:57
>> To: SQLite mailing list
>> Subject: Re: [sqlite] SQLite binary with Math Functions for OS-X?
>> 
>> David,
>> 
>> The brew/install worked and created the sqlite app and library in the
>> locations specified in your instructions.
>> 
>> I can load the math lib from the .load (dot load) command line,
>> The median function works as I wanted
>> 
>> but the ‘load_extension’ select statement did not work; I get a command
>> entry continuation line as follows
>> 
>> sqlite> select
>> load_extension('/usr/local/opt/sqlite/lib/libsqlitefunctions.dylib’);
>>   …>
>> 
>> I need to be able to load the extension from within a PHP script
>> 
>> Thoughts?
>> 
>> Thanks.
>> 
>> Ron Gombach
>> mailto:ron...@gombach.com <mailto:ron...@gombach.com> 
>> <mailto:ron...@gombach.com <mailto:ron...@gombach.com>>
>> 
>> 
>>> On Nov 21, 2016, at 12:15 PM, David Goldwich
>> <david.goldwich+sql...@gmail.com> wrote:
>>> 
>>> 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
>> 
>> ___
>> sqlite-users mailing list
>> sqlite-users@mailinglists.sqlite.org 
>> <mailto:sqlite-users@mailinglists.sqlite.org>
>> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users 
>> <http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users>
> 
> 
> 
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org 
> <mailto:sqlite-users@mailinglists.sqlite.org>
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users 
> <http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

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

[Keith Medcalf]

If what appears is what was entered, then you need to change the closing ’ to a 
closing ' (that is, from a funny word-processor symbol that looks like a quote 
but is really an apostrophe used in typesetting but is not a quote that 
terminates a string, into a quote to terminate the string) ...

sqlite> select 
load_extension('/usr/local/opt/sqlite/lib/libsqlitefunctions.dylib’);
sqlite> select 
load_extension('/usr/local/opt/sqlite/lib/libsqlitefunctions.dylib');

You have to be careful because most modern e-mail clients, unless specifically 
configured otherwise, are designed specifically for sending web-pages 
containing glossy-brochures by SMTP and are not suitable for use in exchanging 
plain-text that must not be tampered with.  In this case the culprit was likely 
a configuration option that substituted "pretty quotes" and "apostrophes" for 
functional quotes.  You can tell because the pretty-quotes are, well, pretty 
and curvy, such as are around your original “median”, while actual quotes 
that-do-something (other than look pretty) do not have curves:  "median".  The 
same mis-feature also changes single-quotes ' into apostrophes ’ in the 
circumstances it thinks such changes are appropriate depending on its 
substitution rules.

> -Original Message-
> From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org]
> On Behalf Of Ronald Gombach
> Sent: Wednesday, 23 November, 2016 04:57
> To: SQLite mailing list
> Subject: Re: [sqlite] SQLite binary with Math Functions for OS-X?
> 
> David,
> 
> The brew/install worked and created the sqlite app and library in the
> locations specified in your instructions.
> 
> I can load the math lib from the .load (dot load) command line,
> The median function works as I wanted
> 
> but the ‘load_extension’ select statement did not work; I get a command
> entry continuation line as follows
> 
> sqlite> select
> load_extension('/usr/local/opt/sqlite/lib/libsqlitefunctions.dylib’);
>…>
> 
> I need to be able to load the extension from within a PHP script
> 
> Thoughts?
> 
> Thanks.
> 
> Ron Gombach
> mailto:ron...@gombach.com <mailto:ron...@gombach.com>
> 
> 
> > On Nov 21, 2016, at 12:15 PM, David Goldwich
> <david.goldwich+sql...@gmail.com> wrote:
> >
> > 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
> 
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users



___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

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

[Ronald Gombach]

David,

The brew/install worked and created the sqlite app and library in the locations 
specified in your instructions.

I can load the math lib from the .load (dot load) command line,
The median function works as I wanted

but the ‘load_extension’ select statement did not work; I get a command entry 
continuation line as follows

sqlite> select 
load_extension('/usr/local/opt/sqlite/lib/libsqlitefunctions.dylib’);
   …>

I need to be able to load the extension from within a PHP script

Thoughts?

Thanks.

Ron Gombach
mailto:ron...@gombach.com 


> On Nov 21, 2016, at 12:15 PM, David Goldwich 
>  wrote:
> 
> 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

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

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] SQLite binary with Math Functions for OS-X?

[Roman Fleysher]

Can't you count how many rows there are and then sort by the variable of 
interest, limiting output to half the count, all within SQL?

Roman



Sent from my T-Mobile 4G LTE Device


 Original message 
From: Ronald Gombach 
Date: 11/21/16 7:12 AM (GMT-05:00)
To: sqlite-users@mailinglists.sqlite.org
Subject: [sqlite] SQLite binary with Math Functions for OS-X?

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).

Thanks for any info you can share.

Ron Gombach
ron...@gombach.com 
The Gombach Group
Morrisville, PA
215-295-6555

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users