[GRASS-user] log function for SQLite

[Markus Neteler]

On Wed, Mar 8, 2017 at 11:26 AM, Nikos Alexandris
<nik at nikosalexandris.net> wrote:
> NikosAlexandris wrote:
>
>>>> Dear list,
>>>>
>>>> where is the extension for SQLite that contains the (mathematical) log
>>>> function available to download?  As referenced in
>>>> https://grass.osgeo.org/grass73/manuals/v.db.update.html.
>
>
> Helmut Kudrnovsky:
>
>>>> I think the reference in the manual requires a source or a link to it.
>>>
>>>
>>> just found something in the wiki:
>>>
>>> https://grasswiki.osgeo.org/wiki/Build_SQLite_extension_on_windows
>
>
> For Linux:

Now also here:

https://grasswiki.osgeo.org/wiki/Build_SQLite_extension_on_Linux

> 1) there is still a "compile" warning for the code (no time to hunt)

This version contains three changes compared to the original version,
maybe useful?
https://raw.githubusercontent.com/seth/RSQLite.extfuns/master/src/extension-functions.c

> 2) The log() function does not like, naturally, 0 values. But this can
> be workedaround with a where SQL clause.

To be added to the manual page.

...
>> (
>> I can't say I didn't search (20+ minutes). There is no related "log"
>> result that leads to that "contrib" page from within SQLite's page
>> search field itself!  And, in our wiki I admit I did not think about
>> Windows at all.
>> )

We need more volunteers to document stuff.

Markus